Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 101:

  Your database instance is started using the server parameter file (SPFILE). You executed a command to

  change the value of the LOG_BUFFER initialization parameter:

  ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;

  What would be the outcome of this command?

  A. The command succeeds only if Automatic Memory Management is not enabled.

  B. The command succeeds, but you need to restart the database for changes to take effect.

  C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.

  D. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).

  Correct Answer: C

• Question 102:

  View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:

  SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US

  FROM v$memory_dynamic_components

  WHERE current_size!=0;

  What do you infer from this?

  Exhibit:

  A. The database instance is running with manual PGA management.

  B. The database instance is running with manual shared memory management.

  C. The database instance has the MEMORY_TARGET value set to a nonzero value.

  D. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

  Correct Answer: C

• Question 103:

  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

  Correct Answer: C

• Question 104:

  You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:

  1) Shut down the instance.

  2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.

  3) Execute the ALTER DATABASE FLASHBACK OFF command.

  4) Start up the instance and mount the database.

  5) Execute the ALTER DATABASE FLASHBACK ON command.

  6) Open the database.

  Select the correct order in which these tasks need to be performed.

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

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

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

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

  Correct Answer: A

• Question 105:

  Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?

  A. Run the root.sh script.

  B. Create the oraInst.loc file.

  C. Create the tnsnames.ora file.

  D. Run the oraInstRoot.sh script.

  Correct Answer: B

• Question 106:

  Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  A. The ADDM requires at least four AWR snapshots for analysis

  B. The ADDM runs after each AWR snapshot is collected automatically by MMON

  C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

  D. The ADDM analysis provides only diagnostics information but does not provide recommendations

  E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

  Correct Answer: BC

• Question 107:

  database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server: $ impdp system/manager directory = DB_DATA

  dumpfile = schemas.dat schemas = hr flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"

  The command fails displaying the following error:

  ORA-39001: invalid argument value

  ORA-39000: bad dump file specification

  ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA- 27037: unable

  to obtain file status

  What would you do to overcome the error?

  A. Add the user, SYSTEM, to the schemas option.

  B. Add the network_link = devdb.us.oracle.com option.

  C. Change the dumpfile option to [email protected].

  D. Replace the schemas option with the network_link = devdb.us.oracle.com

  E. Replace the dumpfile option with the network_link = devdb.us.oracle.com

  Correct Answer: E

• Question 108:

  To make audit information more productive, the DBA executes the following command before starting an audit operations:

  SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;

  Which statement is true regarding the audit record generated when auditing starts after restarting the database?

  A. It contains only the plan for the SQL statement executed by the user

  B. It contains the SQL text executed by the user and the bind variables used with it

  C. It contains the plan and statistics associated with the SQL statement executed by the user

  D. It contains the plan for the SQL statement executed by the user and the bind variables used with it

  Correct Answer: B

• Question 109:

  See the Exhibit to observe the roles assigned to the SL_REP user.

  

  Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP

  user?

  A. The user must enable the role explicitly

  B. The user can grant the role to other users

  C. The user cannot user the role until the DBA enables it explicitly

  D. The user can start using the role immediately without any changes

  Correct Answer: A

• Question 110:

  While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

  A. Validate the index structure using the ANALYZE .... INDEX command

  B. Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command

  C. Change the block space utilization parameters using the ALTER INDEX command

  D. Deallocate the unused space in the index using the ALTER INDEX ... DEALLOCATE UNUSED command

  Correct Answer: B