首页计算机考试Oracle认证
(多选题)

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()

A open the database with the RESTRICTED option

B open the database with the RESETLOGS option

C recover to the required SCN only that data file in which the error occurred

D recover all the data files to the same system change number (SCN)

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()

    答案解析

  • (单选题)

    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()  

    答案解析

  • (多选题)

    Which are the prerequisites for performing flashback transactions on your database?()

    答案解析

  • (单选题)

    If you create your database using Oracle Managed Files (OMF), what is true?()

    答案解析

  • (单选题)

    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()

    答案解析

  • (单选题)

    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?()  

    答案解析

  • (单选题)

    Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()

    答案解析

  • (单选题)

    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()

    答案解析

  • (单选题)

    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()

    答案解析

  • (多选题)

    You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()

    答案解析

快考试在线搜题