A FREE_SPACE indicates only the space that is currently unallocated.
B ALLOCATED_SPACE indicates only the space currently allocated and in use.
C FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D ALLOCATED_SPACE indicates both the space currently allocated and used,and the space that is available for reuse.
E FREE_SPACE indicates both the space that is currently allocated and available for reuse,and the space that is currently unallocated.
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>ALTER SYSTEM SET db_securefile = ’IGNORE’; What is the impact of this setting on the usage of SecureFiles?()
单选题查看答案
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 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?()
单选题查看答案