最新の1Z0-042問題集で試験を準備する

Oracle 1Z0-042 試験概要:

Oracle 1Z0-042 試験シラバストピック:

Oracle database 10g:Administration I 認定 1Z0-042 試験問題：

問題 #1

The user SCOTT executes the following command successfully to increase the salary values in one of his sessions:
SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20;
Before SCOTT ends the transaction, user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values.
Why does HR still see the old data?

A. because of undo data from the undo tablespace
B. because of data from a temporary tablespace
C. because of data from database buffer cache
D. because of redo data from redo log file

問題 #2

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays. Which two statements are true about the differential incremental backups? (Choose two.)

A. The backup performed on Sundays contains all the blocks that have ever been use in the database.
B. The backup performed on each working day contains all the blocks that have changed since the last level 0 or level 1 backup.
C. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
D. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.

問題 #3

Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)

A. multiplexing of control files
B. dropping the database user
C. renaming of data files
D. renaming of control files
E. configuring the database in ARCHIVELOG mode

問題 #4

You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

A. Run the SQL Access Advisor.
B. Run the Automatic Database Diagnostic Monitor (ADDM).
C. Run the SQL Tuning Advisor (STA).
D. Run the Automatic Workload Repository (AWR) report.

問題 #5

Which two are valid locking levels that are used by transactions in an Oracle database? (Choose two.)

A. schema level
B. block level
C. row level
D. object level
E. database level

解説：