Examine this command:

Which two statements are true?

• A.Tables with one or more extents in this data file may be queried during the execution of this command.
• B.The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
• C.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• D.Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.
• E.It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

• A.The number, but not names, of columns must be identical for all SELECT statements in the query.
• B.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
• C.The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
• D.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
• E.The names and number of columns must be identical for all SELECT statements in the query.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED ? (Choose two.) RETENTION

• A.Active UNDO is always retained.
• B.Unexpired UNDO is always retained.
• C.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
• D.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• E.UNDO_RETENTION specifies how long all types of UNDO are retained.

Comment: *

Name: *

Email: *

Verification: *

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

• A.The sales user must have their quota on the users tablespace removed
• B.The sales user must have a quota on the TEMP tablespace
• C.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• D.The sales user must have been granted the CREATE SESSION privilege
• E.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• F.The sales user must have been granted the CREATE TABLE privilege

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

• A.UNION
• B.UNION ALL
• C.MINUS
• D.INTERSECT
• E.SUBTRACT

Comment: *

Name: *

Email: *

Verification: *