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.Set OS_AUTHENT_PREFIX to OPS$
• B.Have the OS administrator add KING to the OSDBA group
• C.Grant DBA to KING
• D.Unset REMOTE_LOGIN_PASSWORDFILE
• E.Alter user KING to be IDENTIFIED EXTERNALLY

Comment: *

Name: *

Email: *

Verification: *

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 != NULL
  AND cust_credit_level !=NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level <> NULL
  AND due_amount <> NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND due_amount != NULL;
• D.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;
• E.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;

Comment: *

Name: *

Email: *

Verification: *

Which three failures do not require intervention for recovery? (Choose three.)

• A.statement failure
• B.media failure
• C.transaction failure
• D.user process failure
• E.network interface card (NIC) failure

Comment: *

Name: *

Email: *

Verification: *

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

• A.the maximum amount of CPU time allowed for a user's sessions before their account is locked
• B.the maximum number of sessions permitted for a user before the account is locked
• C.the number of password changes required within a period of time before a password can be reused
• D.the ability to prevent a password from ever being reused
• E.the number of days for which an account may be inactive before it is locked
• F.the number of days for which an account is locked after the configured number of login attempts has been reached
• G.the number of hours for which an account is locked after the configured number of login attempts has been reached

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

• A.SELECT * FROM customers WHERE city LIKE 'D_%';
• B.SELECT * FROM customers WHERE city LIKE 'D_';
• C.SELECT * FROM customers WHERE city = 'D_%';
• D.SELECT * FROM customers WHERE city = '%D_';

Comment: *

Name: *

Email: *

Verification: *