Free Oracle 1Z1-082 Exam Dumps Questions & Answers

Which two statements are true about interval data types?

• A.  INTERVAL day to second columns support fractions of seconds.
• B.  INTERVAL year TO month columns support yearly intervals.
• C.  INTERVAL year to month columns only support monthly Intervals within a single year.
• D.  INTERVAL year to month columns only support monthly intervals within a range of years.
• E.  The year field in an interval year to month column must be a positive value.
• F.  The value in an interval day to SECOND column can be copied into an interval year to month column.

Which two statements are true about the Oracle Data Dictionary?

• A.  Data dictionary views are always created with queries that join two or more base tables.
• B.  Data dictionary base tables can be queried directly.
• C.  All data dictionary view joins base tables to dynamic performance views.
• D.  It is owned by the system user.
• E.  It is owned by the sys user.

You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.  ROW STORE COMPRESS ADVANCED
• B.  ROW STORE COMPRESS BASIC
• C.  COLUMN STORE COMPRESS FOR QUERY LOW
• D.  COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E.  COLUMN STORE COMPRESS FOR ARCHIVE LOW

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

• A.  The initialization parameter file is read
• B.  The alert log records the execution details
• C.  The control file is read
• D.  The online redo logs are opened
• E.  The Oracle background processes are started
• F.  The online data files are opened

Which three statements are true concerning logical and physical database structures? (Choose three.)

• A.  The extents of a segment must always reside in the same datafile
• B.  A segment's blocks can be of different sizes
• C.  Segments can span multiple tablespaces
• D.  All tablespaces may have one or more data files
• E.  A smallfile tablespace might be bigger than a bigfile tablespace
• F.  A segment can span multiple data files in some tablespaces
• G.  A segment might have only one extent