Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 41:

  You want to create a role to meet these requirements:

  1.

  The role is to be protected from unauthorized usage.

  2.

  The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict enabling of such roles?

  A. Create the role with external authentication.
  B. Create the role as a secure application role.
  C. Create the role as a password-protected role.
  D. Create a role and use Fine-Grained Access Control (FGAC) to secure the role.
  B. Create the role as a secure application role.

• Question 42:

  Which is the correct description of a pinned buffer in the database buffer cache?

  A. The buffer is currently being accessed
  B. The buffer is empty and has not been used
  C. The contents of the buffer have changed and must be flushed to the disk by the DBWn process
  D. The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk
  A. The buffer is currently being accessed

• Question 43:

  You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

  A. Flashback log files
  B. Backups that have become obsolete
  C. User managed backups of the data files and control files
  D. Archived redo log files that have multiple copies in a different archive location and not backed up
  A. Flashback log files
  B. Backups that have become obsolete

• Question 44:

  View the Exhibit and examine the output.

  

  Which two statements are true regarding the LISTENER2 listener? (Choose two.)

  A. The ORCL instance is registered dynamically with the listener.
  B. The ORCL instance is registered statically in the listener.ora file.
  C. The number of current client connections handled by the service handler is two.
  D. The total number of client connections handled so far by the service handler is two.
  B. The ORCL instance is registered statically in the listener.ora file.
  D. The total number of client connections handled so far by the service handler is two.

• Question 45:

  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
  A. Because 4194304 is the granule size

• Question 46:

  Your database is down. You log in as the user SYS and issue the following command:

  SQL>STARTUP

  Which steps occur and in what order as a result of executing this command?

  A. Only the instance is started.
  B. Instance is started and then database is mounted but not opened.
  C. Instance is started, then the database is mounted and finally opened.
  D. Instance is started, then the database is opened and finally mounted.
  C. Instance is started, then the database is mounted and finally opened.

• Question 47:

  In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?

  A. Optimizer statistics are collected automatically.
  B. Only timed operating system (OS) statistics and plan execution statistics are collected.
  C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
  D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
  E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
  C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

• Question 48:

  For which requirement should you configure shared servers?

  A. accommodating an increasing number of users who run analytical queries in a DSS environment with limited memory
  B. submitting backup jobs at regular, 24-hour intervals in an OLTP environment with limited memory
  C. using Recovery Manager (RMAN) to recover a database
  D. performing bulk-load operations in a DSS environment with limited memory
  E. accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited memory
  C. using Recovery Manager (RMAN) to recover a database

• Question 49:

  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 50:

  Identify the logical structure that will never have more than one data segment created for it.

  A. external table
  B. partitioned table
  C. partitioned index
  D. nonclustered table
  E. global temporary table
  D. nonclustered table