Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）

A . Control files B . Password files C . Inactive online redo log file D . Archived log files required to perform recovery E . Newly created tablespace which is not backed u

A . Its entries are specific to a single database. B . It contains file systems that have been mounted by Direct NFS. C . It is globally available to all Oracle 11g databases on the machine. D . It contains file systems that have been mounted by the kernel NFS system.

A .  You must ensure that the SALES database is mounted or open. B .  You must restore a backup control file to perform a block media recovery. C .  You must take the tools01.dbf data file offline before you start a block media recovery. D .  You must put the database in NOARCHIVELOG mode to perform a block media recovery. E .  You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

A . data files B . control files C . parameter file D . online redo log files E . server parameter file

A .  backup pieces B .  copies of all the parameter files C .  trace file generated using BACKUP CONTROLFILE TO TRACE D .  control file autobacku

A . NOCHECKSUM B . MAXCORRUPT C . CHECK LOGICAL D . BACKUP INCREMENTAL E . CONFIGURE DEVICE TYPE ... PARALLELISM

A .  DB_CREATE_FILE_DEST B .  DB_RECOVERY_FILE_DEST C .  DB_RECOVERY_FILE_DEST_SIZE D .  DB_ONLINE_LOG_DEST_

A .  Control files B .  Password files C .  Inactive online redo log file D .  Archived log files required to perform recovery E .  Newly created tablespace which is not backed u

A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."  E . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

A . backup pieces B . control file autobackups C . copies of all the parameter files D . trace file generated using BACKUP CONTROLFILE TO TRACE

A . After the COPY command. B . After adding a data file in the target database. C . After adding a tablespace in the target database. D . After adding a tablespace in the catalog database. E . After dropping a data file in the catalog database. F . After running SQL Loader to load a large amount of data.

A . a tablespace is taken offline B . the database instance is restarted C . a new data file is added to an existing tablespace D . a successful backup is recorded in the RMAN repository E . the RMAN connection is disconnected from the target database

A . Restore the data file and perform incomplete recovery. B . Restore the data file and perform point-in-time recover. C . Drop the tablespace and lose all data in the tablespace. D . Restore the database and lose all data since the last backup.

A . adding a new user to the database B . dropping a user from the database C . dropping a table from the database D . dropping a data file from a tablespace E . adding a new tablespace to the database

A .  A tablespace is taken offline. B .  The database instance is restarted. C .  A new data file is added to an existing tablespace. D .  A successful backup is recorded in the RMAN repository. E .  The RMAN connection is disconnected from the target database.

A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

A .  Its entries are specific to a single database. B .  It contains file systems that have been mounted by Direct NFS. C .  It is globally available to all Oracle 11g databases on the machine. D .  It contains file systems that have been mounted by the kernel NFS system.

A . You must ensure that the SALES database is mounted or open. B . You must restore a backup control file to perform a block media recovery. C . You must take the tools01.dbf data file offline before you start a block media recovery. D . You must put the database in NOARCHIVELOG mode to perform a block media recovery. E . You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

A . It records the usernames and passwords of users when granted the DBA role. B . It contains the usernames and passwords of users for whom auditing is enabled. C . Is used by Oracle to authenticate users for remote database administration. D . It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups. E . It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

A .  Restore the lost data file from the backup， and then flash back the database. B .  Restore the data file pertaining to index tablespace， and then recover the tablespace. C .  Restore all the data files， and then perform an incomplete recovery to get the tablespace back. D .  Restore all the data files， and then perform an incomplete recovery using the backup control file. E .  Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated." E . Rebuilding an index using ALTER INDEX ...REBUILD fails with an error "ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.

A . the alert log file B . the core dump files C . the change tracking file D . the user session trace files E . the database audit trail files F . the background process trace file

<img src='https://img2.soutiyun.com/shangxueba/ask/64233001-64236000/64234478/9691c5b47b07d813739fc0e9660c9439.jpg' /> A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively