单选题You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason？（）A None of the SYSAUX occupants can be relocated.B The USERS tablespace is a bigfile tablespace （BFT）.C The united J

第1题：

Which two statements about bigfile tablespaces are true？ （）

• A、The bigfile tablespace have only one data file.
• B、The segment space management is automatic.
• C、The extent management is dictionary managed.
• D、The database can have only one bigfile tablespace.
• E、The bigfile tablespace can be converted to a smallfile tablespace.

第2题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp； Table dropped.  What happens in this scenario？ （）

• A、The table is moved to the SYSAUX tablespace.
• B、The table is moved to the SYSTEM tablespace.
• C、The table is removed from the database permanently.
• D、The table is renamed and remains in the TBSFD tablespace.

第3题：

Which tablespaces are mandatory in an Oracle database for it to be operational（）

• A、Undo tablespace
• B、USERS tablespace
• C、SYSAUX tablespace
• D、SYSTEM tablespace
• E、Temporary tablespace

第4题：

You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

• A、 The index tablespace contains bitmap indexes.
• B、 The index tablespace contains more than one data file.
• C、 The index tablespace supports only complete recovery.
• D、 The index tablespace is not a dictionary-managed tablespace.
• E、 There is a dependency relationship between a table and its indexes.

第5题：

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）

• A、TEST_TBS is a small file tablespace 
• B、TEST_TBS is a bigfile tablespace (BFT)
• C、TEST_TBS is the default temporary tablespace
• D、TEST_TBS is a dictionary-managed tablespace
• E、Threshold values for the TEST_TBS tablespace are not explicitly specified

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason？（）

• A、None of the SYSAUX occupants can be relocated.
• B、The USERS tablespace is a bigfile tablespace （BFT）.
• C、The united Job Scheduler occupant cannot be relocated.
• D、The SYSAUX occupants can be relocated to the SYSTEM tablespace only.

第14题：

Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）

• A、The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
• B、The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
• C、All the components may be moved into SYSAUX tablespace.
• D、All the components may be moved from the SYSAUX tablespace.

第15题：

You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）

• A、The index tablespace contains bitmap indexes.
• B、The index tablespace contains more than one data file.
• C、The index tablespace supports only complete recovery.
• D、The index tablespace is not a dictionary­managed tablespace.
• E、There is a dependency relationship between a table and its indexes.

第16题：

Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）

• A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
• B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
• C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
• D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

第17题：

Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）

• A、 Disable SQL tracing for the APPS tablespace.
• B、 Disable logging attributes for the APPS tablespace.
• C、 Modify the tablespace to be a dictionary-managed tablespace.
• D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
• E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：