A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

• A.The command fails because the script must refer to the full path name
• B.The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
• C.The command succeeds and HR will be connected to the orcl and abc.sql databases
• D.The command fails and reports an error because @ is used twice

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

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A.writing inbound request to the common request queue from all shared server connections
• B.checking for outbound shared server responses on the common outbound response queue
• C.receiving inbound requests from processes using shared server connections
• D.sending each connection input request to the appropriate shared server input queue
• E.broadcasting shared server session responses back to requesters on all connections
• F.sending shared server session responses back to requesters on the appropriate connection

Comment: *

Name: *

Email: *

Verification: *

Which three activities are recorded in the database alert log? (Choose three.)

• A.Data Definition Language (DDL) statements
• B.non-default database parameters
• C.block corruption errors
• D.deadlock errors
• E.session logins and logouts

Comment: *

Name: *

Email: *

Verification: *

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

• A.The value is changed only in the PFILE and takes effect at the next instance startup
• B.The value is changed for the current instance and in the PFILE
• C.It fails because the SCOPE clause is missing
• D.Change is applied to the current instance, but does not persist after instance restart

Comment: *

Name: *

Email: *

Verification: *