Which two will execute successfully?

Which two are true?

Which two WHERE conditions give the same result?

Which two statements are true?

Which three statements are true?

Which two clauses must you add to the query?

SELECT cust last_name,cust_credit limit FROM customers 

Which two WHERE conditions give the required result?

Examine the description of the PRODUCTS table:

Name Null? Type

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

PRODUCT_ID NOT NULL NUMBER (2)

PRODUCT_NAME VARCHAR2 (10)

UNIT_PRICE NUMBER(3)

SURCHARGE VARCHAR2 (2)

EXPIRY_DATE DATE

DELIVERY_DATE DATE

Which three queries use valid expressions?

Examine the description of the EMPLOYEES table:

Name Null? Type

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

EMP_ID NOT NULL NUMBER

EMP_NAME VARCHAR2 (40)

DEPT_ID NUMBER (2)

SALARY NUMBER(8,2)

HIRE_DATE DATE

NLS_DATE_FORMAT is DD-MON-RR.

Which two queries will execute successfully?

Which two WHERE conditions demonstrate the correct usage of conversion functions?

（含图）

The STATUS column contains the values 'IN STOCK' or 'OUT OF STOCK' for each row.

Which two queries will execute successfully?

（含图）

You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

Examine this statement:

（含图）

Which two statements are true? (Choose two.)