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