DROP USER SMITH;
DROP TABLE EMPLOYEES;
DROP TABLESPACE USERS;
ALTER TABLE SALES_REP DROP PARTITION P1;
ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;
第1题:
把表中“学历”字段的有效性规则取消,正确的SQL语句是( )。
A.ALTER TABLE学生ALTER学历DROP CHECK
B.ALTER TABLE学生DELETE学历DROP CHECK
C.ALTER TABLE学生DELETE CHECK学历
D.ALTER TABLE学生DROP CHECK学历
第2题:
若要删除职工表中的职称字段,应该使用的命令是( )。
A.ALTER TABLE 职工 DROP 职称
B.ALTER 职工 DROP 职称
C.DROP TABLE 职称
D.DROP 职称
第3题:
下列SQL的数据定义语句组中,哪一组是正确的?
A.CREATE SCHEMA...,DROP SCHEMA…,ALTER SCHEMA…
B.CREATE TABLE......,DROP TABLE....,ALTER TABLE....
C.CREATE VIEW..:,DROP VIEW...,ALTER VIEW…
D.CREATE INDEX...,DROP INDEX…,ALTER INDEX…
第4题:
A.ALTER TABLE CUSTOMER DROP column LOGOUTTIME
B.UPDATE TABLE DROP column LOGOUTTIME
C.ALTER TABLE CUSTOMER DROP LOGOUTTIME
D.UPDATE TABLE DROP LOGOUTTIME
第5题:
要逻辑删除某一列且不要因重写所有表数据块而导致性能降低,您可以执行以下命令()
第6题:
在基表S中删除电话号码(PHONE)属性使用()命令。
第7题:
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()
第8题:
Which two operations can be flashed back using the Flashback technology?()
第9题:
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? ()
第10题:
假设需要删除Customer表中的LogoutTime列,可以使用如下()方式。
第11题:
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.
第12题:
DROP USER SMITH;
DROP TABLE EMPLOYEES;
DROP TABLESPACE USERS;
ALTER TABLE SALES_REP DROP PARTITION P1;
ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;
第13题:
A. ALTER TABLE SPLIT PARTITION
B. ALTER TABLE MERGE PARTITION
C. ALTER TABLE TRUNCATE PARTITION
D. ALTER TABLE ADD PARTITION
E. ALTER TABLE DROP PARTITION
F. ALTER TABLE MOVE PARTITION
第14题:
删除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平均成绩
第15题:
删除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平均成绩
第16题:
在下列SQL语句中,( )包含了不正确的定义语句。
Ⅰ、CREATE TABLE CREATE VIEW CREATE INDEX
Ⅱ、DROP TABLE DROP VIEW DROP INDEX
Ⅲ、ALTER TABLE ALTER VIEW ALTER INDEX
A)Ⅰ和Ⅱ
B)只有Ⅱ
C)只有Ⅲ
D)Ⅱ和Ⅲ
第17题:
删除PRIMARYKEY约束条件及其所有依赖约束条件的语法是什么()
第18题:
SQL语句删除表的语句是()
第19题:
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?()
第20题:
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()
第21题:
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?()
第22题:
DROP USER SMITH;
DROP TABLE EMPLOYEES;
DROP TABLESPACE USERS;
ALTER TABLE SALES_REP DROP PARTITION P1;
ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;
第23题:
UPDATE TABLE
CREATE CLUSTER
TRUNCATE TABLE
ALTER TABLE MOVE
INSERT INTO···VALUES
ALTER TABLE···DROP COLUMN
ALTER TABLE···DROP PARTITION
第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