Examine the commands used to create DEPARTMENT_DETAILS and
COURSE_DETAILS tables:

You want to generate a list of all department IDs that do not exist in the COURSE_DETAILS table.
You execute the SQL statement:

What is the outcome?

• A.It fails because the join type used is incorrect.
• B.It executes successfully but displays an incorrect list.
• C.It executes successfully and displays the required list.
• D.It fails because the ON clause condition is not valid.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure proposed for the TRANSACTIONStable:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

• A.The CUST_CREDIT_VALUEcolumn would allow storage of positive and negative integers.
• B.The CUST_STATUScolumn would allow storage of data up to the maximum VARCHAR2size of 4,000 characters.
• C.The TRANS_VALIDITYcolumn would allow storage of a time interval in days, hours, minutes, and seconds.
• D.The TRANS_DATEcolumn would allow storage of dates only in the dd-mon-yyyy format.

Comment: *

Name: *

Email: *

Verification: *

Which three actions can you perform only with system privileges?

• A.Use the WITH GRANT OPTION clause.
• B.Execute a procedure in another schema.
• C.Log in to a database.
• D.Access flat files via a database, which are stored in an operating system directory.
• E.Truncate a table in another schema.
• F.Query any table in a database.

Comment: *

Name: *

Email: *

Verification: *

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

Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.
Customers with no credit limit should have "Not Available" displayed.
Which SQL statement would produce the required result?

• A.SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT"FROM customers;
• B.SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT"FROM customers;
• C.SELECT NVL(cust_credit_limit*.15,'Not Available') "NEW CREDIT"FROM customers;
• D.SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT"FROM customers;

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERStable has a CUST_CREDIT_LIMITcolumn of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.Available') FROM customers;
  SELECT NVL2 (cust_credit_limit * .15, 'Not Available') FROM customers;
• B.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• C.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
• D.SELECT NVL (cust_credit_limit * .15, 'Not Available') FROM customers;
• E.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not

Comment: *

Name: *

Email: *

Verification: *