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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

• A.A client can connect to an Oracle database instance even If no client side network admin has been configured.
• B.Local Naming requires setting the TNS_ADMIN environment variable on the client side.
• C.Easy Connect supports TCP/IP and SSL.
• D.Local naming can be used if Connect-Time Failover Is required.
• E.Directory Naming requires setting the TNS_ADMIN environment variable on the client side.
• F.Directory Naming can be used if Connect-Time Failover is required.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Enterprise Manager (EM) Express?

• A.You cannot start up a database instance using EM Express.
• B.EM Express uses a separate repository database to store target database metadata.
• C.You can use a single instance of EM Express to manage multiple database running on the same server.
• D.You can shut down a database instance using EM Express.
• E.By default, EM express is available for a database after database creation using DBCA.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

• A.They can be written by server processes
• B.Trace files are written to the Fast Recovery Area (FRA)
• C.They can be written by background processes
• D.All trace files contain error information that require contacting Oracle Support
• E.Trace file names are based on the database name concatenated with a sequential number

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

Comment: *

Name: *

Email: *

Verification: *