1Z0-034 Online Practice Questions and Answers

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?

A. ALTER DATABASE FLASHBACK ON;

B. GRANT SELECT ANY TRANSACTION TO scott;

C. GRANT EXECUTE ON dbms_flashback TO scott;

D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

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

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?

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

B. 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.

C. 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.

D. 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 as UTL_TCP.

Examine the following scenario:

Database is running in ARCHIVELOG mode.

Complete consistent backup is taken every Sunday.

On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted

The disk having active online redo log files is also corrupted. The hardware is repaired and the paths for online redo log files and control files are still valid.

Which option would you use to perform the recovery of database till the point of failure?

A.

Restore the latest whole backup, perform complete recovery, and open the database normally

B.

Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGSoption.

C.

Restore the latest backups control file, perform complete recovery, and open the database with theRESETLOGS option.

D.

Restore the latest backup control file, perform incomplete recovery using backup control file, and open thedatabase with the RESETLOG option.

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.

Which statement is true in this situation?

A. The online redo log files and archived redo log files are required to accomplish the recovery

B. The uncommitted transaction will be committed at the next startup of the database instance

C. The uncommitted transaction is rolled back automatically at the next opening of the database

D. The DBA has to perform the recovery on the database to recover the uncommitted transaction

memory_target big integer 808M pga_aggregate_target big integer 0 sga_target big integer 0 SQL> SHOW PARAMETER SGA_MAX_SIZE

NAME TYPE VALUE ------------------------------------------------------------------------------------------------- sga_max_size big integer 808M Which statement is correct about the database?

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and

C. SGA_TARGET are set.

D. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set.

E. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

A. The tape I/O performed is asynchronous

B. The tape buffer is allocated from the System Global Area (SGA)

C. The tape buffer is allocated from the Program Global Area (PGA)

D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.

How would you achieve this?

A. Implement a profile for the users.

B. Implement external roles for the users.

C. Set the threshold for the undo tablespace.

D. Implement a Database Resource Manager plan.

Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?

A. Implement RMAN multiplexing

B. Set the DEBUG ON in the RMAN script

C. Specify the command ID in the RMAN script

D. Use a tag with the RMAN BACKUP command

You created a tablespace with the following statement:

CREATE BIGFILE TABLESPACE adtbs

DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;

There is now a requirement to increase the size of the tablespace.

Which two ALTER statements are correct in this scenario? (Choose two.)

A. ALTER TABLESPACE adtbs RESIZE 20G;

B. ALTER TABLESPACE adtbs ADD DATAFILE;

C. ALTER TABLESPACE adtbs AUTOEXTEND ON;

D. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;

E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

Which action should you perform immediately after using this command?

A. You should perform a log switch

B. You should make a backup of the database

C. You should switch the database to the NOARCHIVELOG mode

D. You should shut down the database instance and perform a complete database recovery