网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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.
考题
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 binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
考题
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 variableB、 the value of the NLS_TERRITORY variableC、 the value of the NLS_CURRENCY variableD、the character encoding scheme used by the client application
考题
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.
考题
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
考题
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.
考题
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.
考题
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.
考题
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
考题
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.
考题
You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
考题
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.
考题
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL *Loader.D、New data conforms to the constraint， but existing data is not checked.E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the Services schema， There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs. In the options below， which Transact-SQL statement should you execute？（）A、ALTER TABLE Service.Table SWITCH TO Costs.Table1; B、ALTER SCHEMA CostsTRANSFER Service.Table; C、ALTER USER Service WITH DEFAULT_SCHEMA = Costs; D、ALTER AUTHORIZATION ON Service.Table1 TO Costs;
考题
你要关闭SALES表中UNIT_PRICE列的非NULL约束。下列哪个语句能完成这个操作？（）A、alter table sales modify（unit_prices null）B、alter table sales modify（unit_prices not null）C、alter table sales add（unit_prices null）D、alter table sales add（unit_prices not null）
考题
单选题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
考题
单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the result of issuing the above statement？（）A
The statement will be executed successfully， and a new time zone will be set for the database.B
The statement will be executed successfully， but a new time zone will not be set for the database.C
The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D
The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
考题
多选题Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL *Loader.DNew data conforms to the constraint， but existing data is not checked.EIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题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.
考题
单选题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.
考题
多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题You issued the following command： ALTER TABLE SCOTT.EMP SHRINK SPACE； The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties： DATA1 is a read/write tablespace. DATA1 is not autoextensible to an unlimited size. DATA1 is online. Segment space management for the DATA1 tablespace is manual. You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error： ORA-10635： Invalid segment or tablespace type What could be the reason for the failure of the command？（）A
The tablespace， DATA1， is not read-only.B
The tablespace， DATA1， is not autoextensible.C
The tablespace， DATA1， is not offline.D
The segment space management for the tablespace， DATA1， is manual.
考题
单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）A
You must enable the row movement on the SCOTT.EMP table.B
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
考题
单选题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.
考题
单选题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.
考题
单选题You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）A
INDEX_STATSB
DBA_INDEXESC
DBA_IND_COLUMNSD
V$OBJECT_USAGE
热门标签
最新试卷
