Which three statements are true about table data storage in an Oracle Database? (Choose three.)

• A.Data block headers contain their own Data Block Address (DBA)
• B.A table row piece can be chained across several database blocks
• C.Multiple row pieces from the same row may be stored in different database blocks
• D.Multiple row pieces from the same row may be stored in the same block
• E.Data block free space is always contiguous in the middle of the block
• F.Index block free space is always contiguous in the middle of the block

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Oracle synonyms? (Choose three.)

• A.A synonym cannot be created for a PL/SQL package
• B.A synonym can be available to all users
• C.A SEQUENCE can have a synonym
• D.A synonym created by one user can refer to an object belonging to another user
• E.Any user can drop a PUBLIC synonym

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about single row functions? (Choose two.)

• A.MOD : returns the quotient of a division operation
• B.FLOOR : returns the smallest integer greater than or equal to a specified number
• C.TRUNC : can be used with NUMBERand DATEvalues
• D.CONCAT : can be used to combine any number of values
• E.CEIL : can be used for positive and negative numbers

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 only
• B.T1, an index segment for the primary key, and a LOB segment only
• C.T1 and an index segment created for the primary key only
• D.no segments are created
• E.T1, an index segment for the primary key, a LOB segment, and a lobindex segment

Comment: *

Name: *

Email: *

Verification: *