单项选择题
You opened the encryption wallet and then issued the following command：
SQL>CREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M
ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）；
Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome？（）
A. It creates the table and encrypts the data in it.
B. It generates an error because the wallet is closed.
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
相关考题
-
多项选择题
Which statements are true regarding table compression? （）(Choose all that apply.)
A. It saves disk space and reduces memory usage.
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O. -
单项选择题
WhichstatementistrueregardingtheretentionpolicyfortheincidentsaccumulatedintheAutomaticDiagnosticRepository（ADR）？（）
A. The incident metadata is purged when the problem is resolved and the DBA closes the SR
B. The incident files and dumps are not retained in the ADR for the manually created incidents
C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month -
单项选择题
Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）
A./u01/app/oracle/product/11.1.0/db_1
B./u01/app/oracle
C.$ORACLE_HOME/bdump
D.$ORACLE_HOME/log
