网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
- 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
参考答案
更多 “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 emp delete column addcolumn;B. alter table emp modify column addcolumn char(10);C.alter table emp change addcolumn addcolumn int;D. alter table emp add column addcolumn int;
考题
下列说法正确的是()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;
考题
为“部门”表增加一个“人数”字段，类型为整型，正确的语句是( )。A．ALTER TABLE部门ALTER人数IB．ALTER TABLE部门ALTER FIELDS人数IC．ALTER TABLE部门ADD人数ID．ALTER TABLE部门ADD FIELDS人数I
考题
为“选课”表增加一个“等级”字段，其类型为C、宽度为2，正确的SQL命令是（ ）。A.ALTER TABLE选课ADD nELD等级C(2)B.ALTER TABLE选课ALTER FIELD等级C(2)C.ALTER TABLE选课ADD等级C(2)D.ALTER TABLE选课ALTER等级C(2)
考题
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()
A. ALTER TABLE students ADD PRIMARY KEY _ id;B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
考题
Which syntax turns an existing constraint on? ()
A. ALTER TABLE table_name ENABLE constraint_name;B. ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;C. ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;D. ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
考题
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部门ALTER人数1SX
为“部门”表增加一个“人数”字段，类型为整型，正确的语句是（ ）。A.ALTER TABLE部门ALTER人数1B.ALTER TABLE部门ALTER FIELDS人数lC.ALTER TABLE部门ADD人数lD.ALTER TABLE部门ADDFIELDS人数l
考题
将“学生”表中班级字段的宽度由原来的8改为12，正确的命令是A．ALTER TABLE 学生 ALTER 班级 C(12)B．ALTER TABLE 学生 ALTER FIELDS 班级 C(12)C．ALTER TABLE 学生 ADD 班级 C(12)D．ALTER TABLE 学生 ADD FIELDS 班级C(12)
考题
将Student.dbf表中jg字段的名称改为籍贯，如下选项中正确的SQL语句是A）ALTER TABLE student ALTER COLUMN jg TO籍贯B）ALTER TABLE student ADD籍贯C（10）C）ALTER TABLE student RENAME jg TO籍贯D）ALTER TABLE student RENAME jg籍贯
考题
只修改列的数据类型指令是A.ALTER TABLE … … ALTER COLUMNB.ALTER TABLE … MODIFY COLUMN…C.ALTER TABLE … UPDATE …D.ALTER TABLE … UPDATE COLUMN…
考题
为“部门”表增加一个“人数”字段，类型为整型，正确的命令是( )。A．AITER TABLE 部门 ALTER 人数 IB．AITER TABLE 部门 ALTER FIELDS 人数 IC．ALTER TABLE 部门 ADD 人数 ID．ALTER TABLE 部门 ADD FIELDS 人数 I
考题
如果希望更新表authors中的first_name列为非空，那么可以使用哪个语句？（）A、alter table authors add first_name not nullB、alter table authors modify first_name not nullC、alter table authors alter first_name not nullD、alter table authors drop first_name not null
考题
为表TEST中ID列添加主键约束的语法是（）A、ALTER TABLE TEST CHANGE（ ID INT PRIMARY KEY）B、ALTER TABLE TEST ADD（ ID INT PRIMARY KEY）C、ALTER TABLE TEST MODIFY（ ID INT PRIMARY KEY）D、ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY （ID）
考题
SQL server中（）语句能将temp表中的hostname字段扩充为varchar（100）。A、alter table temp alter column hostname varchar（1100）B、alter table temp column hostname varchar（100）C、alter table temp alter column of hostname varchar（100）D、alter table temp add column hostname varchar（100）
考题
在SQL Server中，修改表中列定义的正确的SQL语句是（）。A、ALTER TABLE 表名 ALTER COLUMN 列名 数据类型B、ALTER TABLE 表名 ALTER 列名 数据类型C、ALTER TABLE MODIFY COLUMN 列名 数据类型D、ALTER TABLE 表名 ADD 列名 数据类型
考题
Which syntax turns an existing constraint on?（）A、ALTER TABLE table_name ENABLE constraint_name;B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;C、ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;D、ALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;E、ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;
考题
设有表M，将其中的Type列的数据类型改为NCHAR（4）。下列能实现该功能的语句是（）。A、ALTER TABLE M ADD COLUMN Type NCHAR（4）B、ALTER TABLE M ALTER COLUMN Type NCHAR（4）C、ALTER TABLE M DROP COLUMN Type NCHAR（4）D、ALTER TABLE M ALTER Type NCHAR（4）
考题
修改表结构，下面哪一语句是正确的（）A、ALTER TABLE cw km ADD istagB、ALTER TABLE cw km （ADD istag char（1））C、ALTER TABLE cw km ADD istag char（1）D、ALTER cw km ADD istag char（1）
考题
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）A、Oracle Data Pump.B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D、Online Table Redefinition.E、Edition-Based Table Redefinition.
考题
Which syntax turns an existing constraint on?（）A、ALTER TABLE table_name ENABLE constraint_name;B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;C、ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;D、ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
考题
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
考题
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）A、ALTER TABLE students ADD PRIMARY KEY student_id;B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);C、ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);D、ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
考题
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）A、ALTER TABLE students ADD PRIMARY KEY _ id;B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
考题
The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）A、ALTER TABLE employees monitor index employee_idx_fk; B、ALTER INDEX employee_idx_fk monitoring on; C、ALTER TABLE employees monitor all indexes; D、ALTER INDEX employee_idx_fk monitoring usage;
考题
CREATE TABLE test（t_idINT，t_nmae CHAR（10））后，增加t_sex字段，以下语句正确的是（）。A、ALTER TABLE test ADD t_sex CHAR（2）B、ALTER TABLE test ADD t_sexC、ALTER TABLE test ALTER t_sex CHAR（2）D、ALTER TABLE test DROP（t_sex CHAR（2））
考题
多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP PARTITIONFALTER TABLE MOVE PARTITION
热门标签
最新试卷
