In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than
10 years.
Evaluate the following SQL statement:

What would be the result?

• A.It gives an error because multiple NVL functions are used in an expression.
• B.It executes successfully but no rows updated.
• C.It gives an error because NVL function cannot be used with UPDATE.
• D.It executes successfully and updates the records of those employees who have been working in the company for more than 600 days.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the ORDERStable.

The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?

• A.ALTER TABLE orders
  MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• B.ALTER TABLE orders
  ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• C.ALTER TABLE orders
  ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;
• D.ALTER TABLE orders
  MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERStable:

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?
SELECT * FROM customers WHERE city = 'D_%';

• A.SELECT * FROM customers WHERE city = '%D_';
• B.SELECT * FROM customers WHERE city LIKE 'D_%';
• C.SELECT * FROM customers WHERE city LIKE 'D_';
• D.

Comment: *

Name: *

Email: *

Verification: *

Examine this statement,which executes successfully:
In which order are the rows displayed?

• A.sorted by DEPARTMENT_NAME and MAXSAL
• B.sorted by DEPARTMENT_NAME
• C.sorted by DEPARTMENT_NAME and AVGSAL
• D.Sorted by MAXSAL
• E.sorted by AVGSAL

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure and data in the INVOICE table.

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

• A.SELECT AVG(inv_date)
  FROM invoice
• B.SELECT AVG( inv_date -SYSDATE), AVG(inv_amt)
  FROM invoice
• C.SELECT MAX(AVG(SYSDATE -inv_date))
  FROM invoice
• D.SELECT MAX(inv_date), MIN(cust_id)
  FROM invoice

Comment: *

Name: *

Email: *

Verification: *