View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:
SQL> CREATE TABLE emp
(empno NUMBER(3),
ename VARCHAR2(20),
sal NUMBER(8,2));
SQL> INSERT INTO emp(empno,ename) VALUES(1,'JAMES');
At this moment, a second user also logs in to the HR schema and issues the following command:
SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);
What happens in the above scenario?（）

多项选择题Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)

A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing.
D. The archived log files are missing for which backup is not available.

多项选择题Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog？（）

A. RECOVERY_CATALOG_OWNER
B. DBA
C. RESOURCE
D. SELECT ANY DICTIONARY
E. CONNECT

单项选择题You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）

A. parallel image copy backup
B. backup with MAXPIECESIZE configured for the channel
C. parallel backup with MAXPIECESIZE configured for the channel
D. intrafile parallel backup

单项选择题Which statement is true regarding virtual private catalogs?（）

A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B. The virtual private catalog owner cannot create and modify the stored scripts.
C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

多项选择题WhatisthepurposeoftheRMANrecoverycatalog？（）

A. It must be used because all RMAN-related backup and recovery metadata information is contained in it.
B. It provides a convenient， optional， repository of backup- and recovery-related metadata.
C. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.
D. It provides a means of storing all RMAN backup sets physically in an Oracle database server. 
E. It provides the ability to store backup records for more than a year.