Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows： SQL> DROP TABLE cust_ord PURGE； Table dropped. Client B executes a query at 9：00

题目

Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows： SQL> DROP TABLE cust_ord PURGE； Table dropped. Client B executes a query at 9：00 a.m. on the same table as follows： SQL> SELECT * FROM cust_ord； SELECT * FROM cust_ord *ERROR at line 1：ORA-00942： table or view does not exist Client B needs the dropped table and reports the problem to you.With reference to this scenario， which action should you take？（）

A、 retrieve the table by using the flashback feature
B、 restore all the data files from last Sunday’s backup and then perform a time-based recovery
C、 restore all the data files from last Sunday’s backup and then perform a log sequence recovery
D、 restore all the data files from last Sunday’s backup and then perform a cancel-based recovery
E、 restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery

参考答案和解析

正确答案:B

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

A、The database is in mount state.
B、One of the tablespaces is offline.
C、One of the tablespaces is read only.
D、The database operates in ARCHIEVELOG mode.
E、The database operates in NOARCHIEVELOG mode.

正确答案:E

第2题：

You are working on a new Oracle Database 11g server， where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant （DBCA）. Some of the requirements set for your database creation task are： 1：Configure the database to operate in shared server mode. 2：Disable automatic maintenance tasks such as optimizer statistics collection. 3：Configure a naming method to help the remote user connect to the database instance. 4：Use Automatic Storage Management （ASM） for storing the database files. 5：Configure daily database backup to flash recovery area. 6：Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database（）

A、4 and 6
B、2，3，4，and 6
C、1，2，4，5，and 6
D、1，2，3，4，5，and 6

正确答案:C

第3题：

To get help from a venture-captial company, you may have to__________.

A.put up with unfair terms
B.change your business line
C..enlarge your business scope
D.let them operate your business

答案：A

解析：

文章第二段“But l was warned they took a huge share of company for the money they putin．”可知。投资公司会拿走公司很大一部分股份，因此这种交易是不公平的。故选A项。

第4题：

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）

A、 Yes， if the database is in ARCHIVELOG mode
B、 Yes， if the database is in NOARCHIVELOG mode
C、 No， the backup is not usable in any way
D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

正确答案:C

第5题：

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A、 The database writer writes to a trace file， indicating that the temporary file is not found.
B、 The database prompts for a database recovery.
C、 The database opens normally.
D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.

正确答案:A,C

第6题：

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）

A、 by using the RMAN utility
B、 by using the export/import utility
C、 by using the ALTER DATABASE command
D、 by enabling the change tracking feature

正确答案:C

第7题：

For which database operation would you need the database to be in the MOUNT state（）

A、renaming the control files
B、re-creating the control files
C、dropping a user in your database
D、dropping a tablespace in your database
E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

正确答案:E

第8题：

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）

A、 Restore and recover the datafile.
B、 Restore and recover the tablespace.
C、 Restore and recover the database.
D、 Restore and recover the control file.
E、 Restore and recover the parameter file.

正确答案:A

第9题：

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

A、renaming the control files
B、dropping a user in your database
C、enabling or disabling redo log archiving
D、dropping a tablespace in your database
E、re-creating the control files， after you lost all the control files in your database

正确答案:C

第10题：

You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）

A、the time when the last flashback operation in your database was performed
B、the time when the first flashback operation in your database was performed
C、a list of flashback operations performed in your database using SCN and time
D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

正确答案:D

Your database operate

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容