1z0-050 | The Regenerate Guide To 1z0-050 dumps
Q71. 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
Answer: A
Q72. What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?
A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves performance by reading from a copy of an extent closest to the node.
Answer: D
Q73. View the Exhibit to examine the metrics with a threshold.
Which statement is true regarding the Number of Transactions (per second) metric?
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.
B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.
C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.
D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.
Answer: A
Q74. In which two cases would you perform only consistent backup? (Choose two.)
A. You are working on a database where downtime is not tolerated.
B. You are working on a database where downtime can be tolerated.
C. You are working on a database that operates in ARCHIVELOG mode.
D. You are working on a database that operates in NOARCHIVELOG mode.
E. You are working on a database where all the tablespaces are locally managed.
F. You are working on a database where control files and redo log files are multiplexed.
G. You are working on a database where control files and redo log files are not multiplexed.
Answer: BD
Q75. Evaluate the following code:
SQL>VARIABLE task_name VARCHAR2(255);
SQL>VARIABLE sql_stmt VARCHAR2(4000);
SQL>BEGIN
:sql_stmt := 'SELECT COUNT(*) FROM customers
WHERE cust_state_province =''CA'''
:task_name := 'MY_QUICKTUNE_TASK'
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, :task_name, :sql_stmt);
END;
What is the outcome of this block of code?
A. It creates a task and workload, and executes the task.
B. It creates a task and workload but does not execute the task.
C. It produces an error because a template has not been created.
D. It produces an error because the SQL Tuning Set has not been created.
Answer: A
Q76. While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.
Which two statements describe the consequences? (Choose two.)
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
Answer: AC
Q77. Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)
A. Supplemental log must be enabled.
B. Supplemental log must be enabled for the primary key.
C. Undo retention guarantee for the database must be configured.
D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
Answer: ABD
Q78. View the Exhibit that sets the threshold for the Current Open Cursors Count metric.
Why is the Significance Level threshold type not available in the threshold setting?
A. because AWR baseline is not enabled
B. because Current Open Cursors Count is not a basic metric
C. because the STATISTICS_LEVEL parameter is set to BASIC
D. because the AWR baseline is a system-defined moving window baseline
Answer: B
Q79. You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB. You want to create the same directory structure for duplicate database files as of the target database.
You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/sys@APPPROD
RMAN> CONNECT AUXILIARY sys/sys@DUPDB
RMAN> DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPILE
NOFILENAMECHECK;
What are the implications of this command?
A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
Answer: B
Q80. You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tape drives of only 10 GB each.
Which method would accomplish the task quickly and efficiently?
A. intrafile parallel backup
B. parallel image copy backup
C. backup with MAXPIECESIZE configured for the channel
D. parallel backup with MAXPIECESIZE configured for the channel
Answer: A