Free Oracle 1Z0-998 Exam Dumps Questions & Answers

You administer a database that is configured in ARCHIVELOG mode. A full RMAN backup exists. In which three scenarios is Complete Recovery possible?

• A.  after losing a SYSTEM tablespace data file
• B.  after losing all members of an ACTIVE online redo log group detected when attempting to open the database
• C.  after losing all members of the CURRENT online redo log group
• D.  after losing a data file from an UNDO tablespace that is in use
• E.  after restoring all control files from backup

You want to migrate your database from on-premises to OCI with no downtime. Which method would you use?

• A.  SQL Developer
• B.  Data Pump
• C.  Data Guard
• D.  Golden Gate

Which three prerequisites/conditions must be met to avoid patching failures for a DB system?

• A.  Oracle Clusterware must be up and running.
• B.  VCN used by the DB system must be configured with local peering gateway.
• C.  VCN used by the DB system must be configured with dynamic routing gateway.
• D.  At least 15GB of free space is available in /uOl for the execution of the patching process.
• E.  DB system must have connectivity to the applicable Swift endpoint for Object Storage.

You created a new PDB in a VM DB system and while creating a tablespace in the PDB an error is returned:
ORA-28374: typed master key not found in wallet.
Which three options would resolve this problem?

• A.  Change the location of the auto-login wallet.
• B.  Re-enable the auto-login wallet.
• C.  Delete the encryption wallet entry from the sqlnet.orA.
• D.  Disable the auto-login wallet and convert the wallet to password wallet.
• E.  Activate the master encryption key for the newly created PDB.

Which four are the advantages of migrating to Oracle Cloud Infrastructure?

• A.  supports RAC options only for bare metal shapes
• B.  performs automatic backups to object storage
• C.  has three way mirrored storage
• D.  has automated data Guard configuration for both primary and standby systems available across availability domains only
• E.  allows to run clustered databases on virtual machine DB systems
• F.  is integrated with Exadata to provide high performance, availability, and scalability