（含图）

Sufficient storage is available in filesystem /u01.

 Which two statements are true about the BIG_TBS tablespace? (Choose two.)

 An UPDATE is executed on a temporary table. 

Where is the UNDO stored?

One of the columns must meet three requirements: Be stored in a format supporting date arithmetic算法 without using conversion functions 

Store a loan period of  up to 10 years 

Be used for calculating interest计算贷款 for the number of days the loan借款  remains unpaid未付款 

Which data type should you use?

（含图）

Which statement is true?

dispatchers in a shared server configuration? (Choose three.)

The variables used in your query are never undefined in your session. Which query can be used?

（含图）

You want to display details of all customers who reside in cities starting with the letter字母 D followed by at least two characters. 

Which query can be used?

（含图）

Which two statements are true? (Choose two.)

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 t he PRODUCTS table?

ALTER TABLE orders SET UNUSED (order_date); 

Which statement is true?

ALTER TABLE hr.emp 

SET UNUSED (mgr_id);

Which statement is true regarding关于  the effect of the above SQL statement?

Examine the structure of the DEPARTMENTS table 

（含图）

You execute the following command: 

SQL> ALTER TABLE departments 

SET UNUSED (country);

 Which two statements are true?