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 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
第2题:
删除student表中“平均成绩”字段的正确SQL命令是( )。
A. DELETE TABLE student DELETE COLUMN平均成绩
B. ALTER TABLE student DELETE COLUMN平均成绩
C. ALTER TABLE student DROP COLUMN平均成绩
D. DELETE TABLE student DROP COLUMN平均成绩
第3题:
A.ALTER TABLE CUSTOMER DROP column LOGOUTTIME
B.UPDATE TABLE DROP column LOGOUTTIME
C.ALTER TABLE CUSTOMER DROP LOGOUTTIME
D.UPDATE TABLE DROP LOGOUTTIME
第4题:
在 Visual FoxPro 中 , 如果要将学生表 S( 学号 , 姓名 , 性别 , 年龄 ) 中 “ 年龄 ” 属性删除 ,正确的 SQL 命令是
A) ALTER TABLE S DROP COLUMN 年龄
B) DELETE 年龄 FROM S
C) ALTER TABLE S DELETE COLUMN 年龄
D) ALTEER TABLE S DELETE 年龄
第5题:
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?()
第6题:
You issued the following command: SQL> DROP TABLE MYTABLE; SQL> SHOW RECYCLEBIN The following output is returned: ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ------------- ------------------------------ --------------- -------------------- MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE 2005-01-13:20:11:31 You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()
第7题:
You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?()
第8题:
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?()
第9题:
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?()
第10题:
The table is moved to the SYSAUX tablespace.
The table is moved to the SYSTEM tablespace.
The table is removed from the database permanently.
The table is renamed and remains in the TBSFD tablespace.
第11题:
DROP TABLE MYTABLE PURGE;
PURGE RECYCLEBIN;
PURGE TABLE MYTABLE;
PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;
第12题:
A syntax error will result as you cannot specify more than one partition in the same statement
All data in p1 and p3 partitions are removed and the table definition is changed
All data in p1 and p3 partitions are removed, but the table definition remains unchanged
Only the first partition (p1) will be dropped as only one can be dropped at any time
第13题:
A.A syntax error will result as you cannot specify more than one partition in the same statement
B.All data in p1 and p3 partitions are removed and the table definition is changed
C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D.Only the first partition (p1) will be dropped as only one can be dropped at any time
第14题:
删除student表的“平均成绩”字段的正确SQL命令是
A.DELETE TABLE student DELETE COLUMN平均成绩
B.ALTER TABLE student DELETE C0LUMN平均成绩
C.ALTER TABLE student DROP COLUMN平均成绩
D.DELETE TABLE student DROP COLUMN平均成绩
第15题:
利用SQL命令删除“学生”表中的“年龄”字段,正确的命令格式是( )。
A)ALTER TABLE 学生 DELETE COLUMN 年龄
B)ALTER TABLE 学生 DROP COLUMN 年龄
C)ALTER TABLE 学生 CANCEL COLUMN 年龄
D)ALTER TABLE 学生 CUT COLUMN 年龄
第16题:
设有表M,将其中的Type列的数据类型改为NCHAR(4)。下列能实现该功能的语句是()。
第17题:
Which two operations can be flashed back using the Flashback technology?()
第18题:
Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees; Table created. Further, you executed the following command to drop the table: SQL> DROP TABLE emp; Table dropped. What happens in this scenario? ()
第19题:
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()
第20题:
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?()
第21题:
假设需要删除Customer表中的LogoutTime列,可以使用如下()方式。
第22题:
The statement will be executed successfully, and a new time zone will be set for the database.
The statement will be executed successfully, but a new time zone will not be set for the database.
The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
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.
第23题:
ALTER DISKGROUP dg1 UNDROP disk2,disk3,disk5
ALTER DISKGROUP dg1 UNDROP
ALTER DISKGROUP dg1 UNDROP DISKS
You cannot cancel the pending disk drops
第24题:
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