View the Exhibit and examine the structure of the ORDERStable.

Which UPDATEstatement is valid?
UPDATE orders

• A.SET order_date = '12-mar-2007',
  AND order_total = TO_NUMBER(NULL)
  WHERE order_id = 2455;
  UPDATE orders
• B.SET order_date = TO_DATE('12-mar-2007','dd-mon-yyyy'),
  SET order_total = TO_NUMBER (NULL)
  WHERE order_id = 2455;
• C.SET order_date = '12-mar-2007',
  order_total IS NULL
  WHERE order_id = 2455;
  UPDATE orders
• D.SET order_date = '12-mar-2007',
  order_total = NULL
  WHERE order_id = 2455;
  UPDATE orders

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

• A.listing of customers who do not have a credit limit and were born before 1980
• B.finding the number of customers, in each city, whose marital status is 'married'.
• C.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
• D.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.
• E.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

Comment: *

Name: *

Email: *

Verification: *

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

Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST LAST NAME is Roberts and CREDIT LIMIT is 600?

• A.INSERT INTO orders (order_id,order_date,order_mode,
  (SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND
  credit_limit=600) .order_total)
  VALUES(1 ,'10-mar-2007', 'direct', &&customer_id, 1000);
• B.INSERT INTO orders
  VALUES (1,'10-mar-2007', 'direct',
  (SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND
  credit_limit=600), 1000);
• C.INSERT INTO orders (order_id.order_date.order_mode,
  (SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND
  credit _limit=600) .order_total)
  VALUES(1 ,'IO-mar-2007', 'direct', &customer_id, 1000);
• D.INSERT INTO(SELECT o.order_id, o.order_date.o.orde_mode.c.customer_id, o.order_total FROM orders o, customers c WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts'ANDc. Credit_limit=600) VALUES (1,'10-mar-2007', 'direct',(SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND Credit_limit=600), 1000);

Comment: *

Name: *

Email: *

Verification: *

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

• A.SELECT TO_CHAR (1890.55, '$99G999D00') FROM DUAL
• B.SELECT TO_CHAR (1890.55, '$9,999V99') FROM DUAL;
• C.SELECT TO_CHAR (1890.55, '$99,999D99') FROM DUAL;
• D.SELECT TO_CHAR (1890.55, '$99G999D99') FROM DUAL
• E.SELECT TO_CHAR (1890.55, '$0G000D00') FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SELECTstatement and view the exhibit to examine its output:
SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status,
FROM user_constraints
WHERE table_name = 'ORDERS';
CONSTRAINT_NAME CON SEARCH_CONDITI R_CONSTRAINT_NAME DELETE_RULE STATUS ON
ORDER_DATE_NN C "ORDER_DATE" IS ENABLED
NOT NULL
ORDER_CUSTOMER_ID_ C "CUSTOMER_ID" IS ENABLED
NN NOT NULL
ORDER_MODE_LOV C order _mode in ENABLED
( 'direct',
' online')
ORDER TOTAL MIN C order total >= 0 ENABLED
ORDER PK P ENABLED
ORDERS CUSTOMER ID R CUSTOMERS ID SET NULL ENABLED
ORDERS SALES REP R EMP EMP ID SET NULL ENABLED
Which two statements are true about the output? (Choose two.)

• A.The STATUScolumn indicates whether the table is currently in use.
• B.In the second column, 'c'indicates a check constraint.
• C.The column DELETE_RULEdecides the state of the related rows in the child table when the corresponding row is deleted from the parent table.
• D.The R_CONSTRAINT_NAMEcolumn gives the alternative name for the constraint.

Comment: *

Name: *

Email: *

Verification: *