Oracle Database 11g: Administrator I : 1z1-052 Exam
killtestは1Z1-052試験問題集 の最新版を提供し、1Z1-052は100%の本格的な試験問題集は過去の試験問題及び最新模擬試験問題から作られたもので、全試験科目は常時最新化され、最新の試験内容まで織込む精確性が保証できます。killtestが開発した模擬試験ソフトは同じタイプの製品の中ではずば抜けており、広範囲の受験生の方が受験前に自己能力を把握できる一番有効な手段です。実は、これらの模擬試験問題は実際の試験問題よりずっと難しいです。killtest の製品をご利用いただくと、受験の自信を向上させることが出来ます。また、killtestは無償1Z1-052サンプル品を用意しておりますので、お買い上げの前に、無償でダウンロードできます。

11g
1Z1-052

1. View the Exhibit and examine the attributes of an undo tablespace.
In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour
that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the
following error:
ORA-01555: snapshot too old
What could be the reason for this error?
A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace
Answer: A
2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
A.All AWR tables belong to the SYSTEM schema.
B.The AWR contains systemwide tracing and logging information.
C.The snapshots collected by the AWR are accessible through data dictionary views.
D.The snapshots collected by the AWR are used by self-tuning components in the database.
Answer: CD
3. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in
poor database performance. Which option would you use to reduce fragmentation without affecting the
users who are currently using the index?
A.Validate the index structure using the ANALYZE...INDEX command.
B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.
C.Change the block space utilization parameters using the ALTER INDEX command.
D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.

Answer: B
4. Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of
backups that can be performed on the database?
A.You can perform online whole database backups.
B.You can perform offline whole database backups.
C.You cannot perform schema-level export/import operations.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.
Answer: B


Oracle 育成訓練、認証は開発と管理二つの種類があります、ここで開発だけ紹介いたします
開発認証試験は全部で三つの試験があります、試験番号1Z0-211テスト 、killtest実践試験の11i 1Z0-211は最も標準的な技術を正確的に書き入れ、認証した専門家と作者の出版した新製品だけを使います。
一発で成功することを保証します。11i 1Z0-211仕入れのご費用を全額返して、そして無料で同価値の製品を郵送します。

1Z0-211

1.Which two statements would be true when helping a customer make implementation decisions
for General Ledger? (Choose two)
A.Integration issues can be minimized.
B.Cost of upgrades would not be affected.
C.Patching cannot be done on a customized implementation.
D.Training can be standardized when Oracle is implemented without customization.
E.All Oracle subledger journals go directly to General Ledger to overcome interface problems.
Correct:A D
2.Revenue accounts can be viewed only by the head of the Finance team, who has a GL Superuser
responsibility. She has successfully created a standard Profit and Loss statement for the
company. Another member of the department with a General Ledger Supervisor responsibility has
been asked to run the standard Profit and Loss statement for Feb-06. The report shows only the
expenses accounts. Which two steps should she perform so that the Profit and Loss statement
will run successfully? (Choose two.)
A.Recreate the Profit and Loss under her own responsibility.
B.Ask to have security removed from her responsibility.
C.Perform an on-line inquiry to get the revenue balances.
D.Ask to have the profile option FSG: Enforce Segment Value Security changed to No.
Correct:B D
3.In creating a report, what is true about the column set? (Choose two.)
A.Formats can be set for each column.
B.Accounts cannot be assigned to a column set.
C.Calculations can be performed using columns.
D.Seeded column sets provided by Oracle must be used.
Correct:A C
4.Select the two minimum set up steps for intercompany accounting. (Choose two.)
A.Define a clearing company for all many-to-many intercompany journals.
B.Include an Intercompany segment in the chart of accounts structure.
C.Enable the Intercompany Qualifier for the Intercompany segment.
D.Enable Balance Intercompany Journal when defining the set of books.
E.Set up intercompany accounts for every journal source and journal category for intercompany
transactions.
F.Set up intercompany accounts for journal source and journal category of Other.
G.Define a value set for the Company and Intercompany segments.
H.Define a journal source and a journal category for Intercompany.
Correct:D F
5.Select the three true statements about mapping rules. (Choose three.)
A.A rollup rule tells General Ledger what detail level of information to transfer and how to roll that
information up to the parent.
B.There are only three rollup rules: 1. Transfer Level Detail - Using Detail Ranges; 2. Transfer Level Detail
- Using Parent; 3. Transfer Level Summary - Using Parent
C.You can define a combination of segment values and account rules.
D.There are only two mapping rule actions: 1. Copy Value from; 2. Assign Value from
E.Mapping sets enable you transfer data from multiple subsidiaries simultaneously.

Correct:A C E
6.XYZ Corporation has two sets of books and six inventory organizations. What is the minimum
number of times that XYZ needs to run the general ledger interface in order to close the inventory
at the end of each accounting cycle?
A.2
B.4
C.6
D.8
E.10
F.12
Correct:C
7.XYZ Company has many Financial Statement Generator reports created to produce Profit &
Loss statements and Balance Sheet reports. Occasionally XYZ has a need to run a report that is
slightly different than the standard ones that are already created. Which two types of changes
could XYZ make using the Row Order feature? (Choose two.)
A.add a new calculation
B.sort based on column values
C.display segment values and descriptions
D.change how rounding options are performed
Correct:B C
8.XYZ Enterprise has two diverse business operations in retail stores and services. It has five
legal entities in Canada and five in the United States for both operations. The fiscal year end is the
same for all the legal entities with 12 monthly periods. However, XYZ wants to use a 4-5-4
accounting calendar for its retail operations and a calendar-month accounting calendar for the
services operations. XYZ also wants to use a single chart of accounts structure. Which five items
must XYZ define to meet the minimum setup steps that are required for the sets of books for all
legal entities? (Choose five.)
A.two sets of books
B.four sets of books
C.three sets of books
D.account combinations
E.one accounting calendar
F.two accounting calendars
G.chart of accounts structure
H.period types or use seeded ones
I.enable seeded CAD and USD currencies
Correct:B F G H I

1Z0-048試験問題集
弊社(killtest)が開発した模擬試験ソフトは同じタイプの製品の中ではずば抜けており、広範囲の受験生の方が受験前に自己能力を把握できる一番有効な手段です。1Z0-048模擬試験 問題は実際の試験問題よりずっと難しいです。弊方の製品をご利用いただくと、Other Oracle Certification資格認定 受験の自信を向上させることが出来ます。また、弊社は無償サンプル品を用意しておりますので、お買い上げの前に、無償でダウンロードできます。
弊社製品をお買い上げの上、真面目に習得していただくと、ご選択された受験に一発で合格することを保証します。万が一、試験が不合格となってしまった場合には、全額ご返金或いはご返金に相当する他の資格認定資料を多く購入できるポイントをご提供致します。

1Z0-048

1.Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize
the access to available listeners?
A.FAILOVER
B.LOAD_BALANCE
C.SOURCE_ROUTE
D.TYPE_OF_SERVICE
Correct:B
2.You are working as a DBA in a RAC environment that is available for testing. The RAC
environment has all the database files stored in the OCFS file system. You plan to install ASM and
move all the database files to ASM to achieve better performance. During the installation, you
selected redundancy level as normal for the disk group being added. What is the reason for
selecting this redundancy level?
A.You want to use hardware mirroring.
B.You do not want to have any mirroring in the disk group.
C.You have two failure groups defined, so you want to use two-way mirroring.
D.You have three failure groups defined, so you want to use three-way mirroring.
Correct:C
3.You are running a two-instance database with six redo log groups defined and decide to add a
third thread to support a third database instance on the third node of the cluster. Which three
commands would you issue to achieve this using command line administration? (Choose three.)
A.ALTER SYSTEM ENABLE THREAD 3;
B.ALTER DATABASE ENABLE THREAD 3;
C.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8;
D.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
E.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7;
F.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
Correct:B E F
4.Which initialization parameter would you use for each RAC instance to make sure that each
listener on each RAC node is aware of the load of all the others?
A.LOCAL_LISTENER
B.REMOTE_LISTENER
C.REMOTE_DEPENDENCIES_MODE
D.PREFER_LEAST_LOADED_NODE_
Correct:B
5.You have a well-tuned, non-RAC single instance Oracle database with several services, all of
which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file
systems would be shared using Oracle Cluster File System. After the migration, you want to
perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC
database. Which six areas would you monitor to determine whether there are RAC-specific
performance problems after migration? (Choose six.)
A.Interconnect latency
B.Instance recovery time
C.Services with applications that use external tables
D.Services with applications that truncate large tables

E.Services with applications using local context variables
F.Services with query-intensive applications relying on full table scans
G.Services with insert-intensive applications that use Oracle sequences for index keys
H.Services with applications that have occasional queries, using index access on modestly sized tables
I.Services with insert-intensive applications that generate their own keys without Oracle sequences
Correct:A B D F G I
6.After a power failure, you noticed that one of your cluster database instances did not start
automatically, whereas all other instances came up successfully. What would you do to determine
the precise cause for the instance startup failure? (Choose three.)
A.Check the resource state by using the CRS_STAT command.
B.Check for OCR corruptions by using the OCRCHECK command.
C.Check the alert.log file that belongs to the instance that did not start.
D.Check the alert.log file that belongs to the Oracle Clusterware software.
E.Check if the Oracle Clusterware is functional by using the CRSCTL command.
F.Reboot the node where the failing instance resides to check if the problem is persistent.
G.Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
Correct:A C D