Examine the structure of the invoice table.

Which two SQL statements would execute successfully? A)

B)

C)

D)

Examine the data in the CUST_NAME column of the CUSTOMERS table:

You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?

You executed the following CREATE TABLE statement that resulted in an error:
SQL> CREATE TABLE employees(emp_id NUMBER(10) PRIMARY KEY, ename VARCHAR2(20), email NUMBER(3) UNIQUE, address VARCHAR2(500), phone VARCHAR2(20), resume LONG, hire_date DATE, remarks LONG, dept_id NUMBER(3) CONSTRAINT emp_dept_id_fk REFERENCES departments (dept_id), CONSTRAINT ename_nn NOY NULL (ename)); Identify two reasons for the error.

Which two statements are true about the DUAL table?

Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable:

You want to display the CUST_NAMEvalues where the last name starts with Mcor MC.
Which two WHERE clauses give the required result? (Choose two.)