User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）

相似题目

• The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）

  A . GRANT select ON dept TO ALL_ USER; B . GRANT select ON dept TO ALL; C . GRANT QUERY ON dept TO ALL_USERS D . GRANT select ON dept TO PUBLIC

  查看最佳答案

• The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following  GRANT command：  GRANT ALL   ON orders， order_items   TO PUBLIC；   What correction needs to be done to the above statement？ （）

  A .  PUBLIC should be replaced with specific usernames. B .  ALL should be replaced with a list of specific privileges. C .  WITH GRANT OPTION should be added to the statement. D .  Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.

  查看最佳答案

• You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）

  A . by using the ANALYZE utility B . by using the DBVERIFY utility C . by using the DB_BLOCK_CHECKING parameter D . by using the DBMS_REPAIR package

  查看最佳答案

• You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）

  A .  All the objects of scott are moved to the Recycle Bin. B .  Any objects in the Recycle Bin belonging to scott are purged. C .  All the objects owned by scott are permanently dropped from the database. D .  All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E .  Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

  查看最佳答案

• User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)

  A . ALTER DATABASE FLASHBACK ON; B . GRANT SELECT any transaction TO scott; C . GRANT EXECUTE ON dbms_flashback TO scott; D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; E . ALTER TABLESPACE undots1 RETENTION GUARANTEE; F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS

  查看最佳答案

• You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

  A . All the objects of scott are moved to the Recycle Bin. B . Any objects in the Recycle Bin belonging to scott are purged. C . All the objects owned by scott are permanently dropped from the database. D . All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E . Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

  查看最佳答案

• You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task（）

  A . FULL B . SCHEMAS C . TRANSFORM D . REMAP_SCHEMA E . REMAP_TABLESPACE

  查看最佳答案

• An administrator received a call from a user whose PC crashed while using vi to edit a file. The user wants the edited file back. Where should the administrator look for the file（）

  A . /tmp B . /var/preserve C . /var/tmp/$USER D . $HOME/.vi

  查看最佳答案

• Which attribute is used to pass the user role back to the Nexus when remote AAA is enabled？（）

  A .  Cisco AV-pair B .  TACACS+ or RADIUS ack frame role attribute C .  DH-CHAP challenge attribute D .  privilege level attribute

  查看最佳答案

• You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）

  A . FULL B . SCHEMAS C . REMAP_SCHEMA D . REMAP_DATAFILES E . REMAP_TABLESPACE

  查看最佳答案

• You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）

  A .  You must enable the row movement on the SCOTT.EMP table. B .  You must define the tablespace of the SCOTT.EMP table for automatic segment space management. C .  You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement. D .  You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

  查看最佳答案

• A  user  wants  to  be  permanently  added  to  the  dba  group.  Which  of  the  following  commands  or processes can be used to accomplish this（）

  A . chgrp B . chuser C . edit /etc/user D . edit /etc/security/grou

  查看最佳答案

• You want users to log on to Active Directory by using a new User Principal Name （UPN）.  You  need to modify the UPN suffix for all user accounts.     Which tool should you use（）

  A . Dsmod B . Netdom C . Redirusr D . Active Directory Domains and Trust

  查看最佳答案

• User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

  A .  ALTER DATABASE FLASHBACK ON B .  GRANT SELECT any transaction TO scott C .  GRANT EXECUTE ON dbms_flashback TO scott D .  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA E .  ALTER TABLESPACE undots1 RETENTION GUARANTEE F .  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

  查看最佳答案

• Which substitution variable would you use if you want to reuse the variable without prompting the user each time? （）

  A . & B . ACCEPT C . PROMPT D . &&am

  查看最佳答案

• You want to use Windows 2000 backup to perform a weekly backup of the user data on a Windows 2000 Professional computer. You want to ensure that the registry， boot files and COM plus objects are also backed up. What should you do？（）

  A . Configure the Windows backup to backup the system partition. B . Configure the Windows backup to backup the System State Data. C . Create a script written in MS Visual Basic scripting addition language to run rdisk.exe/s before the back up starts. D . Create a batch file to run rdisk.exe/s before the backup starts.

  查看最佳答案

• You want users to log on to Active Directory by using a new User Principal Name （UPN）.    You need to modify the UPN suffix for all user accounts.  Which tool should you use（）

  A . Dsmod B . Netdom C . Redirusr D . Active Directory Domains and Trust

  查看最佳答案

• User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

  A . null lock on the row being updated B . null lock on the table containing the row C . ROW SHARE lock for the row being updated D . ROW EXCLUSIVE lock for the row being updated E . shared row-exclusive lock for the row being updated F . a shareable table lock for the table containing the row G . exclusive table-level lock for the table containing the row

  查看最佳答案

• You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.  Which option of IMPDP would you use to accomplish this task（）

  A . FULL B . SCHEMAS C . TRANSFORM D . REMAP_SCHEMA E . REMAP_TABLESPACE

  查看最佳答案

• Which two applications can be used by a user to report emergency work， if the user at least wants to report downtime， classify the request， and report actuals？（）

  A .  Job Plan B .  Quick Reporting C .  Labor Reporting D .  Work Order Tracking E .  Assignment Manager

  查看最佳答案

• Mike wants to go back to the computer business.

  查看最佳答案

• If you want him to ________ you the money, you have to prove that you will be able to give it back.

  查看最佳答案

• You want to get your book back, ______ ？

  A．don't you B．do you C．aren't you

  查看最佳答案

• If the guest wants to get back his deposited bag in your cloakroom what would you like to do ?

  查看最佳答案