出自:Oracle认证

Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?（）
A:REF 
B:TABLE 
C:CLOB 
D:VARRAY
Which four are valid Oracle constraint types? （）
A:CASCADE
B:UNIQUE
C:NONUNIQUE
D:CHECK
E:PRIMARY KEY
F:CONSTANT
G:NOT NULL
Given: What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes and prints "running".
D:The code executes and prints "runningrunning".
E:The code executes and prints "runningrunningrunning".
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
A: multiplexed control files
B: RMAN obsolete backups
C: multiplexed online redo log files
D: archived redo logs that have not been copied to tape
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
A:Restore the backup control file and open the database with RESETLOGS option.
B:Perform point-in-time recovery because flashback cannot be performed again on this table
C:Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D:Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
A:SYSTEM 
B:OUTLN 
C:INTERNAL 
D:SYS
NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracle‟s order of precedence: （） a. Default setting b. Client environment variable c. Explicit ALTER SESSION statement d. Inside SQL function e. Server initialization parameter
A:b, d, e, a, c
B:e, a, b, c, d
C:d, c, b, e, a
D:a, b, d, c, e
E:d, c, b, a, e
What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?（）
A:Channel failover
B:Restartable backups 
C:Rescheduable backups 
D:Automatic backup recovery 
E:Channel recovery
Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）
A:CKPT
B:SMON
C:LGWR
D:DBWn
E:ARCn
The EMPLOYEE tables has these columns: You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）
A:SELECT last_name, (salary * 12) * commission_pct   FROM EMPLOYEES;
B:SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0)   FROM EMPLOYEES;
C:SELECT last_name, (salary * 12) * NVL2(commission_pct, 0)   FROM EMPLOYEES;
D:SELECT last_name, (salary * 12) * NVL(commission_pct, 0)   FROM EMPLOYEES;
Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? （）
A:SER_NO
B:ORDER_ID
C:STATUS
D:PROD_ID
E:ORD_TOTAL
F:Composite index on ORDER_ID and ORDER_DATE
You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur（）
A:7， 1， 5， 2， 3， 6， 4
B:1， 5， 7， 2， 3， 6； step 4 is not required
C:7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from =>> http：//www.amaderforum.com
D:1， 2， 3， 5， 6， 4； step 7 is not required
Which view provides information on the backup status of the datafiles in the database？（）  
A: V$BACKUP
B: V$BACKUP_STATUS
C: V$BACKUP_DATAFILE
D: V$DATAFILE_BACKUP
E: V$TABLESPCE_BACKUP
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）
A:New channels for restore and recovery tasks
B:New name for the data files of the tablespace
C:Auxiliary name for the data files of the tablespace
D:Auxiliary destinations for an auxiliary set of data files
Given: Which code, inserted at line 4, guarantees that this program will output [1, 2]（）?
A:Set set = new TreeSet();
B:Set set = new HashSet();
C:Set set = new SortedSet();
D:List set = new SortedList();
E:Set set = new LinkedHashSet();
Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?（）
A:Stored scripts in the recovery catalog
B:Backups that can be deleted from disk
C:Backup sets and images copies that are obsolete
D:Backups that do not have the AVAILABLE status in the RMAN repository
View the Exhibit1， which shows the options that are selected to create the user SL_REP. View the Exhibit2 andexamine the contents of DATABASE_PROPERTIES.  Which two statements are true regarding this user（）
A:The user is authenticated by the operating system.
B:The objects created by the user are placed in the USERS tablespace.
C:The user does not require quota on the TEMP tablespace to perform sort operations.
D:The user is forced to change the password at the first login to the database instance.
E:The objects created by the user in future are unlocked to be accessed by all the users in the database bydefault.
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno；  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session（）
A:LOCK TABLE emp IN SHARE MODE；
B:LOCK TABLE emp IN EXCLUSIVE MODE；
C:UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；
D:INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
E:SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCEroles and no individual system privileges. The SL_REP user executes this command to create a table:SQL> CREATE TABLE orders(oid number(6), odate date, ccode number(4), oamt number(10,2))TABLESPACE purchase_space; The PURCHASE_SPACE tablespace already exists in the database.  Which statement describes the effect ofthe command（）
A:The command executes successfully and creates the table in the USERS tablespace.
B:The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C:The command produces an error because the user does not have the privilege to create the table.
D:The command produces an error because the user does not have quota in the PURCHASE_SPACEtablespace.
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.  Which statement is true in this situation（）
A:The online redo log files and archived redo log files are required to accomplish the recovery.
B:The uncommitted transaction will be committed at the next startup of the database instance.
C:The uncommitted transaction is rolled back automatically at the next opening of the database.
D:The DBA has to perform the recovery on the database to recover the uncommitted transaction.
The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）
A:SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
B:SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
C:SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
D:SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;
Examine the following command：   ALTER DISKGROUP data MOUNT FORCE；   In which scenario can you use the above command to mount the disk group？（）  
A: when ASM disk goes offline
B: when one or more ASM files are dropped
C: when some disks in a disk group are offline
D: when some disks in a failure group for a disk group are rebalancing
Which three data sources integrations are provided by Coherence out of the box ？ （）
A: TopLink Grid and TopLink Essentials
B: Java Persistence API （JPA）
C: Open Database Connectivity （ODBC）
D: FileSystem
E: Java Database Connectivity （JDBC） 
程序全局区（PGA）由哪几个部分组成？各部分存放信息的类型是什么？
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）
A:SYS.SOURCE$ 
B:SYS.AUD$ 
C:DBA_SOURCE 
D:DBA_AUDIT_TRAIL
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: What happens when the whole CONTROLLER1 Failure group is damaged?（）
A:The transactions that use the disk group will halt.
B:The mirroring of allocation units occurs within the CONTROLLER2 failure group.
C:The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
D:The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? （）
A:You cannot roll back this statement.
B:All pending transactions are committed.
C:All views based on the DEPT table are deleted.
D:All indexes based on the DEPT table are dropped.
E:All data in the table is deleted, and the table structure is also deleted.
F:All data in the table is deleted, but the structure of the table is retained.
G:All synonyms based on the DEPT table are deleted.
Which two statements about subqueries are true? （）
A:A single row subquery can retrieve data from only one table.
B:A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
C:A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.
D:A single row subquery can retrieve data from more than one table.
E:A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F:A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
Which script must you to query to display the code associated with RMAN stored scripts？（）
A:RC_STORED_SCRIPT
B:RC_STORED_SCRIPT_LINE
C:RC_SCRIPTS
D:RC_STORED_LINE_SCRIPT
E:None of the other alternatives apply
Following is the list of locations in random order where oranfstab can be placed.   1./etc/mtab  2.$ORACLE_HOME/dbs/oranfstab  3./etc/oranfstab   What is the sequence in which Direct NFS will search the locations？（）  
A: 1，2，3
B: 3，2，1
C: 2，3，1
D: 1，3，2
首页 <上一页 1 2 3 4 5 下一页> 尾页