出自:Oracle认证

Which statement about recovering from the loss of a redo log group is true?()  
A: If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
B: If the lost redo log group is CURRENT, you must clear the log file.
C: If the lost redo log group is ACTIVE, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.
D: If the lost redo log group is CURRENT, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? ()
A:INSERT INTO employees VALUES (NULL, 'John', 'smith');
B:INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith');
C:INSERT INTO employees VALUES ('1000, 'John', 'smith');
D:INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith');
E:INSERT INTO employees (employee_id) VALUES (1000);
F:INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');
Which two statements are true regarding the ORDER BY clause? ()
A:It is executed first in the query execution 
B:It must be the last clause in the SELECT statement 
C:It cannot be used in a SELECT statement containing a HAVING clause
D:You cannot specify a column name followed by an expression in this clause 
E:You can specify a combination of numeric positions and column names in this clause
You are managing an Oracle Database 11g database with the following backup strategy:  1.On Sunday, an incremental level 0 tape backup is performed.  2.Monday through Saturday, acumulativeincremental level 1 tape backup is performed.  Which two statements are true regarding the backups performed()
A:The backup performed in step 1 backs up all blocks that have ever been in use in the database. 
B:The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
C:The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
D:The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1.
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
A:The retention period to support flashback
B:The expected length of the longest-running query
C:The number of undo tablespaces in the database
D:The size of the Flash Recovery Area for the database instance
Given:   11. public static void main(String[] args) {   12. Object obj = new int[] { 1, 2, 3 };   13. int[] someArray = (int[])obj;   14. for (int i : someArray) System.out.print(i + " ");   15. }   What is the result? ()
A: Compilation fails because of an error in line 13.
B: A ClassCastException is thrown at runtime.
C: 1 2 3
D: Compilation fails because of an error in line 14.
E: Compilation fails because of an error in line 12.
You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.()
A:The data file backup is done with multiple channels
B:The data files is in the read-write mode after being backed up in the read only mode
C:The backup was taken after the data files was taken offline-normal or is in the read only mode
D:The data file backup complies with the back retention policy and the backup duplexing feature
The details of the order ID, order date, order total, and customer ID are obtained from the ORDERS table. If the order value is more than 30000, the details have to be added to the LARGEjDRDERS table. The order ID, order date, and order total should be added to the ORDERJHISTORY table, and order ID and customer ID should be added to the CUSTJHISTORY table.   Which multitable INSERT statement would you use? ()
A: Pivoting INSERT
B: Unconditional INSERT
C: Conditional ALL INSERT
D: Conditional FIRST INSERT
Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically?()
A:FIND_REPORT_OBJECT 
B:CANCEL_REPORT_OBJECT 
C:REPORT_OBJECT_STATUS 
D:SET_PROPERTY OBJECT_PROPERTY
A file system has been corrupted and needs to be restored.  Which file contains the ufsdump levels for this file system? ()
A: /etc/backup
B: /etc/ufsdump
C: /etc/dumpdates
D: /etc/fsdumpdates
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently, several users are executing long-running queries on the database. What will happen to the ongoing activity in the database?()
A: The queries that are currently executing will abort and an error message will be returned to the user.
B: The queries that are currently executing will execute normally but future queries will not executed.
C: Data Manipulation Language (DML) statements cannot be performed on the tables on which the indexes are based.
D: The currently executing and future queries will execute normally, but will be slower
In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?()
A:flash back the database
B:perform point-in-time recovery
C:perform a full database recovery
D:drop and re-create the tablespace
E:use Recovery Manager (RMAN) to recover the database
Click the Exhibit button.   Given: Which two statements are true if a NullPointerException is thrown on line 3 of class C?()
A: The application will crash.
B: The code on line 29 will be executed.
C: The code on line 5 of class A will execute.
D: The exception will be propagated back to line 27.
E: The code on line 5 of class B will execute.
When should you create a role?()
A:To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
B:To grant a group of relate privileges to a user.
C:When the number of people using the database is very high.
D:To simplify the process of granting and revoking privileges.
E:To simplify profile maintenance for a user who is constantly traveling.
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?()
A:alter tablespace DAVE_TBS backup mode
B:alter tablespace DAVE_TBS start backup 
C:alter tablespace DAVE_TBS begin backup 
D:alter tablespace DAVE_TBS backup begin 
E:alter tablespace DAVE_TBS backup
You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.  Which command would you execute to proceed further?()
A:RECOVER LOFIEL BLOCK GROUP 2;
B:ALTER DATABASE DROP LOGFILE GROUP 2;
C:ALTER DATABASE CLEAR LOGFILE GROUP 2;
D:ALTER DATABASE RECOVER LOGFILE GROUP 2;
E:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
Which /SQL*Plus feature can be used to replace values in the WHERE clause?()
A:Substitution variables
B:Replacement variables
C:Prompt variables
D:Instead-of variables
E:This feature cannot be implemented through /SQL*Plus.
Which of the following options describes Segment Shrink?()  
A: Reclaims space above and below the high-water mark without using additional space
B: Moves rows to a new physical location,resetting the high-water mark,but uses additional space during the operation
C: Deallocates space above the high-water mark that is currently not in use
D: None of the above
View the Exhibit and examine the Flashback Database architecture.  Identify the missing component (shown with a "?") in the Flashback Database architecture.()
A:DBWn
B:RVWR
C:ARCH
D:RECO
E:TRWR
Which of the following represents the correct sequence of events for Database Replay?()
A: Capture,analyze,preprocess,replay
B: Capture,preprocess,analyze,replay
C: Capture,preprocess,replay,analyze
D: Analyze,capture,preprocess,replay
E: None of the above
You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:   ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;   Which statement is true in this scenario?()
A: It starts the ASM fast mirror resync.
B: All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
C: It drops all disk paths from the dga disk group.
D: All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()
A:RMAN image copies
B:RMAN database backups
C:RMAN tablespace backups
D:user­managed backups placed in the flash recovery area
E:user­managed backups that have been cataloged with RMAN
F:user­managed data file backups for which the full path name is specified
Which is the correct command to put the database in ARCHIVELOG mode?()  
A: alter database archivelog
B: alter system enable archivelog mode
C: alter database enable archive
D: alter database archivelog enable
E: None of the above
Examine the parameter setting in your database: Which statement is correct about the database?()
A:Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
B:The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
C:The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
D:Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
Which of the following Oracle features utilize the undo tablespace?() 
A: Flashback Query
B: Flashback Drop
C: Flashback Table
D: Flashback Database
E: Transaction Processing
F: Recycle Bin
RMAN provides more granular catalog security through which feature?()
A:Virtual private database
B:Virtual private catalog
C:RMAN virtual database
D:RMAN secure catalog
E:Oracle Database Vault
You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?()
A:MERGE
B:SELECT …CROSS JOIN
C:INSERT ALL …SELECT
D:CREATE VIEW …CONSTRAINT
You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true?()
A:The database crashes.
B:The DBA needs to re-create the file.
C:The file gets re-created automatically.
D:The file gets restored automatically from the last backup.
E:The DBA needs to perform a complete database recovery.
F:The DBA needs to perform an incomplete database recovery.
Which phrase best describes RMAN multiplexed backup sets?()
A:Stripes a single backup set across multiple channels.
B:Identical copies of backup pieces within a backup set.
C:Multiple backup sets with multiple channels configured.
D:Simultaneous reads from multiple files and writes into the same backup piece.
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