Oracle 1z0-034 Exam Questions

Question 6 of 148

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?

ALTER DATABASE FLASHBACK ON;

GRANT SELECT ANY TRANSACTION TO scott;

GRANT EXECUTE ON dbms_flashback TO scott;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

ALTER TABLESPACE undots1 RETENTION GUARANTEE;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Correct Answer: B, C, D, F

Question 7 of 148

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self- consistent.

The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self- consistent.

The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is

Correct Answer: A

Question 8 of 148

You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.
Identify two prerequisites to perform the backups. (Choose two.)

The database must be opened in restricted mode.

The database must be configured to run in ARCHIVELOG mode.

The tablespaces are required to be in backup mode before taking the backup.

The tablespaces are required to be in read-only mode before taking the backup

Correct Answer: B, C

Question 9 of 148

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the
DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?

It is a list of remote database links stored in the XML file that are available to the users of the database.

It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.

It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.

It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such

Correct Answer: B

Question 10 of 148

View the Exhibit and examine the RMAN commands.
Exam 1z0-034: Question 10 - Image 1

Which statement describes the effect of a backup retention policy on the backup of a backup set?

Either all the copies of a backup set are obsolete or none of them are as per the retention policy.

The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.

The copies of the backup will be reported as obsolete under a recovery window-based backup retentionpolicy.

All the copies of the backup set are counted as one instance of a backup and will deleted in backup setexceeds the redundancy-based backup retention policy.

Correct Answer: A