最新なOracle 1Z0-117問題集（125題）、真実試験の問題を全部にカバー！

質問 1：
Which two tasks are performed during the optimization stage of a SQL statement?
A. Evaluating the expressions and conditions in the query
B. Checking the syntax and analyzing the semantics of the statement
C. Inspecting the integrity constraints and optimizing the query based on this metadata
D. Gathering the statistics before creating the execution plan for the statement
E. Separating the clauses of the SQL statement into structures that can be processed
正解：C,D
解説: (Pass4Test メンバーにのみ表示されます)

質問 2：
Which are the two prerequisites for enabling star transformation on queries?
A. A bitmap index must exist on all the columns that are used in the filter predicates of the query.
B. The STAR_TRANSFORMATION_ENABLED parameter should be set to TRUE or TEMP_DISABLE.
C. A B-tree index should be built on each of the foreign key columns of the fact table(s),
D. A bitmap index should be built on each of the primary key columns of the fact table(s).
E. A bitmap index should be built on each of the foreign key columns of the fact table(s).
正解：A,B
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
Examine the Exhibit. Given two sets of parallel execution processes, SS1 and SS2, which is true?

A. Each process in SS1 reads all the rows from the CUSTOMERS table and distributes the rows evenly among the processes in SS2.
B. Each process in the SS1 reads some of the rows from the CUSTOMERS table and distributes the rows evenly among the processes in SS2.
C. Each process in SS1 reads some of the rows from the SALES table and sends all the rows it reads to each process in SS2.
D. Each process SS1 reads some of the rows from the CUSTOMERS table and sends all the rows it reads to each process in SS2.
E. Each process in SS1 reads all the rows from the SALES table and distributes the rows evenly among the processes in SS2.
F. Each process in SS1 reads some of the rows from the SALES table and distributes the rows evenly among the processes in SS2.
正解：E
解説: (Pass4Test メンバーにのみ表示されます)

質問 4：
Which statement is true about an automatic SQL task?
A. It will tune all the top SQL statements from AWR irrespective of the time it takes to complete the task in a maintenance window.
B. It will attempt to tune all-long-running queries that have existing SQL profiles.
C. It will automatically implement new SQL profiles for the statements that have existing SQL profiles.
D. It will attempt to tune the currently running SQL statements that are highly resource intensive.
E. It will automatically implement SQL profiles if a three-fold benefit can be achieved and automatic profile implementation is enabled.
正解：E
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
Examine Exhibit 1 to view the query and its execution plan.

Examine Exhibit 2 to view the structure and indexes for the EMPLOYEES and DEPARTMENTS tables.

Examine Exhibit 3 to view the initialization parameters for the instance.

Why is sort-merge join chosen as the access method?
A. Because the OPTIMIZER_MODE parameter is set to ALL_ROWS.
B. Because of an inequality condition.
C. Because the data is not sorted in the LAST_NAME column of the EMPLOYEES table
D. Because of the LIKE operator used in the query to filter out records
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：
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 merges files pertaining to a user session scattered across different processes in a shared server configuration.
C. It produces multiple files only for DBA sessions, which can be consolidated into one formatted file using the tkprof utility.
D. It merges multiple trace files and produces a formatted output file.
E. It produces multiple files for a service, which can be consolidated into one formatted file using the tkprof utility.
正解：A,D
解説: (Pass4Test メンバーにのみ表示されます)

質問 7：
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 resource intensive in terms of CPU, I/O and temporary space. You created a SQL Tuning Set (STS) containing all resource-intensive SQL statements. You want to analyze the entire workload captured in the STS. You plan to run the STS through the SQL Advisor.
Which two recommendations can you get?
A. Creating invisible indexes for the workload
B. Implementing SQL profiles for the statements
C. Dropping unused or invalid index.
D. Creating composite indexes for the workload
E. Syntactic and semantic restructuring of SQL statements
F. Combing similar indexes into a single index
正解：D,E
解説: (Pass4Test メンバーにのみ表示されます)