Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 91:

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

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

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

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

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

  Correct Answer: AB

• Question 92:

  View the Exhibit.

  

  You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.

  Which configuration could have enabled the block selection of 16 KB?

  A. Choosing the extent allocation type to uniform

  B. Choosing the Segment Space Management option to manual

  C. Setting autoextension on for the data file mentioned for the tablespace

  D. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

  Correct Answer: D

• Question 93:

  You are installing Oracle Database 11g on a machine. When you run the installer, the Universal Installer

  (OUI) shows the message that says one of the product-specific prerequisite checks has failed:

  Checking available swap space requirements ...

  Expected result: 1512MB

  Actual Result: 1018MB

  Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have the

  required swap space.

  What happens to the installation in this situation?

  A. It can be continued.

  B. It resizes the swap space automatically when you proceed further.

  C. It can be continued, but the instance cannot be started without increasing the swap space.

  D. It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed.

  Correct Answer: A

• Question 94:

  You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.

  Which statement is true in this case?

  A. The ORACLE_BASE parameter is not set.

  B. The installation is being performed by the root user.

  C. The operating system group that will be specified should have root user as its member.

  D. The installation is being performed without the "Create Starter Database" option selected.

  E. The operating system group that will be specified must have permission to write to the inventory directory.

  Correct Answer: E

• Question 95:

  Identify two situations in which the block header grows in a data block. (Choose two.)

  A. When row directories need more row entries

  B. When there is row migration in the data block

  C. When there is an increase in the PCTFREE value for the data block

  D. When more transaction slots are required than are initially configured

  Correct Answer: AD

• Question 96:

  You have executed this command to change the size of the database buffer cache:

  SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;

  System altered.

  To verify the change in size, you executed this command:

  

  Why is the value set to 4194304 and not to 2516582?

  A. Because 4194304 is the granule size

  B. Because 4194304 is the standard block size

  C. Because 4194304 is the largest nonstandard block size defined in the database

  D. Because 4194304 is the total size of data already available in the database buffer cache

  Correct Answer: A

• Question 97:

  In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.

  What would you do to automate this configuration for the memory components with change in mode of working?

  A. Set the SGA_TARGET initialization parameter to zero.

  B. Set the PRE_PAGE_SGA initialization parameter to TRUE.

  C. Set the MEMORY_MAX_TARGET initialization parameter to zero.

  D. Set the SGA_TARGET initialization parameter to a nonzero value.

  Correct Answer: D

• Question 98:

  Examine the following output:

  

  Which two statements about the above index are true? (Choose two.)

  A. It is ignored by the query optimizer.

  B. It is not used while the index is being rebuilt.

  C. The index cannot be rebuilt, and has to be re-created.

  D. The index is automatically rebuilt when used the next time.

  Correct Answer: AB

• Question 99:

  You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).

  Some of the requirements set for your database creation task are:

  1.

  Configure the database to operate in shared server mode.

  2.

  Disable automatic maintenance tasks such as optimizer statistics collection.

  3.

  Configure a naming method to help the remote user connect to the database instance.

  4.

  Use Automatic Storage Management (ASM) for storing the database files.

  5.

  Configure daily database backup to flash recovery area.

  6.

  Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database?

  A. 4 and 6

  B. 2, 3, 4, and 6

  C. 1, 2, 4, 5, and 6

  D. 1, 2, 3, 4, 5, and 6

  Correct Answer: C

• Question 100:

  The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:

  1.

  Shut down the instance, if not already done.

  2.

  Copy one of the remaining control files to a new location.

  3.

  Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.

  4.

  Start up the database instance to the NOMOUNT stage.

  5.

  Recover the database to the point of failure of the control file.

  6.

  Open the database.

  Identify the correct sequence of steps?

  Exhibit:

  

  A. 1, 2, 4, 3, 5, 6

  B. 2, 4, 3, 5, 6; 1 not required

  C. 4, 5, 6, 2, 3; 1 not required

  D. 5, 2, 3, 4; 1 and 6 not required

  Correct Answer: A