Online Access Free 1Z0-082 Practice Test

Evaluate these commands which execute successfully:

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

• A.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• B.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• C.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• D.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
• E.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Which three statements are true about Oracle synonyms? (Choose three.)

• A.A synonym cannot be created for a PL/SQL package
• B.Any user can drop a PUBLIC synonym
• C.A SEQUENCE can have a synonym
• D.A synonym created by one user can refer to an object belonging to another user
• E.A synonym can be available to all users

Which two statements are true about Enterprise Manager (EM) Express?

• A.You can shut down a database instance using EM Express.
• B.By default, EM express is available for a database after database creation using DBCA.
• C.You cannot start up a database instance using EM Express.
• D.EM Express uses a separate repository database to store target database metadata.
• E.You can use a single instance of EM Express to manage multiple database running on the same server.

Which two are true about conventional path SQL load? (Choose two.)

• A.It always generates redo.
• B.It locks objects being processed.
• C.It cannot load data into clustered tables.
• D.It enforces referential integrity constraints.
• E.It does not generate UNDO.

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

• A.NULLS are not ignored during duplicate checking
• B.Duplicates are eliminated automatically by the UNION ALL operator
• 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