Free Oracle 1Z0-082 Exam Dumps Questions & Answers

Which two statements are true about Oracle synonyms?

• A.  A synonym can be created on an object in a package.
• B.  All private synonym names must be unique in the database.
• C.  A synonym has an object number.
• D.  Any user can create a PUBLIC synonym.
• E.  A synonym can have a synonym.

Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which two statements are true?

• A.  The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.
• B.  Queries and DML statements are allowed on ORDERS while the shrink is executing.
• C.  The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.
• D.  Only queries are allowed on ORDERS while the shrink is executing.
• E.  The high-water mark (HWM) of orders is adjusted.
• F.  Dependent indexes become UNUSABLE.

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

• A.  The foreign key constraint will be disabled.
• B.  The foreign key constraint will be enabled and deferred.
• C.  The foreign key constraint will be enabled and immediate.
• D.  The primary key constraint will be enabled and deferred.
• E.  The primary key constraint will be enabled and immediate.

A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

• A.  The command fails because the script must refer to the full path name
• B.  The command succeeds and HR will be connected to the orcl and abc.sql databases
• C.  The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
• D.  The command fails and reports an error because @ is used twice

Which three activities are recorded in the database alert log? (Choose three.)

• A.  Data Definition Language (DDL) statements
• B.  block corruption errors
• C.  session logins and logouts
• D.  deadlock errors
• E.  non-default database parameters