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

单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s b

题目
单选题
On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）
A

 Flashback Drop

B

 Flashback Table

C

 Flashback Database

D

 Flashback Version Query

E

 Flashback Transaction Query

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

第1题：

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）

  • A、 until Thursday morning
  • B、 until that point in time when the database is opened
  • C、 until that point in time when the recovery is performed
  • D、 until last Sunday’s backup
  • E、 until that point in time when the table is dropped and purged
  • F、 until Wednesday evening

正确答案:D

第2题：

In which scenario do you use the Flashback Database feature？（）

  • A、 when a table is dropped and you restore it from the Recycle Bin
  • B、 when a user’s schema is dropped and you recover the user’s schema
  • C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
  • D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

正确答案:B

第3题：

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? （）

A. A

B. B

C. C

D. D


参考答案：A

第4题：

In which scenario will you use the Flashback Version Query feature？（）

  • A、 when you want to restore a table that has been dropped from the Recycle Bin
  • B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
  • C、 when you want to recover the schema of a dropped user
  • D、when you want to restore a dropped tablespace

正确答案:B

第5题：

On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）

  • A、Flashback Drop
  • B、Flashback Table
  • C、Flashback Database
  • D、Flashback Version Query
  • E、Flashback Transaction Query

正确答案:C

第6题：

You database operates in ARCHIVELOG mode and user-managed 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 achivelog 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？（）

  • A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
  • B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
  • C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
  • D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.

正确答案:B

第7题：

In which scenario will you use the Flashback Transaction Query feature？（）

  • A、 when you want to restore an important table that is dropped from the Recycle Bin
  • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
  • C、when you want to restore a dropped user’s schema
  • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

正确答案:B

第8题：

You are the administrator of Ezonexam's network.

An employee named Mark has a local user account on a Windows 2000 Professional computer. Mark has rights and permissions to multiple files and folders on the computer. All of Mark's permissions are being granted through group membership. Mark recently hired a new employee named Eric as his assistant.

You want Eric to have the same rights and permissions that Mark has on the Windows 2000 Professional computer. You want to accomplish this with the least amount of administrative effort.

What should you do?

A．Create a new local group. Create Eric's user account. Add Mark's user account and Eric's user account to the new group.

B．Create Eric's user account. Copy Mark's profile to Eric's user account.

C．Create Eric's user account. Make Eric's user account a member of all the same groups as Mark's user account.

D．Create Eric's user account. Copy the registry entries in the subkey that correspond to Mark under HKEY_USERS to the subkey that corresponds to Eric.


正确答案：C
解析：Explanation: Since all Mark's permissions are being granted through group membership, it would be the application of the minimum amount of administrative effort if you are to make Eric's user accounts a member of the same groups as Mark's user account.

Incorrect answers:
A: There is no need to create a new local group and making only Eric and Mark's user accounts members of this group. This will also work, but it involves unnecessary administrative effort since there are already groups that contain the permissions as needed.

B: When copying, you might loose permissions.

D: This option is not the solution since it suggests too much administrative effort.

第9题：

What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）

  • A、 The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are  already in the Recycle Bin are dropped.
  • B、 The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.
  • C、 The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.
  • D、 The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.

正确答案:D

第10题：

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

  • A、 UNTIL SEQUENCE
  • B、 UNTIL SCN
  • C、 UNTIL CHANGE
  • D、 UNTIL CANCEL

正确答案:C,D

更多相关问题
相关内容