1Z0-034 Online Practice Questions and Answers

View the Exhibit to observe the error.

You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance.

What can you do to reduce the chance of this error in the future?

A. Increase the value of SGA_MAX_SIZE

B. Enable automatic memory management

C. Set the PRE_PAGE_SGA parameter to true

D. Lock the System Global Area (SGA) in memory

Your database initialization parameter file has the following entry:

SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3

Which statement is true regarding this setting?

A. It drops the connection after the specified number of login attempts fail for any user.

B. It is enforced only if the password profile is enabled for the user.

C. It locks the user account after the specified number of attempts.

D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBAprivilege.

In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators.

In addition, reports are generated using complex joins with non-equality operators. What table organization is the best for this workload?

A. heap table

B. object table

C. external table

D. sorted hash clustered table

E. global temporary table

F. hash clustered table

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.

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.

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

A. An upper limit on how far you can flash back the database, depending on the information in the redo logs

B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database

Which two statements are true about encrypting RMAN backups?

A. The transparent encryption of backups uses the encryption wallet.

B. The database uses the same encryption key for every encrypted backup.

C. The password encryption of backups only uses the password while creating and restoring backups.

D. If transparent encryption is configured, you cannot use the set encryption by password command to make password-protected backups.

You issued the following commands to configure settings in RMAN:

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO Sbt;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE

ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE

BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Then you issued the following command to take the backup:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of the above command?

A. The backup will terminate because the FORMAT clause was not configured for the channel

B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

C. It backs up the data files and archived log files to disk, making two copies of each data file and archived logfile

D. It backs up the data files and archived log files to tape, making two copies of each data file and archived logfile

Evaluate the following block of code:

What is the outcome of the above code?

A. It produces an error because a fully qualified host name needs to be specified.

B. It produces an error because the range of ports associated with the hosts has not been specified.

C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.

D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.

Evaluate the following statements:

CREATE TABLE purchase_orders (

po_id NUMBER(4),

po_date TIMESTAMP,

supplier_id NUMBER(6),

po_total NUMBER(8,2),

CONSTRAINT order_pk PRIMARY KEY(po_id))

PARTITION BY RANGE(po_date) (

PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'), PARTITION Q2 VALUES

LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'), PARTITION Q3 VALUES LESS THAN (TO_DATE('1oct-2007','d-mon-yyyy'), PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy'));

CREATE TABLE purchase_order_items (

po_id NUMBER(4) NOT NULL,

product_id NUMBER(6) NOT NULL,

unit_price NUMBER(8,2),

quantity NUMBER(8),

CONSTRAINT po_items_fk FOREIGN KEY (po_id)

REFERENCES purchase_orders(po_id))

PARTITION BY REFERENCE(po_items_fk);

What are the two consequences of the above statements? (Choose two.)

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?

A. You must shut down the database instance to perform the backups.

B. You must configure the flash recovery area (fast recovery area) for the database.

C. You can perform complete database backups without closing the database.

D. All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.

Identify two correct statements about the Active Session History (ASH) data.

A. A part of SGA memory is used to store ASH data as rolling buffer.

B. The ASH data can be analyzed between any two small time intervals.

C. All ASH data in memory are flushed to disk by MMON in every 3 seconds.

D. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.

One of the disks in the disk group becomes unavailable because of power failure. You issued the following

command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';

To which disks in the disk group will the new value be applicable?

A. all disks in the disk group

B. all disks that are currently in OFFLINE mode

C. all disks that are not currently in OFFLINE mode

D. all disks in the disk group only if all of them are ONLINE

You executed the following query:

SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

A. The time when the last flashback operation in your database was performed

B. The time when the first flashback operation in your database was performed

C. The approximate time and the lowest system change number (SCN) to which you can flash back your database

D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance