多选题While setting up the database for your production environment， you want to create a user with following requirements.  1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object cre

第1题：

To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）  

• A、 The database will open，and the tablespace automatically comes out of the backup mode.
• B、 The database will be mounted，and recovery must be performed on the USERS tablespace.
• C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.
• D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

第2题：

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

• A、Perform Export before TSPITR and Import after TSPITR
• B、Move objects to another schema that has the same tablespace assigned
• C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

第3题：

While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

• A、 A primary key must have been created.
• B、 A mapping table must have been created.
• C、 An overflow tablespace must have been specified.
• D、 The PCTTHRESHOLD option must have been specified.

第4题：

You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）

• A、The tablespace TBS1 is full.
• B、The user is not the owner of the SYSTEM tablespace.
• C、The user does not have quota on the TBS1 tablespace.
• D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
• E、The user does not have sufficient privileges to create table on the default permanent tablespace.

第5题：

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

第6题：

Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）

• A、 The parameter DB_CACHE_SIZE must be a multiple of 8.
• B、 The value of the parameter SGA_MAX_SIZE must be increased.
• C、 The tablespace must be created with a uniform extent size of 8 KB
• D、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.

第7题：

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

• A、The database will open, and the tablespace automatically comes out of the backup mode
• B、The database will be mounted, and recovery must be performed on the USERS tablespace.
• C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
• D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

• A、owner
• B、touser
• C、include
• D、schemas
• E、fromuser
• F、transform
• G、remap_schema
• H、remap_datafile
• I、reuse_datafiles
• J、remap_tablespace

第14题：

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

第15题：

You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）

• A、Use the DROP DATAFILE command.
• B、Use the DROP TABLESPACE command.
• C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
• D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

第16题：

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

第17题：

While setting up the database for your production environment， you want to create a user with following requirements.   1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.   2.The user should be able to use 10MB of space in the tablespace TBS1.   3.The user must change the password immediately after logging in for the first time.   Which three options of the CREATE USER command would you use to achieve this objective？（）

• A、profile
• B、account lock
• C、account unlock
• D、password expire
• E、quota 10MB on TBS1
• F、password never expire
• G、default tablespace TBS1
• H、quota unlimited on TBS1
• I、temporary tablespace TEMP
• J、temporary tablespace SYSTEM

第18题：

Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 （usder_temp） /user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）

• A、 It would result in an error because the template cannot be used along with the disk group.
• B、 It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
• C、 It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
• D、 It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：