单选题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 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. AB. BC. CD. D

2.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 morningB、 until that point in time when the database is openedC、 until that point in time when the recovery is performedD、 until last Sunday’s backupE、 until that point in time when the table is dropped and purgedF、 until Wednesday evening

3.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.

4.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.

更多“单选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）

    • A、 all the datafiles in the database
    • B、 the datafiles associated with the SYSTEM tablespace
    • C、 the datafiles associated with the DATA1 tablespace
    • D、 all the datafiles in the database except those associated with the DATA1 tablespace

    正确答案:D

  • 第5题：

    Your network has a single domain with 1，000 client computers that run Windows 7.   You use Microsoft System Center Configuration Manager 2007 to distribute and install software applications.   All users have standard user accounts.   You plan to use Group Policy to ensure that application installation functions properly.    You need to design the User Account Control （UAC） policy. What should you do？（）

    • A、 Configure the User Account Control： Only elevate executables that are signed and validated setting to be Enabled.
    • B、 Configure the User Account Control： Detect application installations and prompt for elevation setting to be Enabled.
    • C、 Configure the User Account Control： Detect application installations and prompt for elevation setting to be Disabled
    • D、 Configure the User Account Control： Behavior of the elevation prompt for standard users setting to be Prompt for credentials.

    正确答案:C

  • 第6题：

    单选题
    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
    解析： 暂无解析

  • 第7题：

    单选题
    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


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    Your network has a single domain with 1，000 client computers that run Windows 7.   You use Microsoft System Center Configuration Manager 2007 to distribute and install software applications.   All users have standard user accounts.   You plan to use Group Policy to ensure that application installation functions properly.    You need to design the User Account Control （UAC） policy. What should you do？（）
    A

     Configure the User Account Control： Only elevate executables that are signed and validated setting to be Enabled.

    B

     Configure the User Account Control： Detect application installations and prompt for elevation setting to be Enabled.

    C

     Configure the User Account Control： Detect application installations and prompt for elevation setting to be Disabled

    D

     Configure the User Account Control： Behavior of the elevation prompt for standard users setting to be Prompt for credentials.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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/x7fmanaged 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 last Sunday’s backup

    C

    until Wednesday evening

    D

    until that point in time when the database is opened

    E

    until that point in time when the recovery is performed

    F

    until that point in time when the table is dropped and purged


    正确答案： F
    解析： 暂无解析

  • 第12题：

    单选题
    You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday.  How will you recover the dropped table， SCOTT.EMPLOYEE？（）
    A

     by using the Flashback Table feature

    B

     by using the Flashback Database feature

    C

     by performing incomplete recovery using RMAN utility

    D

     by performing incomplete recovery using user-managed recovery


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You are the administrator of your company’s network. An employee named Mark is leaving the company. A new employee named Eric has been hired to replace him. Mark has a local user account on a Windows 2000 Professional computer. Mark has rights to multiple files and folders on the computer.  You want Eric to have the same rights and permissions that Mark has. You want to ensure that Mark will no longer have access to the files and folders. You want to accomplish this with least administrative effort. What should you do?（）

    • A、Rename Mark’s user account to Eric and change the account password.
    • B、Create Eric’s account by copying Mark’s profile to Eric’s account. Delete Mark’s account.
    • C、Create Eric’s account by copying Marks account. Delete Mark’s account.
    • D、Delete Mark’s account. Add Eric’s account. Add Eric to the same groups to which Mark belonged. Grant Eric to all the individual user rights and permissions that Mark had.

    正确答案:A

  • 第17题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第18题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    You are the administrator of your company’s network. An employee named Mark is leaving the company. A new employee named Eric has been hired to replace him. Mark has a local user account on a Windows 2000 Professional computer. Mark has rights to multiple files and folders on the computer.  You want Eric to have the same rights and permissions that Mark has. You want to ensure that Mark will no longer have access to the files and folders. You want to accomplish this with least administrative effort. What should you do?（）
    A

    Rename Mark’s user account to Eric and change the account password.

    B

    Create Eric’s account by copying Mark’s profile to Eric’s account. Delete Mark’s account.

    C

    Create Eric’s account by copying Marks account. Delete Mark’s account.

    D

    Delete Mark’s account. Add Eric’s account. Add Eric to the same groups to which Mark belonged. Grant Eric to all the individual user rights and permissions that Mark had.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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？（）
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： F
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）
    A

     all the datafiles in the database

    B

     the datafiles associated with the SYSTEM tablespace

    C

     the datafiles associated with the DATA1 tablespace

    D

     all the datafiles in the database except those associated with the DATA1 tablespace


    正确答案： D
    解析： 暂无解析

相关内容