Oracle Oracle Certifications 1Z0-034 Questions & Answers

• Question 71:

  Which statements are true regarding system-partitioned tables? (Choose all that apply.)

  A. Only a single partitioning key column can be specified.

  B. All DML statements must use partition-extended syntax.

  C. The same physical attributes must be specified for each partition.

  D. Unique local indexes cannot be created on a system-partitioned table.

  E. Traditional partition pruning and partitionwise joins are not supported on these tables.

  Correct Answer: DE

• Question 72:

  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.

  Correct Answer: B

• Question 73:

  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.

  Correct Answer: C

• Question 74:

  What two are the prerequisites for enabling Flashback Database?

  A. The database must be in ARCHIVELOG mode

  B. The database must be in MOUNT EXCLUSIVE mode

  C. The database must be opened in RESTRICTED mode

  D. The database instance must be started in the NOMOUNT state

  E. The database instance must have the keep buffer pool defined

  Correct Answer: AB

• Question 75:

  View the Exhibit to examine the replay settings for replay parameters.

  What is the implication for setting the values for replay parameters? (Choose all that apply.)

  Exhibit: A. The COMMIT order in the captured workload is preserved during replay.

  

  B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

  E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

  Correct Answer: ACD

• Question 76:

  In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.

  Which method must you use to recover the lost data?

  A. Complete Recovery with online redo log

  B. Complete Recovery with archived redo log

  C. Tablespace Point-in-Time Recovery (TSPITR)

  D. Incomplete Recovery with system change number (SCN)

  Correct Answer: C

• Question 77:

  You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 78:

  Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

  

  A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.

  B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.

  C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.

  D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.

  Correct Answer: C

• Question 79:

  Which two statements are true about the duplexing of the backups taken by RMAN?

  A. It's only supported for the backups performed on the tape

  B. It is not supported for backup operations that produce image copies

  C. Duplex backups need a parallelism for the device to be equal to number of copies

  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

  Correct Answer: BD

• Question 80:

  To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

  A. Multiple change tracking files can be created for a database.

  B. The change tracking file must be created after the first level 0 backup.

  C. RMAN does not support backup and recovery of the change tracking file.

  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

  Correct Answer: CD