Free Oracle 1Z1-082 Exam Dumps Questions & Answers

Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

• A.  It is guaranteed to complete within fast_start_mttr_target number of seconds.
• B.  It is always performed when opening a database.
• C.  No users can log on until instance recovery has completed.
• D.  The database opens after the roll forward phase of instance recovery has completed.
• E.  Only the CURRENT REDO log group is required to perform instance recovery.
• F.  It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.

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 cycles back to 1 after every 5000 numbers and can cycle 20 times
• 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.  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 is guaranteed not to generate duplicate numbers

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

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

Which two are true about RETENTION GUARANTEE? (Choose two.)

• A.  It prevents out-of-space errors.
• B.  It prevents FLASHBACK DATABASE operation failure.
• C.  It is a static parameter.
• D.  It prevents "Snapshot too old" errors.
• E.  It is a tablespace attribute.

Which two statements are true about segment types in an Oracle Database?

• A.  Index segments always have two or more extents.
• B.  Table segments always have two or more extents.
• C.  Cluster segments may contain data from multiple tables.
• D.  Temporary segments are only stored in a temporary tablespace.
• E.  Undo segments are only stored in an undo tablespace.