DROP TABLE
ALTER TABLE
RESIZE
COALESCE
第1题:
根据SQL标准,删除表student中对字段sno的唯一性约束,应该使用下面哪条语句? ()
A drop sno from table student
B alter table student drop sno
C alter table student drop unique(sno)
D alter table student drop sno unique
第2题:
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
第3题:
In your test database, you have created the ORDERS table as an index/x7forganized table (IOT). To facilitate faster querying, you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason, you find that the mapping table segment is fragmented, leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data?()
第4题:
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?()
第5题:
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()
第6题:
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?()
第7题:
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?()
第8题:
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? ()
第9题:
Oracle Data Pump.
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
Online Table Redefinition.
Edition-Based Table Redefinition.
第10题:
执行语句后立即删除
发出alter table drop unused columns命令之后
发出alter table set unused columns命令之后
发出alter table modify命令之后
第11题:
The tablespace, DATA1, is not read-only.
The tablespace, DATA1, is not autoextensible.
The tablespace, DATA1, is not offline.
The segment space management for the tablespace, DATA1, is manual.
第12题:
DROP TABLE
ALTER TABLE
RESIZE
COALESCE
第13题:
把表中“学历”字段的有效性规则取消,正确的SQL语句是( )。
A.ALTER TABLE学生ALTER学历DROP CHECK
B.ALTER TABLE学生DELETE学历DROP CHECK
C.ALTER TABLE学生DELETE CHECK学历
D.ALTER TABLE学生DROP CHECK学历
第14题:
删除PRIMARYKEY约束条件及其所有依赖约束条件的语法是什么()
第15题:
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()
第16题:
Which two operations can be flashed back using the Flashback technology?()
第17题:
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? ()
第18题:
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?()
第19题:
假设需要删除Customer表中的LogoutTime列,可以使用如下()方式。
第20题:
发出下列语句:alter table sales drop columm profit;何时从Oracle中实际删除列?()
第21题:
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.
第22题:
Export and import the mapping table.
Drop and re-create the mapping table.
Truncate the mapping table and reinsert the values.
Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
第23题:
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
第24题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE