网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Evaluatethefollowingcommand:SQL>CREATETABLEdesign_data(idNUMBER,docCLOB)LOB(doc)STOREASSECUREFILE(DEDUPLICATE);Whichstatementistrueregardingtheabovecommand?()
A.TheLOBvaluesareautomaticallycompressed.
B.TheLOBvaluesarecachedbydefaultinthebuffercache.
C.TheLOBvaluesareautomaticallystoredinencryptedmode.
D.AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks.
参考答案
更多 “ Evaluatethefollowingcommand:SQLCREATETABLEdesign_data(idNUMBER,docCLOB)LOB(doc)STOREASSECUREFILE(DEDUPLICATE);Whichstatementistrueregardingtheabovecommand?() A.TheLOBvaluesareautomaticallycompressed.B.TheLOBvaluesarecachedbydefaultinthebuffercache.C.TheLOBvaluesareautomaticallystoredinencryptedmode.D.AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks. ” 相关考题
考题
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.
考题
Evaluate the following command:SQLALTER 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
考题
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);
考题
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);
考题
Evaluatethefollowingcommand:SQLALTERSYSTEMSETdb_securefile=’IGNORE’;WhatistheimpactofthissettingontheusageofSecureFiles?()
A.ItforcesBasicFilestobecreatedeveniftheSECUREFILEoptionisspecifiedtocreatetheLOBB.ItforcesSecureFilestobecreatedeveniftheBASICFILEoptionisspecifiedtocreatetheLOBC.ItdoesnotallowthecreationofSecureFilesandgeneratesanerroriftheSECUREFILEoptionisspecifiedtocreatetheLOBD.ItignorestheSECUREFILEoptiononlyifaManualSegmentSpaceManagementtablespaceis usedandcreatesaBasicFile
考题
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.
考题
5、空白限、检出限和定量限三者在数量上的关系为A．LoB ＜ LoD ≤ LoQB．LoB ＜ LoD ＜ LoQC．LoB ＜ LoQ ≤ LoDD．LoB ＜ LoQ ＜ LoD
热门标签
最新试卷