In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A.Revoke the CREATE SESSION privilege from other users
• B.Execute DDL statements in the HR schema
• C.Revoke the CREATE SESSION privilege from user HR
• D.Log in to the database instance
• E.Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• F.Execute DML statements in the HR schema

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about UNDO and REDO? (Choose two.)

• A.The generation of UNDO generates REDO
• B.DML modifies Oracle database objects and only generates UNDO
• C.The generation of REDO generates UNDO
• D.DML modifies Oracle database objects and only generates REDO
• E.DML modifies Oracle database objects and generates UNDO and REDO

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_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount != NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND due_amount IS NOT NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
• E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

• A.Display suppliers whose PROD_LIST_PRICE is less than 1000
• B.Display the total number of products supplied by supplier 102 which have a product status of obsolete
• C.Display the minimum PROD_LIST_PRICE for each product status
• D.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• E.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

Comment: *

Name: *

Email: *

Verification: *