Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 311:

  Which three are true about server processes for dedicated server connections? (Choose three.)

  A. They can write and read consistent block images to Oracle data files.
  B. They can parse and execute SQL statements.
  C. They can read data blocks from data files into the default buffer cache.
  D. They can generate archive log entries.
  E. They can generate redo log entries.
  F. They can write current block images contained in clean buffers to Oracle data files.
  A. They can write and read consistent block images to Oracle data files.
  B. They can parse and execute SQL statements.
  C. They can read data blocks from data files into the default buffer cache.

  ---

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT1248

• Question 312:

  Your database instance has Automatic Memory Management enabled and supports shared server connections.

  Examine the following:

  1.

  Parallel execution messages and control structures

  2.

  Local variables for a process

  3.

  Security and resource usage information

  4.

  Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan

  5.

  SQL execution work areas

  Which option indicates what is allocated from the large pool in this instance?

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

• Question 313:

  You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.

  You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= `/dev/flash_device_1 `,' /dev/flash_device_2'

  How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

  A. Set DB_FLASH_CACHE_ZISE = 64G.
  B. Set DB_FLASH_CACHE_ZISE = 64G, 64G
  C. Set DB_FLASH_CACHE_ZISE = 128G.
  D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.
  B. Set DB_FLASH_CACHE_ZISE = 64G, 64G

  ---

  * Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g.

  In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for "Database Smart Flash Cache" area. In previous releases only one file|

  device could be defined.

  DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc

  DB_FLASH_CACHE_SIZE = 32G, 32G, 64G

  So above settings defines 3 devices which will be in use by "DB Smart Flash Cache"

  /dev/sda ?size 32G

  /dev/sdb ?size 32G

  /dev/sdc ?size 64G

  New view V$FLASHFILESTAT ?it's used to determine the cumulative latency and read counts of each file|device and compute the average latency

• Question 314:

  Which two statements are true about standard database auditing? (Choose two.)

  A. DDL statements can be audited.
  B. Statements that refer to standalone procedure can be audited.
  C. Operations by the users logged on as SYSDBA cannot be audited.
  D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.
  A. DDL statements can be audited.
  B. Statements that refer to standalone procedure can be audited.

• Question 315:

  Which three database operations can be performed only at MOUNT state? (Choose three.)

  A. performing Flashback Database
  B. renaming control files
  C. enabling or disabling ARCHIVELOG mode
  D. re-creating control files
  E. performing full database recovery
  A. performing Flashback Database
  C. enabling or disabling ARCHIVELOG mode
  E. performing full database recovery

• Question 316:

  When is the UNDO_RETENTION parameter value ignored by a transaction?

  A. when there are multiple undo tablespaces available in a database
  B. when the data file of the undo tablespace is autoextensible
  C. when the undo tablespace is of a fixed size and retention guarantee is not enabled
  D. when Flashback Database is enabled
  C. when the undo tablespace is of a fixed size and retention guarantee is not enabled

  ---

  References: https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

• Question 317:

  Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)

  A. Reduced logical I/O
  B. Reduced virtual memory utilization
  C. Improved parallel Execution performance
  D. Improved Serial Execution performance
  E. Reduced physical I/O
  F. Reduced CPU utilization
  B. Reduced virtual memory utilization
  C. Improved parallel Execution performance
  F. Reduced CPU utilization

  ---

  * Multiprocess and Multithreaded Oracle Database Systems

  Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the users--either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage of a database is managing data needed by multiple users simultaneously.

  Each process in a database instance performs a specific job. By dividing the work of the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance.

  * In previous releases, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces.

• Question 318:

  Which three statements are true about a job chain? (Choose three.)

  A. It can contain a nested chain of jobs.
  B. It can be used to implement dependency-based scheduling.
  C. It cannot invoke the same program or nested chain in multiple steps in the chain.
  D. It cannot have more than one dependency.
  E. It can be executed using event-based or time-based schedules.
  A. It can contain a nested chain of jobs.
  B. It can be used to implement dependency-based scheduling.
  E. It can be executed using event-based or time-based schedules.

• Question 319:

  You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.

  Identify three possible reasons for this.

  A. Missing or stale histogram statistics
  B. Undersized shared pool
  C. High clustering factor for the indexes
  D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
  E. Oversized buffer cache
  A. Missing or stale histogram statistics
  C. High clustering factor for the indexes
  D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

  ---

  D: DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you can use to minimize I/O during table scans. It specifies the maximum number of blocks read in one I/O operation during a sequential scan. The total number of I/Os needed to perform a full table scan depends on such factors as the size of the table, the multiblock read count, and whether parallel execution is being utilized for the operation.

• Question 320:

  DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.

  

  Which two are true? (Choose two.)

  A. 80% of every data block in daily_ords_list is reserved for row inserts
  B. 20% of each data block in the table is reserved for row updates
  C. PCTFREE can help to minimize row chaining during inserts
  D. PCTFREE can help reduce row migration during updates
  E. PCTFREE eliminates row chaining during inserts
  B. 20% of each data block in the table is reserved for row updates
  D. PCTFREE can help reduce row migration during updates