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

The database is̳

题目

The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

  • A、until SCN
  • B、until time
  • C、until cancel
  • D、using backup control file
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?()

A.run{openscriptbackup_database；runscriptbackup_database}

B.run{engagescriptbackup_database；}

C.run{runscriptbackup_database；}

D.Run{executescriptbackup_database；}

E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.


参考答案：D

第2题：

Which statement is true about the database and database-user used during installation of IMS Server？（）

  • A、A preexisting database user may be used but a new database has to be created during installation.
  • B、A preexisting database may be used but a new database user has to be created during installation.
  • C、A preexisting database and user may be used or a new database and user are created during installation.
  • D、A preexisting database and user cannot be used； a new database and user are created during  installation.

正确答案:C

第3题：

What two are the prerequisites for enabling Flashback Database?()

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined


参考答案：A, B

第4题：

You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

  • A、 The database must have multiplexed redo log files
  • B、 The database must be in the MOUNT state to execute the command
  • C、 The database must be in the NOMOUNT state to execute the command
  • D、 The database must be opened in RESTRICTED mode before this operation
  • E、 The database must be opened with the RESETLOGS option after the flashback operation

正确答案:B,E

第5题：

Which command is used to open the database after an incomplete recovery？（）

  • A、 alter database open
  • B、 alter database open repairlog
  • C、 alter database open resetlogs
  • D、 alter database open resetlog
  • E、 alter database resetlogs open

正确答案:C

第6题：

Which command do you use to generate a report of database incarnations？（）  

  • A、 list incarnation of database
  • B、 report incarnation of database
  • C、 list database incarnation
  • D、 database incarnation list
  • E、 report database incarnation

正确答案:A

第7题：

What two are the prerequisites for enabling Flashback Database?（） (Choose two)

  • A、The database must be in ARCHIVELOG mode
  • B、The database must be in MOUNT EXCLUSIVE mode
  • C、The database must be opened in RESTRICTED mode
  • D、The database instance must be started in the NOMOUNT state
  • E、The database instance must have the keep buffer pool defined

正确答案:A,B

第8题：

You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）

A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.


参考答案：B

第9题：

If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

  • A、 Complete database recovery.
  • B、 Incomplete database recovery.
  • C、 Approximate database recovery.
  • D、 Archived database recovery.
  • E、 The database could not be recovered with RMAN.

正确答案:B

第10题：

What two are the prerequisites for enabling Flashback Database？（） 

  • A、 The database must be in ARCHIVELOG mode
  • B、 The database must be in MOUNT EXCLUSIVE mode
  • C、 The database must be opened in RESTRICTED mode
  • D、 The database instance must be started in the NOMOUNT state
  • E、 The database instance must have the keep buffer pool defined

正确答案:A,B

更多相关问题
相关内容