Examine this command:

Which two statements are true? (Choose two.)

• A.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• B.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• C.The file is renamed and stored in the same location
• D.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• E.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A.Usernames of all users including database administrators are stored in the data dictionary
• B.Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• C.It is owned by the SYSTEM user
• D.The data dictionary is created and maintained by the database administrator
• E.Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• F.Base tables can be queried directly

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

• A.Duplicates are eliminated automatically by the UNION ALL operator
• B.NULLS are not ignored during duplicate checking
• C.The number of columns selected in each SELECT statement must be identical
• D.The names of columns selected in each SELECT statement must be identical
• E.The output is sorted by the UNION ALL operator

Comment: *

Name: *

Email: *

Verification: *

Which three are types of segments in an Oracle Database? (Choose three.)

• A.undo
• B.index
• C.stored procedures
• D.sequences
• E.tables
• F.clusters

Comment: *

Name: *

Email: *

Verification: *

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.Aggregate functions can be nested to any number of levels
• D.The MAX and MIN functions can be used on columns with character data types

Comment: *

Name: *

Email: *

Verification: *