Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 81:

  Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

  A. You can add SQL test cases to the incident package.

  B. You can add or remove the trace files to the package.

  C. You cannot create an incremental incident package when the physical files are purged from the ADR.

  D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

  Correct Answer: ABD

• Question 82:

  You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.

  Which is the most effective method to access this data in your database?

  A. Use the database link.

  B. Use the SQL*Loader utility.

  C. Use the Oracle Data Pump utility.

  D. Create an external table and leave the data in the flat file.

  Correct Answer: D

• Question 83:

  Which statement is true about a whole consistent database backup on a database running in

  ARCHIVELOG mode?

  Exhibit:

  

  A. The backup will consist of used data blocks only.

  B. The database must be shut down to accomplish the backup.

  C. The backup can be accomplished without shutting down the database.

  D. The backup will contain all database files that have never been backed up.

  Correct Answer: B

• Question 84:

  Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

  A. It is the time period after which the undo data becomes obsolete.

  B. It is the time period after which the committed undo data would be transferred to a temporary tablespace.

  C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.

  D. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.

  Correct Answer: C

• Question 85:

  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?

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

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

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

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

  Correct Answer: C

• Question 86:

  You are using Enterprise Manager to schedule backups for your database. Which type of script would be generated by the backup scheduler?

  A. XML script

  B. PL/SQL script

  C. Operating system script

  D. Recovery Manager (RMAN) script

  Correct Answer: D

• Question 87:

  Observe the information in the columns: Which option has the correct match between the memory areas and their contents?

  

  A. 1-c, 2-b, 3-d, 4-a

  B. 1-b, 2-c, 3-d, 4-a

  C. 1-a, 2-b, 3-c, 4-d

  D. 1-a, 2-b, 3-d, 4-c

  Correct Answer: C

• Question 88:

  In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:

  1.

  The user account must be locked after four unsuccessful login attempts.

  2.

  The user must be prompted to change the password at regular intervals.

  3.

  The user may not have more than three simultaneous sessions.

  4.

  The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above?

  A. By assigning profiles for the users

  B. By implementing Fine-Grained Auditing (FGA)

  C. By granting a secure application role to the users

  D. By implementing the Database Resource Manager plan

  Correct Answer: A

• Question 89:

  Which two statements are true regarding a PL/SQL package body? (Choose two.)

  A. It cannot be created without a package specification.

  B. It cannot invoke subprograms defined in other packages.

  C. It can contain only the subprograms defined in the package specification.

  D. It can be changed and recompiled without making the package specification invalid.

  Correct Answer: AD

• Question 90:

  The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every product is identified by a product code, which is the primary key.

  As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products, the company deals with many new products during every quarter.

  Which method is best suited for this quarterly data transfer?

  A. Using the MERGE command

  B. Using the SQL*Loader utility

  C. Using the correlated UPDATE command

  D. Using the INSERT command to perform bulk operation

  Correct Answer: A