CMS专题
单选题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，
题目
It creates the table and encrypts the data in it.
It generates an error because the wallet is closed.
It creates the table but does not encrypt the data in it.
It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
参考答案和解析
相似问题和答案
第1题：
A.Must you leave
B.Maybe you leave
D.You might left
D.Might you have left
第2题：
A.The box is up.
B.I lost my wallet.
C.It‘s up to you.
D.It‘s all right.
第3题：
A.should like you to see
B.would have liked you to be seen
C.should like you to have seen
D.would like you to see
第4题：
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）
- A、Immediately following statement execution
- B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued
- C、After the ALTER TABLE SET UNUSED COLUMN command is issued
- D、After the ALTER TABLE MODIFY command is issued
正确答案:B
第5题：
You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES 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.
第6题：
We request you to see to it that L/C is opened by cable ()order is placed with us.
A、whatever
B、whenever
C、wherever
D、whoever
第7题：
A. Provide a password for the encryption
B. Set up an Oracle wallet for the encryption
C. No setup is required as it is a default encryption method
D. Both Oracle wallet and password must be set up for the encryption
第8题：
A.looking
B.finding
C.searching
D.searching for
第9题：
You created an encrypted tablespace:You then closed the encryption wallet because you were advised that this is secure.Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.Which is true about the result?（）
A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
B. It generates an error when creating the table because the wallet is closed.
C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
第10题：
Examine the following RMAN command： RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG； Which prerequisite must be met before accomplishing the backup？（）
- A、 Provide a password for the encryption
- B、 Set up an Oracle wallet for the encryption
- C、 No setup is required as it is a default encryption method
- D、 Both Oracle wallet and password must be set up for the encryption
正确答案:B