The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)..

第1题

[单选题] The ping loopback hangs with no output.Which of the following is the most likely cause?（）

A、The loopback interface is down and resolv.conf is configured. B、The loopback is not in /etc/hosts and resolv.conf is configured. C、The loopback interface is down and resolv.conf is not configured. D、The loopback is not in /etc/hosts and resolv.conf is not configured.

点击查看答案

第2题

[单选题] The ping loopback hangs with no output. Which of the following is the most likely cause？（）

A、The loopback interface is down and resolv.conf is configured. B、The loopback is not in /etc/hosts and resolv.conf is configured. C、The loopback interface is down and resolv.conf is not configured. D、The loopback is not in /etc/hosts and resolv.conf is not configured.

点击查看答案

第3题

[单选题] The ping loopback hangs with no output. Which of the following is the most likely cause？（）

A、The loopback interface is down and resolv.conf is configured. B、The loopback is not in /etc/hosts and resolv.conf is configured. C、The loopback interface is down and resolv.conf is not configured. D、The loopback is not in /etc/hosts and resolv.conf is not configured.

点击查看答案

第4题

[单选题] You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A、Mount the database B、Open the database in NORMAL mode C、Open the database in RESTRICTED mode D、Open the database with the RESETLOGS option

点击查看答案

第5题

[单选题] You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A、Mount the database B、Open the database in NORMAL mode C、Open the database in RESTRICTED mode D、Open the database with the RESETLOGS option

点击查看答案

第6题

[单选题] Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: Which statement is true about the duplicate database in this scenario?（）

A、It contains data till the last backup B、It contains all data from target database until the current time C、It contains all data from only the committed transactions in the target database D、It contains all data except that which is used by the transactions in the current online redo file of target database

点击查看答案

第7题

[多选题] You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

A、The source database backup must be copied over the net for test database. B、The source database must be run in ARCHIVELOG mode if the database is open. C、The source database must be shut down cleanly if the database is in mounted state. D、A net service name should be set up and a listener configured with the target as well as the source database.

点击查看答案

第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题

[多选题] In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）

A、The C # # ROLE1 role is created in the root database and all the PDBs. B、The C # # ROLE1 role is created only in the root database because the container clause is not used. C、Privileges are granted to the C##A_ADMIN user only in the root database. D、Privileges are granted to the C##A_ADMIN user in the root database and all PDBs. E、The statement for granting a role to a user fails because the CONTAINER clause is not used.

点击查看答案

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)

请使用微信扫码支付