Which two are true about the roles? (Choose two.)

• A.All privileges and roles granted to a user are enabled by default when the user logs in.
• B.The ALTER USER statement must be used to set specific default roles for a user.
• C.The SET ROLE statement enables as well as disables roles in a session.
• D.A role must be disabled before it can be revoked from a user.
• E.The SET ROLE statement can be used once per session.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
* Be stored in a format supporting date arithmetic without using conversion functions
* Store a loan period of up to 10 years
* Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A.TIMESTAMP
• B.TIMESTAMP WITH LOCAL TIMEZONE
• C.TIMESTAMP WITH TIMEZONE
• D.INTERVAL DAY TO SECOND
• E.INTERVAL YEAR TO MONTH

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

Comment: *

Name: *

Email: *

Verification: *

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A.T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• B.T1 only
• C.no segments are created
• D.T1, an index segment for the primary key, and a LOB segment only
• E.T1 and an index segment created for the primary key only

Comment: *

Name: *

Email: *

Verification: *