CMS专题
单选题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 UNU
题目
Immediately following statement execution
After the ALTER TABLE DROP UNUSED COLUMNS command is issued
After the ALTER TABLE SET UNUSED COLUMN command is issued
After the ALTER TABLE MODIFY command is issued
相似问题和答案
第1题：
You issued the following statement： SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1； Which parameter is NOT overridden by using the above statement？（）
- A、 the value of the NLS_LANGUAGE variable
- B、 the value of the NLS_TERRITORY variable
- C、 the value of the NLS_CURRENCY variable
- D、the character encoding scheme used by the client application
正确答案:C
第2题：
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
第3题：
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;What would be the outcome of this command?（）
A. It produces an error because data already exists in the table.
B. It produces an error because compression can be enabled at table creation only.
C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
第4题：
You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）
- A、DROP TABLE
- B、ALTER TABLE
- C、RESIZE
- D、COALESCE
正确答案:A
第5题：
You issued the following statement： SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）
- A、 The control file will be multiplexed.
- B、 The control file will be recreated.
- C、The script containing the CREATE CONTROLFILE statement will be created.
- D、 The binary backup of the control file will be created.
正确答案:C
第6题：
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
第7题：
You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?（）
- A、ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
- B、ALTER DISKGROUP dg1 UNDROP;
- C、ALTER DISKGROUP dg1 UNDROP DISKS;
- D、You cannot cancel the pending disk drops.
正确答案:C
第8题：
You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）
A. It retrieves the latest version of the table from the recycle bin
B. It retrieves the oldest version of the table from the recycle bin
C. It retrieves the version of the table for which undo information is available
D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
第9题：
You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15） ） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）
- A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
- B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
- C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
- D、 You cannot shrink the SCOTT.EMP table.
正确答案:D
第10题：
You created the ORDERS table in your database by using the following code： SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）； SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）； SQL> COMMIT； Next， you issued the following statement to change the time zone for the database： SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’； What will be the result of executing the above statement？（）
- A、 The statement will fail.
- B、 The statement will be executed successfully， and the new time zone will be set for the database.
- C、 The statement will be executed successfully， but the new time zone will be set for the current session.
- D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
正确答案:A