Oracle 1Z0-218認定試験に適する最高の問題集を捧げる

この情報の時代には、IT業界にとても注目され、この強い情報技術業界にIT人材が得難いです。こうしてOracle認定試験がとても重要になります。でも、この試験がとても難しくてIT者になりたい方が障害になっています。

Oracleの1Z0-218認定試験に受かりたいのなら、適切なトレーニングツールを選択する必要があります。Oracleの1Z0-218認定試験に関する研究資料が重要な一部です。我々Pass4TestはOracleの1Z0-218認定試験に対する効果的な資料を提供できます。Pass4TestのIT専門家は全員が実力と豊富な経験を持っているのですから、彼らが研究した材料は実際の試験問題と殆ど同じです。Pass4Testは特別に受験生に便宜を提供するためのサイトで、受験生が首尾よく試験に合格することを助けられます。

試験番号：1Z0-218問題集
試験科目：Oracle 「PeopleSoft HRMS Fundamentals」
一年間無料で問題集をアップデートするサービスを提供いたします
最近更新時間：2013-11-16
問題と解答：全106問

Oracleの1Z0-218認定試験に関連する知識を学んで自分のスキルを向上させ、1Z0-218認証資格を通して他人の認可を得たいですか。Oracleの認定試験はあなたが自分自身のレベルを高めることができます。1Z0-218認定試験の資格を取ったら、あなたがより良く仕事をすることができます。この試験が非常に困難ですが、実は試験の準備時に一生懸命である必要はありません。Pass4Testの1Z0-218問題集を利用してから、一回で試験に合格することができるだけでなく、試験に必要な技能を身につけることもできます。

Pass4TestのOracleの1Z0-218試験トレーニング資料が受験生の皆様の評判を取ったのはもう最近のことではないです。これはPass4TestのOracleの1Z0-218試験トレーニング資料は確かに信頼できて、受験生の皆様が首尾よく試験に合格することに助けを差し上げられることが証明されました。　Pass4TestのOracleの1Z0-218試験トレーニング資料がベストセラーになって、他のサイトをずっと先んじて皆様の認可を取りましたから、好評は言うまでもないです。　Oracleの1Z0-218認定試験を受けたら、速くPass4Testというサイトをクリックしてください。あなたがずっとほしいものを手に入れることができますから。最もプロな人々が注目しているIT専門家になりたかったら、後悔しないように速くショッピングカートを入れましょう。

Oracleの1Z0-218認定試験の合格証明書はあなたの仕事の上で更に一歩の昇進で生活条件が向上することが助けられます。Oracleの1Z0-218認定試験はIT専門知識のレベルの検査でPass4Testの専門IT専門家があなたのために最高で最も正確なOracleの1Z0-218試験資料が出来上がりました。Pass4Testは全面的な最高のOracle 1Z0-218試験の資料を含め、きっとあなたの最良の選択だと思います。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.pass4test.jp/1Z0-218.html

NO.1 On the Job Data Work Location tab for a new hire, Company is a required field.
You can default Company from the _____ table.
A. Location
B. Job Code
C. Position Data
D. Business Unit
E. Holiday Schedule
Answer: C

Oracle   1Z0-218認定試験   1Z0-218   1Z0-218

NO.2 After inputting a department in Job Data, which four additional fields could be populated based on the
defaults defined on the Department table? (Choose four.)
A. Location
B. Company
C. Paygroup
D. Tax Location
E. Business Unit
F. Supervisor ID
G. Establishment ID
Answer: ABDF

Oracle   1Z0-218過去問   1Z0-218   1Z0-218認定資格   1Z0-218認定試験   1Z0-218

NO.3 Which three fields default from the Department table to the employee job data level? (Choose three.)
A. Grade
B. Location
C. Company
D. Pay Group
E. Business Unit
F. Supervisor ID
G. Employee Type
Answer: BCF

Oracle   1Z0-218問題集   1Z0-218   1Z0-218

NO.4 Your client has North American Payroll and Global Payroll. When adding an employment instance for
a new hire, your client selects a payroll system to use for processing the employee's payroll. Depending
on which payroll system is selected, the input field names displayed would differ on the Payroll page
except for two field names.
Identify the two field names that are displayed on the Payroll page for both payroll systems. (Choose two.)
A. Paygroup
B. GL Pay Type
C. Eligibility Group
D. Employee Type
E. Holiday Schedule
F. Exchange Rate Type
Answer: AE

Oracle問題集   1Z0-218認定試験   1Z0-218   1Z0-218   1Z0-218

NO.5 Your client is implementing PeopleSoft HRMS system with Payroll Interface. The client is to start
configuring Pay Group table.
What table value should exist in the system before configuring Pay Groups?
A. Location
B. Company
C. Salary Plan
D. Salary Step
E. Salary Grade
F. Additional Pay
Answer: B

Oracle問題集   1Z0-218   1Z0-218参考書   1Z0-218

NO.6 Which three statements describe the benefits of using tableset sharing in the PeopleSoft system?
(Choose three.)
A. Tableset sharing uses SetID to restrict or grant access to data within a table.
B. Tableset sharing allows organizations to track and report business information.
C. Tableset sharing enables organizations to group rows of data within a control table by using a
high-level key called a SetID.
D. Tableset sharing uses Department ID in conjunction with department security tree to restrict or grant
access to data within a table.
E. Tableset sharing enables organizations to utilize indexing capabilities on mapped records for faster
search results on employee data.
F. Tableset sharing enables organizations to share information instead of entering it multiple times, when
large portions of data are the same for various business units.
Answer: ACF

Oracle   1Z0-218問題集   1Z0-218認証試験   1Z0-218   1Z0-218認定資格

NO.7 View the Exhibits.
Your client wants to set up a new department called ABC Headquarter for their newly acquired company
ABC. The client shares the department and location information cross all business units.
The HR Administrator has checked that the location code ABCHQ showed up under the Location Table
Search Result page under SetID "Share". However, when she tried to attach this location code to the new
department she is trying to create, she got the error message.
Which two setups may have caused the error message to be displayed? (Choose two.)
A. The Location SetID may not be valid for this department.
B. The Department may have an earlier Effective Date than the Location.
C. The Location and the Department may not belong to the same Business Unit.
D. The Location may have been inactivated before the Department's Effective Date.
E. The Location may not be associated with the proper company that the department is attached to.
F. The TableSet Control table may not be set up correctly for the Record_Group Location and the
Record_Group Department.
Answer: BD

Oracle   1Z0-218   1Z0-218   1Z0-218

NO.8 Your organization has decided to implement row-level security. You suggested securing data by
associating the company with people having jobs. This method of securing data is known as _____.
A. Access Type / Role
B. Permission List / Role
C. Security set / Access Type
D. Security set / Permission List
E. Permission List / User Profile
F. Access Type / Permission List
Answer: C

Oracle   1Z0-218認証試験   1Z0-218練習問題

NO.9 What should you do when system performance is affected and you no longer want to maintain all
employee records on the Job table?
A. Purge employee data from the system.
B. Use PeopleCode to hide data on the Job Data page.
C. Access the Job Data page in Correct History mode and change the status to Inactive.
D. Insert a new effective dated row on the Job Data page and change the status to Inactive.
E. Change the description field on the Job Data page to state that this row is no longer active.
Answer: A

Oracle参考書   1Z0-218認定証   1Z0-218   1Z0-218

NO.10 Your client is using PeopleSoft HCM 9.0. It wants to pay some of its existing Persons of Interest
(POIs).
Which page in PeopleSoft do they use to set up their POIs for payment?
A. Job Data
B. Other Payee
C. Modify a Person
D. Add a POI Relationship
E. Maintain a Person's POI Reltn
Answer: B

Oracle参考書   1Z0-218認証試験   1Z0-218   1Z0-218認証試験   1Z0-218練習問題   1Z0-218

NO.11 On the Add a Person page in PeopleSoft HCM 9.0, you can input all information about a person
EXCEPT for these four details: _____. (Choose four.)
A. Ethnic Group
B. Bank Account
C. Military Status
D. Badge Number
E. Smoker History
F. Emergency Contact
G. Driver License Number
Answer: BDFG

Oracle認定資格   1Z0-218   1Z0-218問題集

NO.12 Identify the three types of organizational relationships that PeopleSoft HCM 9.0 has. (Choose three.)
A. Trustee
B. Employee
C. Contractor
D. Board Member
E. Person of Interest
F. Contingent Worker
G. Global Payroll Employee
Answer: BEF

Oracle   1Z0-218参考書   1Z0-218参考書

NO.13 Using a Permission List associated with a user and identifying security sets and access types in the
Security by Permission List component of PeopleSoft are known as _____.
A. Role-based data permission security
B. Tree-based data permission security
C. Group-based data permission security
D. Country-based data permission security
E. PeopleCode-based data permission security
Answer: A

Oracle参考書   1Z0-218   1Z0-218

NO.14 Which default value do the Job Code table and Location table have in common?
A. Salary Plan
B. Work Period
C. Tax Location
D. Standard Hours
E. Establishment ID
Answer: A

Oracle認証試験   1Z0-218問題集   1Z0-218   1Z0-218参考書   1Z0-218問題集

NO.15 Which four components can be used to add a job instance for a person in PeopleSoft HCM 9.0?
(Choose four.)
A. Manage Hires
B. Modify a Person
C. Add Employment Instance
D. Add Person of Interest Job
E. Add Contingent Worker Instance
Answer: ACDE

Oracle認定証   1Z0-218   1Z0-218   1Z0-218問題集   1Z0-218

NO.16 You are at your client site working on PeopleSoft HRMS implementation. One of your tasks is to add
systemwide defaults in order to save time when a user is entering information in transaction tables.
Identify which field is NOT a default option in the Org Default by Permission List component.
A. SetID
B. Country
C. Company
D. To Currency
E. Business Unit
F. Compensation Frequency
Answer: F

Oracle   1Z0-218   1Z0-218過去問   1Z0-218

NO.17 Your organization has decided to use a department security tree for Row-Level security in PeopleSoft
HRMS system.
You decided to use the XYZ permission list to secure data using the Security by Department Tree
component.
Which step do you need to perform to ensure that Row-Level security is enforced?
A. Add the XYZ permission list to User Profile.
B. Add the XYZ permission list to Security Set.
C. Add the XYZ permission list to Tree Manager.
D. Add the XYZ permission list to Configuration Manager.
E. Add the XYZ permission list to a role and then assign that role to a user.
Answer: A

Oracle認定試験   1Z0-218問題集   1Z0-218認定証   1Z0-218   1Z0-218

NO.18 PeopleSoft HCM 9.0 has several pages where you can access the Add a Person component.
Identify four components that have an option to Add a Person. (Choose four.)
A. Job Data
B. Other Payee
C. Add a Person
D. Manage Hires
E. Modify a Person
F. Add Employment Instance
Answer: BCDE

Oracle認定試験   1Z0-218   1Z0-218認定試験   1Z0-218認証試験   1Z0-218

NO.19 Which PeopleSoft table do you use to identify a group of employees who share common pay
characteristics?
A. Job Code Table
B. Company Table
C. Pay Group Table
D. Salary Plan Table
E. Salary Grade Tables
F. Comp Rate Code Table
Answer: C

Oracle   1Z0-218問題集   1Z0-218   1Z0-218

NO.20 Adam is entering new hire information in the PeopleSoft system. Adam enters the new hire personal
information and creates the organizational relationship of the new hire as EMPLOYEE. After Adam
establishes the new hire's relationship with the organization, the system opens the JOB DATA page for
Adam to enter the new hires job-related information.
Adam decides to complete the new hires job-related information after his lunch break and cancels out of
the JOB DATA page.
What must be Adam's approach to successfully complete the new hire's job-related information in the
PeopleSoft system after his break?
A. Enter job-related information using Job Data component.
B. Complete both personal information and job information at the same time.
C. Enter job-related information using the Add Employment Instance component.
D. Run SJT refresh process first and then enter job-related information using Job Data component.
E. Run SJT refresh process first and then enter job-related information using the Add Employment
Instance component.
Answer: C

Oracle認定証   1Z0-218   1Z0-218   1Z0-218認定資格

Pass4Testは最新のNS0-156試験問題集と高品質のE20-555認定試験の問題と回答を提供します。Pass4TestのHP5-K01D VCEテストエンジンと00M-663試験ガイドはあなたが一回で試験に合格するのを助けることができます。高品質の70-323トレーニング教材は、あなたがより迅速かつ簡単に試験に合格することを100％保証します。試験に合格して認証資格を取るのはそのような簡単なことです。

記事のリンク：http://www.pass4test.jp/1Z0-218.html

Oracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054の試験問題集が登場します

現在のネットワークの全盛期で、Oracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054の認証試験を準備するのにいろいろな方法があります。Pass4Testが提供した最も依頼できるトレーニングの問題と解答はあなたが気楽にOracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054の認証試験を受かることに助けを差し上げます。Pass4TestにOracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054の試験に関する問題はいくつかの種類がありますから、すべてのIT認証試験の要求を満たすことができます。

IT業界の中でたくさんの野心的な専門家がいって、IT業界の中でより一層頂上まで一歩更に近く立ちたくてOracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054試験に参加して認可を得たくて、Oracle の1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054試験が難度の高いので合格率も比較的低いです。Pass4Testの商品は試験問題を広くカーバして、認証試験の受験生が便利を提供し、しかも正確率100%です。そして、試験を安心に参加してください。

試験番号：1Z0-403問題集

試験科目：Oracle 「Enterprise Linux System Administration」

試験番号：1Z0-218問題集

試験科目：Oracle 「PeopleSoft HRMS Fundamentals」

試験番号：1Z0-041問題集

試験科目：Oracle 「Oracle Database 10g: DBA Assessment 」

試験番号：1Z0-023問題集

試験科目：Oracle 「Architecture and Administration」

試験番号：1Z0-054問題集

試験科目：Oracle 「Oracle Database 11g: Performance Tuning」

Pass4TestはもっぱらITプロ認証試験に関する知識を提供するのサイトで、ほかのサイト使った人はPass4Testが最高の知識源サイトと比較しますた。Pass4Testの商品はとても頼もしい試験の練習問題と解答は非常に正確でございます。

Oracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054試験に受かることは確かにあなたのキャリアに明るい未来を与えられます。Oracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054試験に受かったら、あなたの技能を検証できるだけでなく、あなたが専門的な豊富の知識を持っていることも証明します。Pass4TestのOracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054試験トレーニング資料は実践の検証に合格したソフトで、手に入れたらあなたに最も向いているものを持つようになります。 Pass4TestのOracleの1Z0-403 1Z0-218 1Z0-041 1Z0-023 1Z0-054試験トレーニング資料を購入する前に、無料な試用版を利用することができます。そうしたら資料の高品質を知ることができ、一番良いものを選んだということも分かります。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.pass4test.jp/1Z0-054.html

NO.1 A user in a session executed the following SQL statement to set the optimizer mode:
ALTER SESSION SET OPTIMIZER_MODE = ALL_ROWS
What impact would it have on the goal of the optimizer for that session? (Choose all that apply.)
A. Statement level OPTIMIZER_MODE hints take precedence over the session-level setting.
B. The OPTIMIZER_MODE parameter set at instance level takes precedence over the session-level
value.
C. The optimizer uses a cost-based approach, regardless of the presence of statistics; it optimizes with a
goal of best response time.
D. The optimizer uses a cost-based approach for all SQL statements in the session, regardless of the
presence of statistics; it optimizes with a goal of best throughput.
ANSWER: AD

Oracle   1Z0-054認証試験   1Z0-054認定試験   1Z0-054

NO.2 Examine the initialization parameter values for the instance given below:
NAME TYPE VALUE
------------------------------------ ----------- ------------------
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 11.1.0.6
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
db_file_multiblock_read_count integer 64
You notice that the one of the queries is using a full table scan (view Exhibit1) instead of index unique
scan (view Exhibit2). The index is present on the column that is accessed in the WHERE clause of the
query. The cost for a full table scan is more than that for an index unique scan.
Why would the optimizer choose full table scan over index unique scan? (Choose all that apply.)
A. The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to a low value.
B. The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to a high value.
C. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a low value.
D. The statistics for the table and all the indexes associated with the table are not current.
ANSWER: BD

Oracle練習問題   1Z0-054認定証   1Z0-054   1Z0-054   1Z0-054

NO.3 You are working on a decision support system (DSS). The index is available on the COUNTRY_ID
column of the CUSTOMERS table.
View the Exhibit and examine the parameter settings and the query execution plan.
Why is the query using a full table scan instead of an index scan?
A. because the histogram statistics for the COUNTRY_ID column are not updated
B. because the index statistics for the index on the COUNTRY_ID column are not current
C. because the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a higher value
D. because the optimizer predicts that most of the blocks in the table are accessed. Therefore, it uses a
full table scan, even though indexes are available.
ANSWER: D

Oracle   1Z0-054練習問題   1Z0-054   1Z0-054問題集

NO.4 View the Exhibit exhibit1 to examine the series of SQL commands and parameter settings.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline.
The first plan (in red) is created when OPTIMIZER_MODE is set to ALL_ROWS and the second plan (in
blue) is created when OPTIMIZER_MODE is set to FIRST_ROWS.
Which SQL plan baseline would be used if the SQL query in exhibit1 is executed again when the value of
OPTIMIZER_MODE is set to FIRST_ROWS?
A. the second plan, because it is a fixed plan
B. the first plan, because it is an accepted plan
C. the second plan, because it is the latest generated plan in FIRST_ROW mode
D. A new plan, because the second plan in FIRST_ROW mode is not an accepted plan
ANSWER: B

Oracle   1Z0-054認定資格   1Z0-054   1Z0-054   1Z0-054

NO.5 You work as a DBA for a company and you have the responsibility of managing one of its online
transaction processing (OLTP) systems. The database encountered performance-related problems and
you generated an Automatic Workload Repository (AWR) report to investigate it further.
View the Exhibits and examine the AWR report.
What could be the problem in this database?
A.Java pool is not configured.
B.The CPU in the system is slow.
C.The shared pool size is inadequate.
D.The database buffer cache is inadequate.
E.The OPEN_CURSORS parameter is set to a small value.
ANSWER: C

Oracle   1Z0-054   1Z0-054

NO.6 View the Exhibit and examine a portion of the output obtained from the following query:
SQL> SELECT * FROM v$sys_time_model;
Select three correct interpretations of the time model statistics. (Choose three.)
A. DB time includes the wait time of all the nonidle and idle user sessions.
B. SQL execute elapsed time includes the time spent in performing fetches of query results.
C. DB CPU includes the CPU time spent on database user-level calls and background CPU time.
D. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.
E. DB time includes the connection management call elapsed time excluding the background process
time.
ANSWER: BDE

Oracle問題集   1Z0-054   1Z0-054過去問

NO.7 The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID are frequently used
together in the WHERE clause of the queries. The CUSTOMERS table is a big table with 20 GB of data.
You notice that the selectivity for these three columns varies from the selectivity that the optimizer
calculates.
What would you recommend to influence the selectivity calculated by the optimizer?
A. creating function-based indexes by concatenating all the columns
B. updating histogram statistics for these columns by using the DBMS_STATS.GATHER_TABLE_STATS
procedure
C. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and create
index on the virtual column
D. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and the
DBMS_STATS.GATHER_TABLE_STATS procedure to collect statistics on the virtual column
ANSWER: D

Oracle   1Z0-054   1Z0-054認定証   1Z0-054問題集

NO.8 You are working on an online transaction processing (OLTP) system. By day most of the application
users perform queries accessing the most recently added or modified rows. The applications have most
of the queries based on multiple tables. But at night, some batch processing is also done.
Which two actions would you recommend to choose a goal for the optimizer based on the needs of your
application? (Choose two.)
A.setting the OPTIMIZER_MODE parameter to ALL_ROWS at the instance level
B.setting the OPTIMIZER_MODE parameter to FIRST_ROWS_n at the instance level
C.asking the developer to add a hint /*ALL_ROWS*/ in the long-running batch processing queries
D.asking the developer to add a hint /*FIRST_ROWS_n*/ in the long-running batch processing queries
ANSWER: BC

Oracle過去問   1Z0-054   1Z0-054認証試験   1Z0-054認証試験

NO.9 Examine the initialization parameter values for the instance given below:
NAME TYPE VALUE
------------------------------------ ----------- ------------------
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 11.1.0.6
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
db_file_multiblock_read_count integer 64
The index created on the column used in the WHERE clause of the query. You notice that the query is not
using the index. Instead of an index scan, a full table scan is used.
View the Exhibit and examine the autotrace output for a query.
What could be the reason for it? (Choose all that apply.)
A. The OPTIMIZER_INDEX_COST_ADJ initialization parameter has a low value.
B. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter has a low value.
C. The statistics for the table and all the indexes associated with the table are not current.
D. The table has less than DB_FILE_MULTIBLOCK_READ_COUNT blocks under the high-water mark.
ANSWER: CD

Oracle   1Z0-054練習問題   1Z0-054認定資格

NO.10 A batch workload that historically completed in the maintenance window between 10:00 PM and
midnight is currently showing poor performance and completing at 2 AM.
To help in the diagnosis of the performance degradation, the senior DBA in your organization asks you to
execute the awrddrpt.sql script to produce a Compare Periods report.
Which two statements are true about the report produced by this script? (Choose two.)
A. It is refreshed automatically based on the moving window baseline.
B. It compares details between any two selected time periods of the same duration.
C. It normalizes the statistics by the amount of time spent on the database for each time period.
D. It compares details between two consecutive time periods of the same or different durations and is
refreshed every 60 minutes.
ANSWER: BC

Oracle認定証   1Z0-054   1Z0-054練習問題   1Z0-054認定証   1Z0-054

NO.11 You are working on a development database that was upgraded to Oracle Database 11g from Oracle
Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown
in the Exhibit.
You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. You
tried to resize this by shrinking the database buffer cache but that caused inadequate buffer cache
problems. The following are the related parameter settings:
SQL> show parameter sga
NAME TYPE VALUE
------------------------------ --------------- -----------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 0
SQL> show parameter target
NAME TYPE VALUE
------------------------------ --------------- -----------------
.....
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 100M
sga_target big integer 0
You want to balance the memory between the System Global Area (SGA) components within SGA
without affecting the size of the Program Global Area (PGA).
Which action would solve this problem?
A. Set the SGA_TARGET parameter to 300M.
B. Set the SGA_MAX_SIZE parameter to 400M.
C. Set the MEMORY_TARGET parameter to 100M.
D. Set the MEMORY_MAX_TARGET parameter to 300M.
ANSWER: A

Oracle練習問題   1Z0-054   1Z0-054   1Z0-054

NO.12 After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the
SPA output. Identify the two actions that you would suggest for these regressed SQL statements.
(Choose two.)
A.Running SQL Access Advisor
B.Adding them to SQL Plan Baseline
C.Submitting them to SQL Tuning Advisor
D.Running Automatic Database Diagnostic Monitor (ADDM)
ANSWER: BC

Oracle   1Z0-054   1Z0-054過去問   1Z0-054認証試験

NO.13 View Exhibit1 to examine the description of the CUSTOMERS table.
The CUSTOMERS table has been updated heavily today. In a frequently used SQL statement, you notice
that estimated rows and the actual number of rows fetched differ greatly. The COUNTRY_ID column has
an index.
View Exhibit2 and examine the query execution plan.
What would you recommend to improve the optimizer's estimation?
A. setting the STATISTICS_LEVEL parameter to ALL
B. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE
C. creating extended statistics for the CUST_LAST_NAME, CUST_ID, and CUST_TOTAL columns
D. updating the statistics for the CUSTOMERS table by using the
DBMS_STATS.GATHER_TABLE_STATS
procedure
ANSWER: D

Oracle認定試験   1Z0-054   1Z0-054参考書

NO.14 View Exhibit1 and examine the indexes on the CUSTOMERS table.
The statistics for the CUSTOMERS table have been updated recently by using the following command:
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('SH','CUSTOMERS',method_opt=>'FOR ALL
INDEXED COLUMNS SIZE AUTO');
View Exhibit2 to examine a query plan. Even though the index is present on the COUNTRY_ID and
CUST_GENDER columns, the query uses a full table scan. What could be the reason?
A. because the histogram statistics for the COUNTRY_ID column are not updated
B. because the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a high value
C. because the optimizer calculates the cost of accessing blocks by using a full table scan to be less as
compared to index scans, even though indexes are available
D. because indexes on CUST_GENDER and COUNTRY_ID columns are of different types, the index on
the CUST_GENDER column is bitmap index, and on COUNTRY_ID columns is btree index.
ANSWER: C

Oracle参考書   1Z0-054   1Z0-054   1Z0-054認定証   1Z0-054

NO.15 You are working on an online transaction processing (OLTP) system. You detected free buffer waits
events for your database instance running in a machine that has multiple CPUs. You increased the
database buffer cache size as the first step. After a few hours of work on the database, further
investigation shows that the same event is being recorded.
What would be your next step to avoid this event in future?
A. Decrease the value of the DBWR_IO_SLAVES parameter.
B. Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.
C. Increase the value of the DB_WRITER_PROCESSES parameter.
D. Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
ANSWER: C

Oracle問題集   1Z0-054認証試験   1Z0-054

NO.16 Which three factors influence the optimizer's behavior while choosing an optimization approach and
goal for a SQL statement? (Choose three.)
A.parsing of a SQL statement
B.operating system (OS) statistics
C.object statistics in the data dictionary
D.the OPTIMIZER_MODE initialization parameter
E.optimizer SQL hints for changing the query optimizer goal
ANSWER: CDE

Oracle認定試験   1Z0-054   1Z0-054

NO.17 Identify two correct statements about the Active Session History (ASH) data. (Choose two.)
A.A part of SGA memory is used to store ASH data as rolling buffer.
B.The ASH data can be analyzed between any two small time intervals.
C.All ASH data in memory are flushed to disk by MMON in every 3 seconds.
D.All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.
ANSWER: AB

Oracle   1Z0-054過去問   1Z0-054   1Z0-054認証試験   1Z0-054   1Z0-054

NO.18 View Exhibit1 to examine the description of the CUSTOMERS table.
You observed that optimizer selectivity is not accurate when the CUST_STATE_PROVINCE and
COUNTRY_ID columns are used together in the WHERE clause of a query.
View Exhibit2 to examine the query execution plan and the commands executed to gather the statistics.
The optimizer predicts that 20 rows will be processed rather than the 3,341 rows, which is the actual
number of rows returned from the table.
What can you do to make the optimizer detect the actual number of rows?
A. Set the STATISTICS_LEVEL parameter to ALL.
B. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
C. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns.
D. Increase the STALE_PERCENT value for the CUSTOMERS table by using the
DBMS_STATS.SET_TABLE_PREFS procedure.
ANSWER: C

Oracle認定資格   1Z0-054   1Z0-054   1Z0-054認証試験   1Z0-054

NO.19 You plan to use adaptive thresholds as part of the performance tuning activity. You decide to increase
the window size of the default moving window baseline for all metric observations and comparisons in
your database. The following error occurs when you try to increase the window size through Enterprise
Manager:
Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than retention
(1036800) ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 601 ORA-06512: at line 2
Which action would allow you to perform the preceding task successfully?
A. increasing the flashback retention period
B. increasing the retention period for SQL Management Base
C. increasing the undo retention period for the database instance
D. increasing the Automatic Workload Repository (AWR) retention period
ANSWER: D

Oracle   1Z0-054   1Z0-054認定証   1Z0-054

NO.20 You observed that some of the queries are performing poorly on the SALES_RECORDS table in your
database.
On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table
are transferred to the SALES table and deleted from the SALES_RECORDS table. The deleted
operations cause the table to be sparsely populated.
You decided to use the ALTER TABLE...SHRINK SPACE COMPACT command to shrink the table.
Why would you choose this method? (Choose all that apply.)
A. because it can be used during peak hours
B. because it avoids unnecessary cursor invalidation
C. because it adjusts the high-water mark (HWM) immediately
D. because you have long-running queries that might span the shrink operation
E. because it does not allow any data manipulation language (DML) operations, thereby making the
shrink
operation faster
ANSWER: ABD

Oracle   1Z0-054認定証   1Z0-054   1Z0-054参考書