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

Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8:30 a.m. With reference to this scenario, what would you do to recover the database?()

Arestore all the data files from last Sunday’s backup, and then perform a time­based recovery

Brestore all the data files from last Sunday’s backup, and then perform a cancel­based recovery

Crestore all the data files from last Sunday’s backup, and then perform a change­based recovery

Drestore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery

正确答案

来源: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?()

    答案解析

快考试在线搜题