违法和不良信息举报 联系客服
免费注册 登录

The database is running in NOARCHIVELOG mode. A data file is

题目
多选题
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）
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,B
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

  • A、 Enable flashback logging.
  • B、 Start the database in the ARCHIVELOG mode.
  • C、 Issue the ALTER DATABASE FLASHBACK ON； command.
  • D、 Set the FAST_START_MTTR_TARGET initialization parameter.

正确答案:A

第2题：

you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

  • A、 True
  • B、 False

正确答案:B

第3题：

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


参考答案：A, C, F

第4题：

多选题
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）
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


正确答案： C,D
解析： 暂无解析

第5题：

单选题
Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）
A

You can perform open database backups.

B

You can perform closed database backups.

C

You cannot perform schema-level logical backups.

D

You can perform the backup of only the SYSTEM tablespace when the database is open.


正确答案： D
解析： 暂无解析

第6题：

Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

  • 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

正确答案:D,E

第7题：

Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and 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

正确答案:D

第8题：

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file 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、 temporary files of temporary tablespace
  • D、 the latest backup of only the damaged data file
  • E、 the latest backup of all the data files In the USERS tablespace

正确答案:A,B,D

第9题：

单选题
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and 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


正确答案： D
解析： 暂无解析

第10题：

单选题
Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）
A

until the last commit

B

cannot be recovered

C

until the last offline backup

D

until the beginning of the last transaction


正确答案： C
解析： 暂无解析

更多相关问题
相关内容