oracle 11g 1Z0-052 問題集

Oracle Fusion Middleware 11g

1Z0-052はOracle の試験科目の一つに属します、全称はOracle Database 11g: Administrator I : 1z1-052 Examで、188の本試験題が含めています。11g  1Z0-052(Oracle Database 11g: Administrator I : 1z1-052 Exam)試験題はtestpassportのITエンジニアとOracle 製品の専門家によって作り上げて、最も新しい本試験題を含めています。

Oracle Fusion Middleware 11g
広範囲なファミリー製品は、作成、実行、迅速な管理、そして知的ビジネス・アプリケーションを支援するためにシームレスに統合されています。OracleFusion Middleware 11gのホットプラガブルなアーキテクチャは、アプリケーションと技術において、現在の投資を最大限に活用することができ、現代のハードウェアおよびソフトウェアのアーキテクチャの強みを発揮させることができます。このリリースのゴールは、適応、革新のために機敏さを与えるため、ITとビジネス・プロセスの両方への効率を最大化することです。OracleFusion Middleware 11gは革新のための基盤です。

以下は1Z0-052試験のデモです

http://pdf.testpassport.jp/1Z0-052.pdf

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

6. Note the following points describing various utilities in Oracle Database 11g:
1: It enables the high-speed transfer of data from one database to another.
2: It provides a complete solution for the backup, restoration, and recovery needs of the entire database.
3: It enables the loading of data from an external file into an Oracle database.
4: It provides a tape backup management for the Oracle ecosystem.
Which point describes Oracle Secure Backup?
A.1
B.2
C.3
D.4
E.1, 2, and 4
F.1, 2, 3, and 4
Answer: D
7. You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider
the steps that will be performed later when you open the database:
1: SGA is allocated.
2: Control file is read.
3: Redo log files are read.
4: Instance recovery is started.
5: Background processes are started.
6: Data files are checked for consistency.
7: Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?
A.7, 1, 5, 2, 3, 6, 4
B.1, 2, 3,7, 5, 6, 4
C.7, 1, 4, 5, 2, 3, 6
D.1, 7, 5, 4, 2, 3, 6
Answer: A
8. Observe the information in the columns:
1: The SGAa. Text and parsed forms of all SQL statements
2: The cursor stateb. Run-time memory values for the SQL statement, such as rows retrieved
3: User-session datac. Security and resource usage information
4: The stack spaced. Local variables for the process
Which option has the correct match between the memory areas and their contents?
A.1-c, 2-b, 3-d, 4-a
B.1-c, 2-b, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
Answer: C