题目内容（请给出正确答案）

[主观题]

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of t

he 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.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装赏学吧APP，拍照搜题省时又省心！

更多“Your database is running in AR…”相关的问题

第1题

Your multitenant container database （CDB) is running in ARCHIVELOG mode. You connect to th

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up？（）

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED

点击查看答案

第2题

You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set？（）

A. Enable the flash recovery area and specify it as the archived redo log destination.

B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

C.Enable the flash recovery area but do not specify it as the archived redo log destination.

D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

点击查看答案

第3题

You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. （Choose two.)（）

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup

点击查看答案

第4题

You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup

点击查看答案

第5题

The database is running in the ARCHIVELOG mode. It has three redo log groups with one memb

er each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command？（）

A. You should perform a log switch

B. You should make a backup of the database

C. You should switch the database to the NONARCHIVELOG mode

D. You should shut down the database instance and perform a complete database recovery

点击查看答案

第6题

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)？ (Choose Three)

A. Redo logs

B. Control file

C. The latest backup of only the damaged data file

D. The latest backup of all the data file in the USERS tablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backup to point of failure

点击查看答案

第7题

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)？（）

A. Redo logs

B. Control file

C. The latest backup of only the damaged data file

D. The latest backup of all the data file in the USERS tablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backup to point of failure

点击查看答案

第8题

A database is running in ARCHIVELOG mode and regular backups are performed. A user receive

s the following error message:Which is the recommended sequence of operations you need to perform for the query successfully？（）

A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.

B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.

C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.

D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

点击查看答案

第9题

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which co

ntains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue？（）

A. ALTER DATABASE DROP LOGFILE GROUP 1;

B. ALTER DATABASE CLEAR LOGFILE GROUP 1;

C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG

点击查看答案