Examine this command:

Which two statements are true?

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A.It displays values for variables used only in the WHERE clause of a query
• B.It displays values for variables prefixed with &&
• C.It displays values for variables created by the DEFINE command
• D.It can be used in SQL Developer and SQL*Plus
• E.It can be used only in SQL*Plus

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

• A.V$TABLESPACE displays information that is contained in the controlfile about tablespaces
• B.Tablespace free space can be viewed in V$TABLESPACE
• C.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
• D.V$TABLESPACE displays information about tablespaces contained in the data dictionary
• E.Tablespace free space can be viewed in DBA_TABLESPACES

Comment: *

Name: *

Email: *

Verification: *

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• B.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• C.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• D.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• E.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

Comment: *

Name: *

Email: *

Verification: *

Which two are true about shrinking a segment online? (Choose two.)

• A.It is not possible to shrink either indexes or Index Organized Tables (IOTs)
• B.It always eliminates all migrated rows if any exist in the table
• C.To shrink a table it must have a PRIMARY KEY constraint
• D.To shrink a table it must have a UNIQUE KEY constraint
• E.To shrink a table it must have row movement enabled
• F.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Comment: *

Name: *

Email: *

Verification: *