Evaluate the following SQL statement:
SELECT product_name || 'it's not available for order'
FROM product_information
WHERE product_status = 'obsolete';
You received the following error while executing the above query:
ERROR
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?

• A.Remove the single quotation marks enclosing the character literal string in the SELECT clause
• B.Use the escape character to negate the single quotation mark within the literal character string in the SELECT clause
• C.Enclose the character literal string in the SELECT clause within double quotation marks
• D.Use the Oracle (q) operator and delimiter to allow the use of a single quotation mark within the literal character string in the SELECT clause

Comment: *

Name: *

Email: *

Verification: *

Examine this statement which returns the name of each employee and their manager:

You want to extend the query to include employees with no manager. What must you add before JOINto do this?

• A.CROSS
• B.LEFT OUTER
• C.RIGHT OUTER
• D.FULL OUTER

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0 respectively.

Which two INSERT statements are valid? (Choose two.)

• A.INSERT INTO(SELECT order_id,order_date,customer_id FROM orders)VALUES (1,'09-mar-2007',
  101);
• B.INSERT INTO ordersVALUES (1,'09-mar-2007', 'online','', 1000);
• C.INSERT INTO ordersVALUES (1,'09-mar-2007', DEFAULT, 101, DEFAULT);
• D.INSERT INTO orders(order_id,order_date,order_mode,(customer_id,order_total)VALUES (1,TO_DATE(NULL), 'online', 101, NULL);
• E.INSERT INTO orders(order_id,order_date,order_mode,order_total)VALUES (1,'10-mar-2007','online',1000);

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

The CUSTOMERS table contains the current location of all currently active customers.
The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?

• A.INTERSECT
• B.UNION ALL
• C.UNION
• D.MINUS

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 produces an error because the subquery gives an error.
• B.It shows COST_REMARK for all the promos in the table.
• C.It produces an error because subqueries cannot be used with the CASE expression.
• D.It shows COST_REMARK for all the promos in the promo category 'TV'.

Comment: *

Name: *

Email: *

Verification: *