CMS专题
单选题You issued the following command on the temporary tablespace LMTEMP in your database： SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M； Which requirement must be fulfilled for this command to succeed？（）AThe tablespace must be locally managed.BThe
题目
The tablespace must be locally managed.
The tablespace must have only one temp file.
The tablespace must be made nondefault and offline.
The tablespace can remain as the default but must have no active sort operations.
相似问题和答案
第1题：
You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？ （）
- A、The database is in NOMOUNT state.
- B、The database is in ARCHIVELOG mode and the tablespace is online.
- C、The database is in ARCHIVELOG mode and the tablespace is offline.
- D、The database is in NOARCHIVELOG mode and the tablespace is online.
- E、The database is in NOARCHIVELOG mode and the tablespace is offline.
正确答案:B,C,E
第2题：
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）
- A、 Index-organized table
- B、 Mapping Table
- C、 Clustered Table
- D、 Journal Table
正确答案:D
第3题：
A. It stores only the temporary table but not its indexes.
B. It stores both the temporary table as well as its indexes.
C. It must be a nondefault temporary tablespace for the database.
D. It can be a default or nondefault temporary tablespace for the database.
E. It must be the default temporary tablespace of the user who issues the command.
第4题：
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup， you issued the following RMAN command： RMAN> BACKUP SECTION SIZE 300M TABLESPACE users； Which two statements are true regarding the execution of the above command？（）
- A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.
- B、 The backup piece size will be limited to 300 MB.
- C、 The operation is accomplished using the default channel available.
- D、 Three channels for the tape drive must be configured by setting the parallelism to three.
正确答案:B,C
第5题：
You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）
- A、The command must be issued in MOUNT state.
- B、The command succeeds only if the data file is offline.
- C、The command must be issued when the database is in the archivelog mode.
- D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
正确答案:D
第6题：
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）
- A、flash back the database
- B、import the temporary tablespace from the last export
- C、restore all the data files and temporary files from the last full database backup and perform a recovery
- D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace
正确答案:D
第7题：
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)
- A、The backup piece size will be limited to 300 MB
- B、The RMAN uses multiplexing to perform backup
- C、The operation is accomplished using the default channel available
- D、The RMAN parallelizes the backup although the parallelism is not set for a channel
正确答案:A,C
第8题：
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.
第9题：
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
第10题：
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
正确答案:D,E,G