1Z0-117 무료 덤프문제 온라인 액세스

Examine the statements being executed for the first time:

Steps followed by a SQL statement during parsing:
1.Search for a similar statement in the shared pool.
2.Search for an identical statement in the shared pool.
3.Search the SQL area of identical statement already in the shared pool.
4.Proceed through the remaining steps of the parse phase to ensure that the execution plan of the existing statements is applicable to the view statement.
5.Perform hard parsing.
6.Share the SQL area of the similar statement already in the shared pool.
Identify the required steps in the correct sequence used by the third query.

• A.2, 5
• B.5, 2, 3, 4
• C.5, 1, 3, 4
• D.2, 4, 3
• E.1, 4, 3
• F.Only 5

Which two statements are true about the trcsess utility?

• A.It merges multiple trace files from a particular session into one single trace file.
• B.It produces multiple files for a service, which can be consolidated into one formatted file using the tkprof utility.
• C.It merges files pertaining to a user session scattered across different processes in a shared server configuration.
• D.It produces multiple files only for DBA sessions, which can be consolidated into one formatted file using the tkprof utility.
• E.It merges multiple trace files and produces a formatted output file.

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_PERCENT', '9');
What will be the effect of executing this procedure?

• A.It will influence the gathering of statistics for a table based on the value specified for ESTIMATE_PERCENT provided on table preferences for the same table exist.
• B.New objects created will use global preference even if table preferences are specified.
• C.It will influence dynamic sampling for a query to estimate the statistics based on ESTIMATE_PERCENT.
• D.The automatic statistics gathering job running in the maintenance window will use global preferences unless table preferences for the same table exist.

You want to run SQL Tuning Advisor statements that are not captured by ADDM, AWR, and are not in the library cache.
What is the prerequisite?

• A.Gather statistics for objects used in the application
• B.Create a SQL plan baseline for each query
• C.Enable SQL plan management
• D.Create a SQL Tuning Set (STS) containing the SQL statements

How can you reduce fragmentation of an index without affecting the current transactions that are using the index?

• A.Use the ANALYZE INDEX . . . command
• B.Use the ALTER INDEX . . . DEALLOCATE UNUSED command
• C.Use the ALTER INDEX . . . VALIDATE STRUCTURE command
• D.Us the ALTER INDEX . . . REBUILD ONLINE command