Online Access Free 1z0-497 Exam Questions

Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?

• A.full redaction
• B.random redaction
• C.no redaction
• D.regular expressions
• E.partial redaction

Which two statements about the Process Monitor (PMON) process are true?

• A.PMON resolves failures of distributed transactions.
• B.During instance startup, PMON takes care of instance recovery.
• C.PMON performs process recovery when a client process fails.
• D.PMON restarts background and dispatcher processes when they fail.
• E.PMON performs listener registration.

Which new process was introduced as of Oracle Database 12c?

• A.Result Cache Background process (RCBG)
• B.Listener Registration process (LREG)
• C.AQ Coordinator process (QMNC)
• D.Change Tracking Writer process (CTWR)

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

• A.You can perform incomplete recovery by using the command:
  RESTORE DATABASE;
  FROM TAG "consistent_whole_backup";
  RECOVER DATABASE NOREDO;
• B.Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.
• C.Media recovery is possible in most cases.
• D.You can perform complete recovery by using the command:
  RESTORE DATABASE
  FROM TAG"consistent_whole_backup";
  RECOVER DATABASE;

Which two statements are true about the B-tree Index?

• A.The leaf blocks in the index are doubly linked.
• B.Rows with a NULL value in key columns also have entries in the Index.
• C.The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.
• D.The leaf node stores a bitmap for each key value.