Which statement is true about aggregate functions?

• A.Aggregate functions can be used in any clause of a SELECT statement
• B.The AVG function implicitly converts NULLS to zero
• C.The MAX and MIN functions can be used on columns with character data types
• D.Aggregate functions can be nested to any number of levels

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

• A.A column that is set to UNUSED still counts towards the limit of 1000 columns per table
• B.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
• C.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
• D.Partition key columns cannot be dropped.
• E.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
• F.A DROP COLUMN command can be rolled back

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: *

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• B.It generates a sql script that it uses to load data from EMP.DAT to EMP
• C.It overwrites data in EMP with data in EMP.DAT
• D.It uses the database buffer cache to load data
• E.It appends data from EMP.DAT to EMP

Comment: *

Name: *

Email: *

Verification: *

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

• A.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• B.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• C.The CURRENT_TIMESTAMP function returns data without time zone information
• D.A TIMESTAMP data type column contains information about year, month, and day
• 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: *