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

题目
Evaluatethefollowingcommand:SQL>CREATETABLEdesign_data(idNUMBER,docCLOB)LOB(doc)STOREASSECUREFILE(DEDUPLICATE);Whichstatementistrueregardingtheabovecommand?()

A.TheLOBvaluesareautomaticallycompressed.

B.TheLOBvaluesarecachedbydefaultinthebuffercache.

C.TheLOBvaluesareautomaticallystoredinencryptedmode.

D.AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks.

相似考题

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.Which statement accomplish this? ()A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

3.You need to create a table named ORDERS that contain four columns:1. an ORDER_ID column of number data type2. aCUSTOMER_ID column of number data type3. an ORDER_STATUS column that contains a character data type4. aDATE_ORDERED column to contain the date the order was placed.When a row is inserted into the table, if no value is provided when the order was placed, today‘s date should be used instead.Which statement accomplishes this? （）A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

4.Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE‘;What is the impact of this setting on the usage of SecureFiles?()A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBB. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOBC. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOBD. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

更多“Evaluatethefollowingcommand:SQL>CREATETABLEdesign_data(idNUMBER,docCLOB)LOB(doc)STOREASSECUREFILE(DEDUPLICATE);Whichstatementistrueregardingtheabovecommand?() ”相关问题

  • 第1题：

    Evaluatethefollowingcommand:SQL>ALTERSYSTEMSETdb_securefile=’IGNORE’;WhatistheimpactofthissettingontheusageofSecureFiles?()

    A.ItforcesBasicFilestobecreatedeveniftheSECUREFILEoptionisspecifiedtocreatetheLOB

    B.ItforcesSecureFilestobecreatedeveniftheBASICFILEoptionisspecifiedtocreatetheLOB

    C.ItdoesnotallowthecreationofSecureFilesandgeneratesanerroriftheSECUREFILEoptionisspecifiedtocreatetheLOB

    D.ItignorestheSECUREFILEoptiononlyifaManualSegmentSpaceManagementtablespaceis usedandcreatesaBasicFile


    参考答案：A

  • 第2题：

    在Oracle中,DBMS_LOB程序包的()过程用于删除指定的BLOB或CLOB。

    A.delete

    B.erase

    C.remove

    D.empty_lob


    参考答案：B

  • 第3题：

    5、空白限、检出限和定量限三者在数量上的关系为

    A．LoB ＜ LoD ≤ LoQ

    B．LoB ＜ LoD ＜ LoQ

    C．LoB ＜ LoQ ≤ LoD

    D．LoB ＜ LoQ ＜ LoD


    LoB ＜ LoD ≤ LoQ

  • 第4题：

    Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20),Category_id number(30),Quantity_on_hand number (3) INVISIBLE);Which three statements are true about using an invisible column in the PRODUCTS table?（）

    A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

    B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

    C. Referential integrity constraint cannot be set on the invisible column.

    D. The invisible column cannot be made visible and can only be marked as unused.

    E. A primary key constraint can be added on the invisible column.


    参考答案：A, B, C

  • 第5题：

    空白限、检出限和定量限三者在数量上的关系为

    A．LoB ＜ LoD ≤ LoQ

    B．LoB ＜ LoD ＜ LoQ

    C．LoB ＜ LoQ ≤ LoD

    D．LoB ＜ LoQ ＜ LoD


    A

相关内容