Oracle 1z0-083 Exam Questions Free Practice Test

Viewing page 4 out of 8 pages

Viewing questions 31-40 out of questions

Questions # 31:

Choose three. Which three are true about the tools for diagnosing Oracle Database failure situations?

Options:

RMAN can always repair corrupt blocks.

Flashback commands help with repairing physical errors.

The ADR can store metadata in an Oracle Database repository.

The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

The Data Recovery Advisor uses the ADR.

Expert Solution

Questions # 32:

Choose two. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

Options:

Data Recovery Advisor can proactively check for failures.

Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

ata Recovery Advisor can be used if a database is in the NOMOUNT state.

A failure can be closed only if the database is in MOUNT state.

Data Recovery Advisor can be used if a database is closed.

Expert Solution

Questions # 33:

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

Options:

using Database Replay

using SQL Developer

using Oracle Data Pump

using operating system file copy utilities

using Database Upgrade Assistant

using the CREATE TABLE AS SELECT SQL statement

Expert Solution

Questions # 34:

Which two are true about Oracle Flashback features? (Choose two.)

Options:

FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

FLASHBACK TABLE can undrop a column.

FLASHBACK DROP can undrop an index when undropping a table.

After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Expert Solution

Questions # 35:

Choose two. Which two are true about backup encryption?

Options:

The Transparent Data Encryption (TDE) keystore is backed up using RMAN.

Vendor-specific media management software can be used for making encrypted RMAN backups to media.

The BACKUP BACKUPSET command can encrypt and decrypt backup sets.

Image copies can be encrypted.

Keystore-based encryption is the default mode for RMAN backup encryption.

Backup encryption can be enabled selectively for specific tablespaces.

Expert Solution

Questions # 36:

choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?

Options:

user-managed backups of data files and control files

flashback logs

RMAN backups that are obsolete

archived redo log files that have multiple copies in a different archive location

Expert Solution

Questions # 37:

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

Options:

A PDB snapshot depends on an existing storage snapshot of the source PDB.

APDB snapshot can be a full copy of a source PDB.

A PDB snapshot can be a sparse copy of a source PDB

A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

A snapshot copy PDB can be a full copy of a source PDB

Expert Solution

Questions # 38:

Choose four. Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

Options:

It can be performed using an auxiliary instance managed by RMAN.

It can be performed using an auxiliary instance managed by a DBA.

It can be used to recover a truncated table.

It can be performed repeatedly until the correct time is found without using an RMAN catalog. E)RMAN always includes tablespaces containing UNDO segments in the recovery set.

RMAN automatically adds any required tablespaces to the recovery set to make it selfcontained. G) FLASHBACK DATABASE must be enabled for it to work. H) It can be used to recover a dropped

tablespace.

Expert Solution

Questions # 39:

Which three statements are true about the keystore storage framework for transparent data encryption?

Options:

It facilitates and helps to enforce keystore backup requirements.

It handles encrypted data without modifying applications.

It enables a keystore to be stored only in a file on a file system.

It enables separation of duties between the database administrator and the security administrator.

It transparently decrypts data for the database users and applications that access this data.

It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Expert Solution

Questions # 40:

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

Options:

It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

It fails because the command does notspecify when the unified audit policy should be enforced.

It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

It fails because system privileges cannot be granted with roles in the same audit policy.

Expert Solution

Viewing page 4 out of 8 pages

Viewing questions 31-40 out of questions

Pass the Oracle Oracle Database 19c 1z0-083 Questions and answers with CertsForce