1Z0-117 Exam Questions

An application accessing your database got the following error in response to SQL query: ORA-12827: insufficient parallel query slaves available View the parallel parameters for yo...

Examine the Exhibit 1 to view the structure of and indexes for EMPLOYEES and DEPARTMENTS tables. Which three statements are true regarding the execution plan?

In Your Database, The Cursor_Shareing Parameter is set to EXACT. In the Employees table, the data is significantly skewed in the DEPTNO column. The value 10 is found in 97% of rows...

You created a SQL Tuning Set (STS) containing resource-intensive SQL statements. You plan to run the SQL Tuning Advisor. Which two types of recommendations can be provided by the S...

When would bind peeking be done for queries that vary only in values used in the WHERE clause?

Which type of SQL statement would be selected for tuning by the automatic SQL framework?

You are administering a database supporting an OLTP workload. A new module was added to one of the applications recently in which you notice that the SQL statements are highly reso...

A new application module is deployed on middle tier and is connecting to your database. You want to monitor the performance of the SQL statements generated from the application. To...

One of your databases supports a mixed workload. When monitoring SQL performance, you detect many direct paths reads full table scans. What are the two possible causes?

Examine the Exhibit. Which two options are true about the execution plan and the set of statements?

What are three common reasons for SQL statements to perform poorly?

Examine the utilization parameters for an instance: You notice that despite having an index on the column used in the where clause, queries use full table scans with highly selecti...

Tracing has been enabled for the HR user. You execute the following command to check the contents of the orcl_25052.trc trace file, which was generated during tracing: Which two st...

You are administering a database that supports an OLTP application. To set statistics preferences, you issued the following command: SQL > DBMS_STATS.SET_GLOBAL_PREFS (`ESTIMATE_PE...

View the Exhibit1 and examine the structure and indexes for the MYSALES table. The application uses the MYSALES table to insert sales record. But this table is also extensively use...

You are administering database that supports an OLTP workloads. Most of the queries use an index range scan or index unique scan as access methods. Which three scenarios can preven...

You are logged in as the HR user and you execute the following procedure: SQL > exec DBMS_STATS.SET_TABLE_PREFS (`HR', `EMPLOYEES', `PUBLISH', `FALSE'); SQL> exec DBMS_STATS.GATHER...

You enable auto degree of parallelism (DOP) for your database instance. Examine the following query: Which two are true about the execution of statement?

Examine the exhibit. Which is true based on the information obtainable from the execution plan?

Examine the exhibit to view the query and its execution plan? What two statements are true?

A database supports three applications: CRM, ERP, and ACC. These applications connect to the database by using three different services: CRM_SRV for the CRM application, ERP_SRV fo...

Examine the following anonymous PL/SQL code block of code: Which two are true concerning the use of this code?

Examine the parallelism parameter for your instance: parallel_servers_target Now examine the resource plan containing parallel statement directives: Consumer Group resource plan co...

You notice some performance degradation for a high-load SQL statement in your database. After investigations, you run the SQL Tuning Advisor, which recommends a SQL Profile. You ac...