A It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
B It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
C It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
D It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
Evaluate the following statement: Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?()
单选题查看答案
Evaluate the following statement: Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?()
单选题查看答案
Evaluate the following SQL statements that are issued in the given order: What would be the status of the foreign key EMP_MGR_FK?()
单选题查看答案
Evaluate the following SQL statements that are issued in the given order: What would be the status of the foreign key EMP_MGR_FK?()
单选题查看答案
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?()
单选题查看答案
Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output?()
多选题查看答案
Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output?()
多选题查看答案
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?()
单选题查看答案
Evaluate the SQL statement: What is the result of the statement?()
单选题查看答案