Evaluate the following SQL statement:
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. (Choose three.)

• A.ORDER BY 2, cust_id
• B.ORDER BY 2,1
• C.ORDER BY "CUST_NO"
  Using the ORDER BY Clause in Set Operations
  -The ORDER BY clause can appear only once at the end of the compound query.
  -Component queries cannot have individual ORDER BY clauses.
  -The ORDER BY clause recognizes only the columns of the first SELECT query.
  -By default, the first column of the first SELECT query is used to sort the output in an ascending order.
• D.ORDER BY "Last name"
• E.ORDER BY CUST_NO

Comment: *

Name: *

Email: *

Verification: *

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 NVL function cannot be used with UPDATE.
• B.It gives an error because multiple NVL functions are used in an expression.
• C.It executes successfully but no rows updated.
• 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 structure of the PROMOTIONS table.
Evaluate the following SQL statement:
Which statement is true regarding the outcome of the above query?

• A.It shows COST_REMARK for all the promos in the promo category 'TV'.
• B.It produces an error because subqueries cannot be used with the CASE expression.
• C.It shows COST_REMARK for all the promos in the table.
• D.It produces an error because the subquery gives an error.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are correct regarding indexes? (Choose three.)

• A.A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically attempts to create a unique index.
• B.Indexes should be created on columns that are frequently referenced as part of any expression.
• C.When a table is dropped, corresponding indexes are automatically dropped.
• D.For each DML operation performed on a table, the corresponding indexes are automatically updated if required.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

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?

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

Comment: *

Name: *

Email: *

Verification: *