The user SCOTTwho is the owner of ORDERSand ORDER_ITEMStables issues this GRANTcommand:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?

• A.PUBLICshould be replaced with specific usernames.
• B.ALLshould be replaced with a list of specific privileges.
• C.WITH GRANT OPTIONshould be added to the statement.
• D.Separate GRANTstatements are required for ORDERSand ORDER_ITEMS tables.

Comment: *

Name: *

Email: *

Verification: *

Examine these SQL statements that are executed in the given order:

What will be the status of the foreign key EMP_MGR_FK?

• A.It will remain disabled and can be re-enabled manually.
• B.It will be enabled and deferred.
• C.It will remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
• D.It will be enabled and immediate.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

Which two statements will do an implicit conversion?

• A.SELECT FROM + customers WHERE (customer_id) = '0001';
• B.SELECT FROM + customers WHERE (customer_id) = 0001;
• C.SELECT FROM + customers WHERE insert_date = '01-JAN-19';
• D.SELECT FROM + customers WHERE TO-CHAR (customer_id) = '0001';
• E.SELECT FROM + customers WHERE insert_date = DATE '2019-01-01';

Comment: *

Name: *

Email: *

Verification: *

Which two statements execute successfully?

• A.SELECT TO_ DATE('2019-DEC-25 15:30', 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE
  =AMERICAN' ) FROM DUAL;
• B.SELECT TO _DATE (TO_ CHAR ('2019-DEC-25 03:30', 'YYYY-MON-DD HH12:MI')) FROM DUAL;
• C.SELECT TO _ CHAR (TO_ DATE ('2019-DEC-25 03:30','YYYY-MON-DD HH12:MI')) FROM DUAL
• D.SELECT TO _ CHAR ('2019-DEC-25 15:30'.'YYYY-MON-DD HH24:MI') FROM DUAL
• E.SELECT TO_CHAR('2019-DEC-25 15:30", YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE = AMERICAN') FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)

Evaluate this SQL statement:
SELECT TO_CHAR (list_price, '$9,999')
From product_information;
Which two statements are true regarding the output?

• A.A row whose LIST_PRICE column contains value 1123.90 would be displayed as
  $ 1,124.
• B.A row whose LIST_PRICE column contains value 11235.90 would be displayed as
  $ 1,123.
• C.A row whose LIST_PRICE column contains value 1123.90 would be displayed as
  $ 1,123.
• D.A row whose LIST_PRICE column contains value 11235.90 would be displayed as
  # ######.

Comment: *

Name: *

Email: *

Verification: *