单项选择题
Examine the output of the query that you executed to list the objects in the recycle bin:
You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:
SQL> PURGE TABLE sales_tab;
What would be the outcome of this command?（）
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
相关考题
-
多项选择题
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)
A. The databases configured to use the ASM instance are mounted
B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters -
多项选择题
YoudecidedtouseDirectNFSconfigurationinanon-RACOracleinstallationandcreatedtheoranfstabfilein/etc.Whichtwostatementsaretrueregardingthisoranfstabfile？（））
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by the kernel NFS system. -
单项选择题
ENCRYPT_TSisanencryptedtablespacethatcontainstableswithdata.Whichstatementistrueregardingtheeffectofqueriesanddatamanipulationlanguage（DML）statementsontheencrypteddatainthetables？（）
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
