[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-052 Dumps with VCE and PDF Download 131-140

Latesttests 2018 Jan Oracle Official New Released 1z0-052
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration I

Question No: 131 – (Topic 2)

Note the following points describing various utilities in Oracle Database 11g: Which point describes the Oracle Data Pump utility?

  1. It enables the transfer of data from one database to another

  2. It provides a complete solution for the backup, restoration and recovery needs of the entire database

  3. It enables the loading of data from an external file into tables of an Oracle Database

  4. It provides a tape backup management for the Oracle ecosystem

    1. 1

    2. 2

    3. 3

    4. 4

    5. 1 and 3

F. 1, 2, 3 and 4

Answer: A

Question No: 132 – (Topic 2)

See the Exhibit:

Latesttests 2018 PDF and VCE

Identify the component marked with a question mark:

  1. Checkpoint (CKPT)

  2. Process Monitor (PMON)

  3. Archiver Processes (ARcn)

  4. Recoverer Process (RECO)

  5. Memory Manager Process (MMAN)

Answer: A

Question No: 133 – (Topic 2)

You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.

Which three statements are true about these backups? (Choose three.)

  1. The backups would be consistent.

  2. The backups would be inconsistent.

  3. The backups would be possible only if the database is running in ARCHIVELOG mode.

  4. The backups would be possible only if the database is running in NOARCHIVELOG mode.

  5. The backups need to be restored and the database has to be recovered in case of a media failure.

Answer: B,C,E Explanation:

鈥ecovery Manager (RMAX): Oracle Tool that provides a complete solution for the backup, restoration, and recovery needs of the entire database or of specific database files

Question No: 134 – (Topic 2)

Examine the values for the following initialization parameters:


Which two will be the implications of these values in your database? (Choose two.)

  1. The SGA advisor will be disabled

  2. The MTTR advisor will be disabled

  3. Automatic checkpoint tuning will be disabled

  4. Checkpoint information will not be written to the alert log file

Answer: B,C

Question No: 135 – (Topic 2)

Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

  1. The DML operations re-create the bitmap index blocks

  2. The bitmap index is rebuilt automatically after a DML operation

  3. The smallest amount of a bitmap that can be locked is a bitmap segment

  4. Additional time is taken to remove NULL values from the bitmap index after a DML operation

Answer: C

Question No: 136 – (Topic 2)

In your production database, data manipulation language (DML) operations are executed on the SALES table.

You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.

What action would you take to achieve this task?

  1. Apply fine-grained auditing.

  2. Implement value-based auditing.

  3. Impose standard database auditing to audit object privileges.

  4. Impose standard database auditing to audit SQL statements.

Answer: B

Question No: 137 – (Topic 2)

Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

  1. It can be increased up to the value of the SGA_MAX_SIZE parameter.

  2. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.

  3. Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.

  4. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.

Answer: A,B

Question No: 138 – (Topic 2)

You set the following parameters in the parameter file and restarted the database:


Which two statements are true about these parameters after the database instance is restarted?

(Choose two.)

  1. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

  2. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

  3. The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.

  4. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

Answer: A,D

Question No: 139 – (Topic 2)

Which two statements about the background process of the database writer are true? (Choose two.)

  1. It is possible to have multiple database writers in an Oracle instance.

  2. It writes dirty buffers, if any, to data files whenever a checkpoint occurs.

  3. It writes dirty buffers, if any, to data files whenever a transaction commits.

  4. It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.

    Answer: A,B

    Question No: 140 – (Topic 2)

    Note the following functionalities of various background processes:

    1. Record the checkpoint information in data file headers.

    2. Perform recovery at instance startup.

    3. Cleanup unused temporary segments.

    4. Free the resources used by a user process when it fails.

    5. Dynamically register database services with listeners.

    6. Monitor sessions for idle session timeout.

      Which option has the correct functionalities listed for a background process?

      1. Archiver Process (ARCn): 1, 2, 5

      2. System Monitor Process (SMON): 1, 4, 5

      3. Process Monitor Process (PMON): 4, 5, 6

      4. Database Writer Process (DBWn): 1, 3, 4

Answer: C

100% Free Download!
Download Free Demo:1z0-052 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-052 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE