Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 151:

  You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files?

  A. Archiving will be disabled because the destination for the redo log files is missing
  B. The database instance will shut down and the error details will be logged in the alert log file
  C. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly
  D. Archiving will be enabled and the location for the archive redo log file will be created in the default location $ORACLE_HOME/log
  C. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly

• Question 152:

  Which is true about the Automatic Diagnostic Repository (ADR)?

  A. It only contains the alert log and trace files for background processes
  B. Its location is always set by the ORACLE_BASE variable
  C. It is used only if the DISGNOSTIC_DEST parameter is manually configured
  D. It includes diagnostic data for critical errors for each server and background process
  A. It only contains the alert log and trace files for background processes

• Question 153:

  Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)

  A. Running a query on a table returns "ORA-600: Internal Error."
  B. Inserting a value in a table returns "ORA-01722: invalid number."
  C. Creating a table returns "ORA-00955: name is already used by an existing object."
  D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."
  E. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."
  A. Running a query on a table returns "ORA-600: Internal Error."
  E. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."

• Question 154:

  Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this?

  A. To limit the User Global Area (UGA) memory allocated to a session from the SGA
  B. To limit the amount of memory to be used for the dispatcher queue of a session in SGA
  C. To limit the amount of memory to be used for the request pool in System Global Area (SGA)
  D. To control the amount of memory allocated in SGA for the local variables for each shared server process
  A. To limit the User Global Area (UGA) memory allocated to a session from the SGA

• Question 155:

  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?

  A. Apply fine-grained auditing.
  B. Implement value-based auditing.
  C. Impose standard database auditing to audit object privileges.
  D. Impose standard database auditing to audit SQL statements.
  B. Implement value-based auditing.

• Question 156:

  You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?

  A. Multiplex all database files.
  B. Configure the Flash Recovery Area.
  C. Configure the database instance for ARCHIVELOG mode.
  D. Configure the FAST_START_MTTR_TARGET initialization parameter.
  C. Configure the database instance for ARCHIVELOG mode.

• Question 157:

  You have an ORDERS table with the following structure:

  

  The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to ensure that the ODATE column must contain data for every order in future. Which method would serve the purpose?

  A. Modify the column using the ALTER TABLE ... MODIFY command.
  B. Add a UNIQUE constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.
  C. Add a NOT NULL constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.
  D. Add a PRIMARY KEY constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.
  A. Modify the column using the ALTER TABLE ... MODIFY command.

• Question 158:

  Which structure can span multiple data files?

  A. a bigfile tablespace
  B. an extent
  C. a temporary tablespace
  D. a permanent tablespace
  E. a segment
  E. a segment

• Question 159:

  See the Exhibit:

  

  Which statements are true regarding the USERS tablespace? (Choose all that apply.)

  A. A bitmap is used to record free extents
  B. Free extents information is managed within the tablespace
  C. Free extents information is managed in the SYSAUX tablespace
  D. The data dictionary tables are updated when extents are allocated or deallocated
  A. A bitmap is used to record free extents
  B. Free extents information is managed within the tablespace

• Question 160:

  You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation?

  A. The online redo log files and archived redo log files are required to accomplish the recovery
  B. The uncommitted transaction will be committed at the next startup of the database instance
  C. The uncommitted transaction is rolled back automatically at the next opening of the database
  D. The DBA has to perform the recovery on the database to recover the uncommitted transaction
  C. The uncommitted transaction is rolled back automatically at the next opening of the database