网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which two operations can be flashed back using the Flashback technology？ （）
A
DROP USER SMITH；
B
DROP TABLE EMPLOYEES；
C
DROP TABLESPACE USERS；
D
ALTER TABLE SALES_REP DROP PARTITION P1；
E
ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which two operations can be flashed back using the Flashback technology？ （）A DROP USER SMITH；B DROP TABLE EMPLOYEES；C DROP TABLESPACE USERS；D ALTER TABLE SALES_REP DROP PARTITION P1；E ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；” 相关考题
考题
下列SQL语句中，包含了不正确定义语句的组是（ ）。Ⅰ. CREATE TABLE CREATE VIEW CREATE INDEXⅡ. DROP TABLE DROP VIEW DROP INDEXⅢ. ALTER TABLE ALTER VIEW ALTER INDEXA)只有IB)只有ⅡC)只有ⅢD)Ⅰ和Ⅱ
考题
下列说法正确的是()A.alter table user drop column sex;B.alter table user add sex varchar(20);C.alter table user drop sex;D.alter table user modify id int primary key;
考题
把表中"单价"字段的有效性规则取消,使用SQL语句A．ALTER TABLE ORDER ALTER 单价 DROP CHECKB．ALTER TABLE ORDER DELETE 单价 DROP CHECKC．ALTER TABLE ORDER DELETE CHECK 单价D．ALTER TABLE ORDER DROP CHECK 单价
考题
根据SQL标准，删除表student中对字段sno的唯一性约束，应该使用下面哪条语句? ()A drop sno from table studentB alter table student drop snoC alter table student drop unique(sno)D alter table student drop sno unique
考题
把表中“学历”字段的有效性规则取消，正确的SQL语句是（ ）。A.ALTER TABLE学生ALTER学历DROP CHECKB.ALTER TABLE学生DELETE学历DROP CHECKC.ALTER TABLE学生DELETE CHECK学历D.ALTER TABLE学生DROP CHECK学历
考题
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()
A. ALTER TABLE SPLIT PARTITIONB. ALTER TABLE MERGE PARTITIONC. ALTER TABLE TRUNCATE PARTITIOND. ALTER TABLE ADD PARTITIONE. ALTER TABLE DROP PARTITIONF. ALTER TABLE MOVE PARTITION
考题
若要删除职工表中的职称字段，应该使用的命令是( )。A．ALTER TABLE 职工 DROP 职称B．ALTER 职工 DROP 职称C．DROP TABLE 职称D．DROP 职称
考题
删除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平均成绩
考题
下列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…
考题
删除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平均成绩
考题
假设需要删除Customer表中的LogoutTime列,可以使用如下()方式。
A.ALTER TABLE CUSTOMER DROP column LOGOUTTIMEB.UPDATE TABLE DROP column LOGOUTTIMEC.ALTER TABLE CUSTOMER DROP LOGOUTTIMED.UPDATE TABLE DROP LOGOUTTIME
考题
在下列SQL语句中，（ ）包含了不正确的定义语句。Ⅰ、CREATE TABLE CREATE VIEW CREATE INDEXⅡ、DROP TABLE DROP VIEW DROP INDEXⅢ、ALTER TABLE ALTER VIEW ALTER INDEXA）Ⅰ和ⅡB）只有ⅡC）只有ⅢD）Ⅱ和Ⅲ
考题
要逻辑删除某一列且不要因重写所有表数据块而导致性能降低，您可以执行以下命令（）A、Alter table modify columnB、Alter table drop columnC、Alter table set unusedD、Drop column "columname"
考题
删除PRIMARYKEY约束条件及其所有依赖约束条件的语法是什么（）A、ALTER TABLE table_name DROP CONSTRAINT constraint_name CASCADEB、ALTER TABLE table_name DROP CONSTRAINT FOREIGN KEY CASCADEC、DROP CONSTRAINT table_name（constraint_name）D、ALTER TABLE table_name DROP CONSTRAINT constraint_name
考题
在基表S中删除电话号码（PHONE）属性使用（）命令。A、ALTER S DROP PHONEB、ALTER TABLE S DROP PHONEC、UPDATE TABLE S PHONED、DROP TABLE S PHONE
考题
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）A、ALTER TABLE SPLIT PARTITIONB、ALTER TABLE MERGE PARTITIONC、ALTER TABLE TRUNCATE PARTITIOND、ALTER TABLE ADD PARTITIONE、ALTER TABLE DROP PARTITIONF、ALTER TABLE MOVE PARTITION
考题
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
考题
Which two operations can be flashed back using the Flashback technology？（）A、DROP USER SMITH；B、DROP TABLE EMPLOYEES；C、DROP TABLESPACE USERS；D、ALTER TABLE SALES_REP DROP PARTITION P1；E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
考题
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）A、UPDATE TABLEB、CREATE CLUSTERC、TRUNCATE TABLED、ALTER TABLE MOVEE、INSERT INTO···VALUESF、ALTER TABLE···DROP COLUMNG、ALTER TABLE···DROP PARTITION
考题
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？ （）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
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
考题
假设需要删除Customer表中的LogoutTime列，可以使用如下（）方式。A、ALTER TABLE CUSTOMER DROP column LOGOUTTIMEB、UPDATE TABLE DROP column LOGOUTTIMEC、ALTER TABLE CUSTOMER DROP LOGOUTTIMED、UPDATE TABLE DROP LOGOUTTIME
考题
多选题Which two operations can be flashed back using the Flashback technology？（）ADROP USER SMITH；BDROP TABLE EMPLOYEES；CDROP TABLESPACE USERS；DALTER TABLE SALES_REP DROP PARTITION P1；EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
考题
单选题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？（）A
The table is moved to the SYSAUX tablespace.B
The table is moved to the SYSTEM tablespace.C
The table is removed from the database permanently.D
The table is renamed and remains in the TBSFD tablespace.
考题
多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION
考题
单选题Which two operations can be flashed back using the Flashback technology？ （）A
DROP USER SMITH；B
DROP TABLE EMPLOYEES；C
DROP TABLESPACE USERS；D
ALTER TABLE SALES_REP DROP PARTITION P1；E
ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
考题
单选题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
热门标签
最新试卷
