Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）..

第1题

[] Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

A、A. Oracle Net Manager B、B. Listener Control utility C、C. Database Configuration Assistant D、D. Oracle Net Configuration Assistant

点击查看答案

第2题

[单选题] The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）

A、Create two custom ADDM tasks. B、Modify the AWR snapshot time interval to two hours. C、Create a new scheduler window for a time period of two hours. D、Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

点击查看答案

第3题

[] Your database runs in ARCHIVELOG mode， and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this？（） Your database runs in ARCHIVELOG mode， and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this？（）

A、A.A B、B.B C、C.C D、D.D

点击查看答案

第4题

[] Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（） Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）

A、A. The command restores only the missing control file. B、B. The command restores all the control files. C、C. The command fails because the database is running. D、D. This is the correct way to address this problem. E、E. This is not the correct way to address this problem.

点击查看答案

第5题

[单选题] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、You must have change tracking enabled in your database B、Your database must be running in NOARCHIVELOG mode C、To back up a tablespace, it must be in backup mode D、To back up a tablespace, it must first be taken offline

点击查看答案

第6题

[] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（） You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、A. You must have change tracking enabled in your database B、B. Your database must be running in NOARCHIVELOG mode C、C. To back up a tablespace, it must be in backup mode D、D. To back up a tablespace, it must first be taken offline

点击查看答案

第7题

[] The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do？（） The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a&

A、A. Create two custom ADDM tasks. B、B. Modify the AWR snapshot time interval to two hours. C、C. Create a new scheduler window for a time period of two hours. D、D. Modify the Automatic Workload Repository （AWR） snapshot retention period to two hours.

点击查看答案

第8题

[单选题] Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

A、The DATA1 tablespace is automatically taken out of backup mode when the instance aborts. B、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened. C、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted. D、If you restart the database, the database will not be opened.

点击查看答案

第9题

[单选题] Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

A、The DATA1 tablespace is automatically taken out of backup mode when the instance aborts. B、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened. C、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted. D、If you restart the database, the database will not be opened.

点击查看答案

第10题

[单选题] Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）

A、only the control file, the current SPFILE, and data files B、only the current SPFILE and data files if autobackup is disabled C、only the data files and the archived redo logs D、the control file, current SPFILE file, data files, and archived redo logs

点击查看答案

请使用微信扫码支付