Free Oracle 1z0-074 Exam Dumps Questions & Answers

You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events.
Which four might be reasons for these? (Choose four.)

• A.  Blocks are ageing out of the buffer cache frequently.
• B.  The buffer cache is undersized.
• C.  A large number of connected user sessions are idle.
• D.  Cursors are closed explicitly after each execution.
• E.  Too many sort operations are being performed.
• F.  DBWR is not writing the dirty buffers fast enough.
• G.  The same small number of blocks are repeatedly accessed by different sessions simultaneously.

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.  FLASHBACK DATABASE must be enabled.
• C.  The database must be in ARCHIVELOG mode.
• D.  There must be sufficient space to start the auxiliary instance.
• E.  RMAN can recover the table only from a backupset.
• F.  The database must be in the READ WRITE state.
• G.  An export dump file of the table must be available.
• H.  The COMPATIBLE parameter must be set to 12.0 or greater.

You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?

• A.  TEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise database.
• B.  User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in an on-premise database.
• C.  User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in the cloud.
• D.  User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are not encrypted anywhere.
• E.  TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud.

Identify two operations for which the bkup_api utility can be used. (Choose two.)

• A.  to define which system files are backed up
• B.  to define the frequency of automatic backups
• C.  to define the retention period for backups
• D.  to define which database configuration files are backed up
• E.  to define the cycle period for backups

Examine these statements:

Which statement is true?

• A.  All the statements will validate the conversion
• B.  Statements 2 and 3 will validate the conversion
• C.  Statement 1 will return an error
• D.  Only statement 3 will validate the conversion
• E.  Only statement 1 will validate the conversion