Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND due_amount IS NOT NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND cust_credit_limit IS NOT NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND cust_credit_level !=NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND due_amount != NULL;
• E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level <> NULL
  AND due_amount <> NULL;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A.The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C.It supports diagnostics for Automatic Storage Management (ASM)
• D.It supports diagnostics for Oracle Clusterware
• E.It is held inside an Oracle database schema

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.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 NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• D.SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
• E.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;

Comment: *

Name: *

Email: *

Verification: *

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A.TIMESTAMP WITH LOCAL TIMEZONE
• B.TIMESTAMP
• C.TIMESTAMP WITH TIMEZONE
• D.INTERVAL DAY TO SECOND
• E.INTERVAL YEAR TO MONTH

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A.Have the OS administrator add KING to the OSDBA group
• B.Grant DBA to KING
• C.Set OS_AUTHENT_PREFIX to OPS$
• D.Alter user KING to be IDENTIFIED EXTERNALLY
• E.Unset REMOTE_LOGIN_PASSWORDFILE

Comment: *

Name: *

Email: *

Verification: *