Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

• A.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• B.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• C.A TIMESTAMP data type column contains information about year, month, and day
• D.The CURRENT_TIMESTAMP function returns data without time zone information
• E.A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

Comment: *

Name: *

Email: *

Verification: *

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

• A.input files
• B.bad files
• C.password files
• D.control files
• E.dump files

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A.It must be the value of the SERVICE_NAMES parameter on the client side
• B.It must resolve to a valid connect descriptor in the server's tnsnames.ora file
• C.It must be the name of the server running the database to whose instance HR wishes to connect
• D.It must resolve to a valid connect descriptor in the client's tnsnames.ora file
• E.It must be the name of the database to whose instance HR wishes to connect

Comment: *

Name: *

Email: *

Verification: *

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

• A.Oracle Managed Files (OMF)
• B.Online table segment shrink
• C.Online index segment shrink
• D.Automatic data file extension (AUTOEXTEND)
• E.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *