多項(xiàng)選擇題

Which three descriptions are correct about the effects of the TRUNCATE command on a table（）

A.The corresponding indexes for the table are also truncated.
B.Delete triggers on the table are fired during the execution of the TRUNCATE command.
C.The child table is truncated when the TRUNCATE command is applied on the parent table.
D.The high-water mark （HWM） is set to point to the first usable data block in the table segment.
E.No undo or very little undo data is generated during the execution of the TRUNCATE command

你可能感興趣的試題

單項(xiàng)選擇題

Which statement is true about the PCTFREE setting for the table（）

A.It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
B.It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
C.It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
D.It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.

多項(xiàng)選擇題

Examine the command that is used to create a table：
SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users；
Which two statements are true about the effect of the above command）（）

A.A CHECK constraint is created on the OID column.
B.A NOT NULL constraint is created on the OID column.
C.The ORDERS table is the only object created in the USERS tablespace.
D.The ORDERS table and a unique index are created in the USERS tablespace.
E.The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Which three descriptions are correct about the effects of the TRUNCATE command on a table（）

你可能感興趣的試題

Which statement is true about the PCTFREE setting for the table（）

Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Examine the command that is used to create a table：
SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users；
Which two statements are true about the effect of the above command）（）