Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 1:

  Examine the commands executed in the following sequence:

  

  Which statement is true about the above commands?

  A. The commands execute successfully.
  B. Command 6 produces an error because of circular role grant.
  C. Command 5 produces an error because a role cannot be granted to another role.
  D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.
  E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
  B. Command 6 produces an error because of circular role grant.

• Question 2:

  View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:

  

  Which file is used to start the instance in this case? Exhibit:

  

  A. init.ora
  B. spfile.ora
  C. initorcl.ora
  D. spfile+ASM.ora
  B. spfile.ora

• Question 3:

  These are points that describe the contents of different memory components:

  1: Descriptive information or metadata about schema objects that are queried by using SQL statements

  2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements

  3: Results of SQL queries and PL/SQL functions

  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes

  5:

  The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in the Shared Pool if the necessary configurations are done?

  A. 1 and 2
  B. 2 and 5
  C. 1,3, and 4
  D. 3,4 and 5
  E. 1,2,3 and 4
  C. 1,3, and 4

• Question 4:

  Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)

  A. Avoid coding unnecessary longrunning transactions.
  B. Allow the database to handle locks in default locking mode.
  C. Always explicitly code the locks as per the requirement of the application.
  D. Allow escalation of row locks to block locks if too many row locks cause problem.
  A. Avoid coding unnecessary longrunning transactions.
  B. Allow the database to handle locks in default locking mode.

• Question 5:

  Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously. Some users of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?

  A. You would configure more listeners for the database.
  B. You would configure the database in shared server mode to use the connection pooling feature.
  C. You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
  D. You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
  B. You would configure the database in shared server mode to use the connection pooling feature.

• Question 6:

  In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

  A. if a table is not in a cluster
  B. if a table has an active trigger
  C. if a table has an encrypted column
  D. if a table has a column of data type LONG defined on it
  E. if a table has a referential integrity constraint defined on it
  B. if a table has an active trigger
  C. if a table has an encrypted column
  E. if a table has a referential integrity constraint defined on it

• Question 7:

  The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server: Which statement is true regarding the archived redo log files?

  

  A. It will be created on the local file system.
  B. It will be created only in the Flash Recovery Area.
  C. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.
  D. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter.
  A. It will be created on the local file system.

• Question 8:

  In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?

  A. Recompile the PL/SQL procedure.
  B. Modify the procedure to run with a definer's right.
  C. Modify the procedure to run with an invoker's right.
  D. Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.
  A. Recompile the PL/SQL procedure.

• Question 9:

  View the Exhibit and examine the initialization parameter settings.

  

  Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.)

  A. LOG_BUFFER
  B. SORT_AREA_SIZE
  C. JAVA_POOL_SIZE
  D. STREAMS_POOL_SIZE
  E. DB_16K_CACHE_SIZE
  F. DB_KEEP_CACHE_SIZE
  A. LOG_BUFFER
  E. DB_16K_CACHE_SIZE
  F. DB_KEEP_CACHE_SIZE

• Question 10:

  You executed the following commands in an RMAN session for your database instance that has failures:

  RMAN> LIST FAILURE;

  After some time, you executed the following command in the same session:

  RMAN> ADVISE FAILURE;

  But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

  A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
  B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
  C. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
  D. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
  A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.