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

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

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldrexecution? (Choose two.)

• A.It appends data from EMP.DAT to EMP
• B.It generates a sql script that it uses to load data from EMP.DAT to EMP
• C.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• D.It overwrites data in EMP with data in EMP.DAT
• E.It uses the database buffer cache to load data

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

• A.The Oracle Net Configuration Assistant is only used when running the Oracle installer
• B.The lsnrctl utility requires a listener.ora file to exist before it is started
• C.Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
• D.Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
• E.Oracle Net Manager can be used to locally configure naming methods on a database server
• F.Oracle Net Manager can be used to centrally configure listeners on any database server target

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

• A.Connect Time Failover requires the use of Transparent Application Failover (TAF)
• B.Source Routing requires the use of a name server
• C.Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
• D.Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
• E.Load Balancing requires the use of a name server
• F.Connect Time Failover requires the connect string to have two or more listener addresses configured

Comment: *

Name: *

Email: *

Verification: *