FULL
SCHEMAS
REMAP_SCHEMA
REMAP_DATAFILES
REMAP_TABLESPACE
第1题：
You recently upgraded all Windows NT Workstation 4.0 computers to Windows 2000 Professional. You want to give a new employee named Maria the ability to back up files, share resources, and install programs on a client computer that she shares with other users. You do not want Maria to be able to read other users' files.
What should you do to accomplish these goals? (Choose all that apply)
A．Add Maria's user account to the System group.
B．Add Maria's user account to the Interactive group.
C．Add Maria's user account to the Power Users group.
D．Add Maria's user account to the Administrators group.
E．Add Maria's user account to the Backup Operators group.
第2题：
Your network contains a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1 is configured as shown in the following table.A user named User1 belongs to the Helpdesk group and the Support group.You need to configure security to meet the following requirements:·Prevent User1 from changing files and folders in the Apps share.·Allow User1 to open and run applications in the Apps share.What should you do?（）
A. On
the Apps share, assign User1 the Read share permission.
B. On the Apps folder, deny User1 the Write NTFS permission.
C. On the Apps folder, deny User1 the Modify NTFS permission.
D. On the Apps folder, assign User1 the Read & Execute NTFS permission.
第3题：
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.
第4题：
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？（）
第5题：
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
第6题：
A. When you want all unauthenticated traffic to be redirected
B. When you want all clear text traffic to be redirected.
C. When you want all authenticated traffic to be redirected.
D. When you want all encrypted traffic to be redirected.
第7题：
You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）
第8题：
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methodswould you use to achieve this?（）
A. Use Data Pump to transfer the existing data to a new encrypted tablespace
B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace
C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace
E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
第9题：
In which scenario will you use the Flashback Transaction Query feature？（）
第10题：
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（）