OCP试题1

Name Null? Type

------------------ -------------- -------------

PRODUCT_ID NOT NULL NUMBER(2)

PRODUCT_NAME NOT NULL VARCHAR2(25)

PRODUCT_PRICE NUMBER(8,2)

EXPIRY_DATE DATE

Which two statements are true?

Alter database move datafile ‘/u01/sales01.dbf’ to /u02/sales02.dbf’;

Which two statements are true?

Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?

Oracle Managed Files （OMF） is not used in this database.

Examine this command:

DROP TABLESPACE tbs1;

Which two will ensure that TBS1 is dropped and its datafiles are deleted from the file system?

Select cust_id, cust_last_name “Last Name”

from customers

where country_id=10

UNION

Select cust_id CUST_NO, Cust_last_name

from customers

where country_id=30;

Identify three ORDER BY clauses, any one of which can complete the query successfully.