Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 421:

  You have applications that have frequently executed queries, and produce small and static result sets. You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.

  What is the purpose of this configuration?

  A. to avoid round trips to the server by enabling caching of query results in client memory

  B. to improve performance by storing a copy of the data from the private SQL area of the PGA

  C. to enhance the query performance by creating a cache in the client memory for sorting operations

  D. to avoid the storing of query plans and results in the server by creating a cache in the client memory

  Correct Answer: A

• Question 422:

  Evaluate the following function code:

  

  Which statement is true regarding the above function?

  A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

  B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.

  C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.

  D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.

  Correct Answer: A

• Question 423:

  Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

  A. set SHARED_POOL_SIZE to zero

  B. set STATISTICS_LEVEL to BASIC

  C. set SGA_TARGET to a non-zero value

  D. set DB_CACHE_SIZE to a non-zero value

  E. set STATISTICS_LEVEL to TYPICAL or ALL

  Correct Answer: AC

• Question 424:

  View the Exhibit.

  As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals.

  Which background process performs this activity?

  

  A. CKPT

  B. SMON

  C. MMON

  D. DBWR

  Correct Answer: C

• Question 425:

  In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command:

  SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales GROUP BY sale_category;

  Where would the result of this query be stored?

  A. database buffer cache

  B. shared pool

  C. PGA

  D. large pool

  Correct Answer: B

• Question 426:

  Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)

  A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero

  B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set

  C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.

  D. MEMORY_TARGET is static and cannot be modified without shutting down the instance

  Correct Answer: ABC

• Question 427:

  Observe the structure of the table employees: The table contains 8475 records.

  

  One of the employees wants to know the names of all employees of the company. For this, he fires the following query:

  SELECT * FROM EMPLOYEES ORDER BY emp_fname;

  Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.

  Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?

  A. Rollback segment

  B. Temporary segment

  C. Data segment

  D. Index segment

  Correct Answer: B

• Question 428:

  View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone 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. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

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

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

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

  Correct Answer: D

• Question 429:

  View the Exhibit to examine the replay settings for replay parameters.

  What is the implication for setting the values for replay parameters? (Choose all that apply.)

  Exhibit:

  

  A. The COMMIT order in the captured workload is preserved during replay.

  B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

  E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

  Correct Answer: ACD

• Question 430:

  Which two client requests are captured during database replay Capture? (Choose two)

  A. Flashback queries

  B. Shared server requests

  C. Login and logoff activities of sessions

  D. Direct path load of data from external files by using utilities such as SQL *loader

  E. Data definition language (DDL) and data manipulation language (DML) operations

  Correct Answer: CE

  9.3 Workload Capture Restrictions

  Certain types of user sessions and client requests may sometimes be captured in a workload, but they are not supported by Database Replay. Capturing these session and request types in a workload may result in errors during workload replay. The following types of user sessions and client requests are not supported by Database Replay:

  Direct path load of data from external files using utilities such as SQL*Loader Non-PL/SQL based Advanced Queuing (AQ) Flashback queries Oracle Call Interface (OCI) based object navigations Non SQL-based object access Distributed transactions, Any distributed transactions that are captured will be replayed as local transactions. XA transactions, XA transactions are not captured or replayed. All local transactions are captured. JAVA_XA transactions, If the workload uses the JAVA_XA package, JAVA_XA function and procedure calls are captured as normal PL/SQL workload. To avoid problems during workload replay, consider dropping the JAVA_XA package on the replay system to enable the replay to complete successfully.

  Database Resident Connection Pooling (DRCP) Workloads using OUT binds Multi-threaded Server (MTS) and shared server sessions with synchronization mode set to OBJECT_ID Migrated sessions, The workload is captured for migrated sessions. However, user logins or session migration operations are not captured. Without a valid user login or session migration, the replay may cause errors because the workload may be replayed by a wrong user.

  Typically, Database Replay refrains from capturing these types of non-supported user sessions and client requests. Even when they are captured, Database Replay will not replay them. Therefore, it is usually not necessary to manually filter out non-supported user sessions and client requests. In cases where they are captured and found to cause errors during replay, consider using workload capture filters to exclude them from the workload.