單項選擇題

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.

你可能感興趣的試題

多項選擇題

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.

單項選擇題

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）

A.CLOB
B.BLOB
C.BFILE
D.LONG RAW

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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） （）

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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）（）

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）