Examine this statement:

UPDATE employees

SET (job id，salary) =

      (SELECT job_id, salary

       FROM employees

       WHERE employee id = 200)

WHERE employeeid=100;

Which two statements are true? (Choose two.)

Name

TRANSACTION ID

TRANSACTION DATE

AMOUNT

CUSTOMER ID

Null?

NOT NULL

Type

VARCHAR2(6)

DATE

NUMBER(10，2)

VARCHAR2(6)

Which two SQL statements execute successfully? (Choose two.)

Name                               Null?                                Type

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

CUSTOMER_ID               NOT NULL                  NUMBER(38) 

CUSTOMER_NAME        NOT NULL                  VARCHAR2 (100) 

INSERT_DATE                  NOT NULL                 DATE

Which two statements will do an implicit conversion?

Name                   Null?                     Type

EMPLOYEE_ID    NOT NULL    VARCHAR2 (15)

FIRST_NAME    NOT NULL      VARCHAR2 (15)

LAST_NAME                            NUMBER (3)

SALARY                                   NUMBER(6,2)

Which two queries will result in an error?

Examine the description of the EMPLOYEES table: 

Name                  Null?                              Type

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

EMPLOYEE_ID      NOT NULL                   NUMBER(6) 

SALARY                                                     NUMBER(8,2)

DEPARTMENT_ID                                      NUMBER (4)

Which two queries return the highest salary in the table?

Name                              Null?                              Type

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

PROD_ID                       NOT NULL                     NUMBER (2) 

PROD_NAME                 NOT NULL                   VARCHAR2 (20) 

EXPIRY_DATE                                                            DATE

Which two are true?

Which two are true?

SQL> 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 either one of which can complete the query.

Examine the description of the CUSTOMERS table: 

CUSTOMER_ID     CUSTOMER_NAME

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

10 MARK

20 Mandy

30 Mary

40 MARVIN

50 MARTIN

Which two SELECT statements will return these results: 

CUSTOMER_NAME

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

 Mandy

Mary

Examine the description of the EMPLOYEES table: Name Null? Type

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

 EMPLOYEE_NAME NOT NULL VARCHAR2 (5) HIRE_DATE DATE SALARY NUMBER(7,2)

The session time zone is the same as the database server.

Which two statements will list only the employees who have been working with the company for

more than five years?