网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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” 相关考题
考题 使用SQL语句将教师表中的照片字段删除,以下正确的是()。A.Alter table教师Delete照片B.Alter table教师Drop照片C.Alter table教师AND Drop照片D.Alter table教师AND Delete照片

考题 以下能够删除一列的是( )A.alter table emp remove addcolumnB.alter table emp drop column addcolumnC.alter table emp delete column addcolumnD.alter table emp delete addcolumn

考题 下列说法正确的是()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

考题 删除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

考题 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?()A、export and import the mapping tableB、drop and re­create the mapping tableC、truncate the mapping table and reinsert the valuesD、use the ALTER TABLE .. REBUILD command to defragment the mapping table

考题 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 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?()A、ALTER TABLE commercials MODIFY (description CHAR2(2000));B、ALTER TABLE commercials CHANGE (description CHAR2(2000));C、ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));D、ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));E、You cannot increase the size of a column if the table has rows.

考题 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?()A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.D、 You cannot shrink the SCOTT.EMP table.

考题 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

考题 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? ()A、ALTER DATABASE B、SET TRANSACTION C、ALTER ROLLBACK SEGMENT D、ALTER TABLE

考题 发出下列语句:alter table sales drop columm profit;何时从Oracle中实际删除列?()A、执行语句后立即删除B、发出alter table drop unused columns命令之后C、发出alter table set unused columns命令之后D、发出alter table modify命令之后

考题 单选题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.

考题 单选题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.

考题 单选题发出下列语句:alter table sales drop columm profit;何时从Oracle中实际删除列?()A 执行语句后立即删除B 发出alter table drop unused columns命令之后C 发出alter table set unused columns命令之后D 发出alter table modify命令之后

考题 单选题In your test database, you have created the ORDERS table as an index-organized 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 degrees 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?()A  Export and import the mapping table.B  Drop and re-create the mapping table.C  Truncate the mapping table and reinsert the values.D  Use the ALTER TABLE .. REBUILD command to defragment the mapping table.

考题 单选题You issued the following command:   ALTER TABLE SCOTT.EMP SHRINK SPACE;   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties:   DATA1 is a read/write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE; command that generates the following error:   ORA-10635: Invalid segment or tablespace type    What could be the reason for the failure of the command?()A  The tablespace, DATA1, is not read-only.B  The tablespace, DATA1, is not autoextensible.C  The tablespace, DATA1, is not offline.D  The segment space management for the tablespace, DATA1, is manual.

考题 单选题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

考题 单选题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

考题 单选题In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective?()A REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE