单选题Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）AThe LOB values are automatically compressed.BThe LOB values are c

题目
单选题
Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）
A

 The LOB values are automatically compressed.

B

 The LOB values are cached by default in the buffer cache.

C

 The LOB values are automatically stored in encrypted mode.

D

 All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

相似考题

1.Evaluate the following command:Which statement is true regarding the above command?()A. The LOB matically compressed.B. The LOB values are cached bvalues are autoy default in the buffer cache.C. The LOB values are automatically stored in encrypted mode.D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

2.View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）A. The second user‘s session immediately produces the resource busy error.B. The second user‘s command executes successfully.C. The second user‘s session waits for a time period before producing the resource busy error.D. A deadlock is created.

3.Evaluatethefollowingcommand:SQL>CREATETABLEdesign_data(idNUMBER,docCLOB)LOB(doc)STOREASSECUREFILE(DEDUPLICATE);Whichstatementistrueregardingtheabovecommand?()A.TheLOBvaluesareautomaticallycompressed.B.TheLOBvaluesarecachedbydefaultinthebuffercache.C.TheLOBvaluesareautomaticallystoredinencryptedmode.D.AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks.

4.Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

更多“单选题Evaluate the following command：   SQL CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）A  The LOB values are automatically compressed.B  The LOB values ar”相关问题

  • 第1题：

    tony would like to make it easier for users of the video application to enter new doc using the “video form”, he’d like users to be able to create new “video” doc form within the view. Which one of the following should tony so to build this interface?（）

    • A、create a view action that has the following formula：@command（[create]；”video”）
    • B、create a form action that has the following formula：@command（[compose]；”video”）
    • C、create a view action that has the following formula：@command（[compose]；”video”）
    • D、create a database action that has the following formula：@command（[compose]；”video”）

    正确答案:C

  • 第2题：

    Which statements are true regarding SecureFile LOBs？（） 

    • A、 The amount of undo retained is user controlled.
    • B、 SecureFile LOBs can be used only for nonpartitioned tables.
    • C、 Fragmentation is minimized by using variable-sized chunks dynamically.
    • D、 SecureFile encryption allows for random reads and writes of the encrypted data.
    • E、 It automatically detects duplicate LOB data and conserves space by storing only one copy.

    正确答案:C,D

  • 第3题：

    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）  

    • A、 The LOB values are automatically compressed.
    • B、 The LOB values are cached by default in the buffer cache.
    • C、 The LOB values are automatically stored in encrypted mode.
    • D、 All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

    正确答案:D

  • 第4题：

    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

    • A、It fails to delete the records because the records are locked in SHARE mode.
    • B、It deletes the rows successfully because the table is locked in SHARE mode
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第5题：

    Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）  

    • A、 It executes successfully but partition pruning cannot happen for this partition key.
    • B、 It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
    • C、 It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 
    • D、 It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

    正确答案:D

  • 第6题：

    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）

    • A、SER_NO
    • B、ORDER_ID
    • C、STATUS
    • D、PROD_ID
    • E、ORD_TOTAL
    • F、composite index on ORDER_ID and ORDER_DATE

    正确答案:A,F

  • 第7题：

    单选题
    Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）
    A

    It returns space usage of only BasicFile LOB chunks.

    B

    It returns space usage of only SecureFile LOB chunks.

    C

    It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

    D

    It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）
    A

     It would be created only if a unique index is manually created first.

    B

     It would be created and would use an automatically created unique index.

    C

     It would be created and would use an automatically created nonunique index.

    D

     It would be created and remains in a disabled state because no index is specified in the command.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）
    A

     It executes successfully but partition pruning cannot happen for this partition key.

    B

     It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

    C

     It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 

    D

     It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    Which statements are true regarding SecureFile LOBs?（）
    A

    The amount of undo retained is user controlled.

    B

    SecureFile LOBs can be used only for nonpartitioned tables.

    C

    Fragmentation is minimized by using variable-sized chunks dynamically.

    D

    SecureFile encryption allows for random reads and writes of the encrypted data.

    E

    It automatically detects duplicate LOB data and conserves space by storing only one copy.


    正确答案： C,A
    解析： 暂无解析

  • 第11题：

    单选题
    Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）
    A

     It returns space usage of only BasicFile LOB chunks.

    B

     It returns space usage of only SecureFile LOB chunks.

    C

     It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

    D

     It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


    正确答案： F,C
    解析： 暂无解析

  • 第13题：

    Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）

    • A、 It would be created only if a unique index is manually created first.
    • B、 It would be created and would use an automatically created unique index.
    • C、 It would be created and would use an automatically created nonunique index.
    • D、 It would be created and remains in a disabled state because no index is specified in the command.

    正确答案:B

  • 第14题：

    Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）

    • A、 It returns space usage of only BasicFile LOB chunks.
    • B、 It returns space usage of only SecureFile LOB chunks.
    • C、 It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
    • D、 It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

    正确答案:B

  • 第15题：

    Examine the commands executed in the following sequence：  1：SQL> CREATE ROLE mgrrole；  2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；  3：SQL> GRANT select，update ON sh.sales TO mgrrole；  4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；  5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；  6：SQL> GRANT ceo TO mgrrole；  Which statement is true about the above commands（）

    • A、The commands execute successfully.
    • B、Command 6 produces an error because of circular role grant.
    • C、Command 5 produces an error because a role cannot be granted to another role.
    • D、Command 3 produces an error because the MGRROLE role already contains system privileges.
    • E、The table created by HR remains and HR still has the CREATE TABLE system privilege.
    • F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

    正确答案:B

  • 第16题：

    在Oracle中，DBMS_LOB程序包的（）过程用于删除指定的BLOB或CLOB。

    • A、delete
    • B、erase
    • C、remove
    • D、empty_lob

    正确答案:B

  • 第17题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第18题：

    单选题
    在Oracle中，DBMS_LOB程序包的（）过程用于删除指定的BLOB或CLOB。
    A

    delete

    B

    erase

    C

    remove

    D

    empty_lob


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）
    A

     The LOB values are automatically compressed.

    B

     The LOB values are cached by default in the buffer cache.

    C

     The LOB values are automatically stored in encrypted mode.

    D

     All LOB data that is identical in two or more rows in a LOB column share the same data blocks.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（）
    A

     The PRIMARY KEY is created along with a new index.

    B

     The PRIMARY KEY is created and it would use an existing unique index.

    C

     The PRIMARY KEY would be created in a disabled state because it is using an existing index.

    D

     The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    多选题
    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


    正确答案： A,F
    解析： 暂无解析

  • 第22题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


    正确答案： C,A
    解析： 暂无解析

  • 第23题：

    单选题
    User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（）
    A

    It fails with a Resource Busy error.

    B

    It deletes the rows successfully because the table is locked in SHARE mode.

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    Evaluate the following command: Which statement is true regarding the above command?（）
    A

    The LOB matically compressed.

    B

    The LOB values are cached bvalues are autoy default in the buffer cache.

    C

    The LOB values are automatically stored in encrypted mode.

    D

    All LOB data that is identical in two or more rows in a LOB column share the same data blocks.


    正确答案： C
    解析： 暂无解析

相关内容