Free Oracle 1z1-074 Exam Dumps Questions & Answers

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH.
For what purpose is this optimized?

• A.  for query performance and space saving with greater bias toward space saving
• B.  for query performance and space saving
• C.  for query performance only
• D.  for parallel query performance only
• E.  for space saving only

Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database 12c Release 2.

• A.  RMAN must use a recovery catalog.
• B.  The COMPATIBLE parameter must be set to 12.0 or greater.
• C.  RMAN can recover the table only from a backupset.
• D.  FLASHBACK DATABASE must be enabled.
• E.  There must be sufficient space to start the auxiliary instance.
• F.  The database must be in ARCHIVELOG mode.
• G.  An export dump file of the table must be available.
• H.  The database must be in the READ WRITE state.

Which statement is true about transportable tablespaces?

• A.  They can be administrative tablespaces such as SYSTEM or SYSAUX
• B.  The cannot be dictionary-managed tablespaces
• C.  The source tablespace can be encrypted
• D.  The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.

Examine this command:

Which statement is true?

• A.  Four worker processes are allocated when there is sufficient CPU available
• B.  Four worker processes are allocated to export only data
• C.  Four worker processes are allocated to export data and metadata
• D.  Four worker processes are active to export only metadata
• E.  Up to four worker processes are allocated to export data and metadata

You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks.
Which statement is true about limiting PGA usage for those users' sessions?

• A.  You cannot limit PGA for a set of database user sessions.
• B.  You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.
• C.  You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.
• D.  You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.
• E.  You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager