[Free] 2018(Jan) EnsurePass Pass4sure Oracle 1z0-034 Dumps with VCE and PDF 71-80

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-034
100% Free Download! 100% Pass Guaranteed!

Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

Question No: 71

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?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A

Question No: 72

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

Ensurepass 2018 PDF and VCE

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

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

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

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

Answer: C

Question No: 73

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:

Ensurepass 2018 PDF and VCE

  1. The COMMIT order in the captured workload is preserved during replay.

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

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

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

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

Answer: A,C,D

Question No: 74

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?

  1. Complete Recovery with online redo log

  2. Complete Recovery with archived redo log

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

  4. Incomplete Recovery with system change number (SCN)

Answer: C

Question No: 75

Evaluate the following block of code:

Ensurepass 2018 PDF and VCE

What is the outcome of the above code?

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

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

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

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

Answer: C

Question No: 76

What two are the prerequisites for enabling Flashback Database?

  1. The database must be in ARCHIVELOG mode

  2. The database must be in MOUNT EXCLUSIVE mode

  3. The database must be opened in RESTRICTED mode

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

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

Answer: A,B

Question No: 77

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

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

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

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

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

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

Answer: D,E

Question No: 78

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?

  1. Implement a profile for the users.

  2. Implement external roles for the users.

  3. Set the threshold for the undo tablespace.

  4. Implement a Database Resource Manager plan.

Answer: B

Question No: 79

You created a database with the Database Configuration Assistant (DBCA) by using one of the default templates.

Which tablespace will be the default permanent tablespace for non-system users, excluding DBSNMP and OUTLN?

  1. USERS





Answer: A Explanation: USERS

This tablespace is used to store permanent user objects and data. Like the TEMP tablespace, every database should have a tablespace for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM tablespace, which is not good practice. In the preconfigured database, USERS is assigned the default tablespace, and space for all objects created by non-system users comes from this tablespace. For system users, the default permanent tablespace remains SYSTEM. REF.: Oracle(r) 10g 2 Days DBA, 6-7

Question No: 80

While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours.

Which view would you query to determine the name and status of the stopped job?






Answer: D Explanation:

When a Datapump Export or Import session is launched, a Datapump Job is automatically tarted. This way, we can:* detach from and reattach to long-running jobs without affecting the job itself.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.