10g DBA 1Z0-042 (Oracle database 10g:Administration I) 시험을 가장 빠른 시일내에 가장 쉬운 방법으로 패스하는 방법을 고심초사한끝에 Pass4Test에서 연구해 내었습니다. 그건 바로 Pass4Test의 10g DBA 1Z0-042 (Oracle database 10g:Administration I) 덤프로  10g DBA 1Z0-042 (Oracle database 10g:Administration I) 시험에 대비하는것입니다. Pass4Test의 10g DBA 1Z0-042 (Oracle database 10g:Administration I) 덤프품질을 검증하려면 구매사이트의 무료샘플을 체험해보시면 됩니다.자격증을 많이 취득하여 멋진 IT전문가로 되세요.

 

 

NO.1 In your database, the snapshot interval is set to 10 minutes for the Automatic Workload Repository
(AWR). The database instance is running for the past 30 days.
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) task.
The ADDM task is performed every 10 minutes, except the last task. What could be the reason for this?
A. The snapshot retention period for the AWR was increased before the last task.
B. The STATISTICS_LEVEL initialization parameter was changed to BASIC and reset to TYPICAL before
the last task.
C. The optimizer statistics was collected manually by using the DBMS_STATS package before the last
task.
D. The optimizer statistics for few objects in the database were locked before the last task.
Answer: B

NO.2 You want to create a tablespace with the following specifications:
1. The tablespace extends automatically.
2. Used and free extents should be managed by bitmaps.
3. Default PCTUSED attribute is set to 60.
4. All the extents would be of size 1 MB.
Which three options would you choose to create the tablespace? (Choose three.)
A. tablespace with segment space management as automatic
B. tablespace with AUTOEXTEND enabled
C. tablespace with a uniform extent allocation of 1 MB
D. tablespace with dictionary-managed extents
E. tablespace with segment space management as manual
Answer: BCE

NO.3 Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and
archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has
written everything to disk. Which command would you execute to proceed further?
A. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
B. RECOVER LOGFILE BLOCK GROUP 2;
C. ALTER DATABASE CLEAR LOGFILE GROUP 2;
D. ALTER DATABASE DROP LOGFILE GROUP 2;
E. ALTER DATABASE RECOVER LOGFILE GROUP 2;
Answer: A

NO.4 View the Exhibit to see the source and target databases.
You have created a database link, devdb.us.oracle.com, between the databases PRODDB and DEVDB.
You want to import schema objects of the HR user using Oracle Data Pump from the
development database, DEVDB, to the production database, PRODDB. You execute the following
command on the target database server:
$impdp system/manager directory = DB_DATA
dumpfile = schemas.dat
schemas = hr
flashback_time = 2004-02-03 09:00
The command fails, displaying the following error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read
ORA-27037: unable to obtain file status
What would you do to overcome the error?
A. remove the dumpfile option in the command
B. remove the flashback_time option in the command
C. remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command
D. add the user, SYSTEM, to the schemas option in the command
E. remove the schemas option and add the network_link = devdb.us.oracle.com option in the command
F. add network_link = devdb.us.oracle.com option in the command
Answer: C

NO.5 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 redo data from redo log file
B. because of data from a temporary tablespace
C. because of undo data from the undo tablespace
D. because of data from database buffer cache
Answer: C