IT인증자격증은 국제적으로 승인받는 자격증이기에 많이 취득해두시면 취업이나 승진이나 이직이나 모두 편해집니다. 다른 사람이 없는 자격증을 내가 가지고 있다는것은 실력을 증명해주는 수단입니다. Oracle 1Z0-042 (Oracle database 10g:Administration I)시험은 널리 승인받는 자격증의 시험과목입니다.Oracle 1Z0-042 (Oracle database 10g:Administration I)덤프로 Oracle 1Z0-042 (Oracle database 10g:Administration I)시험공부를 하시면 시험패스 난이도가 낮아지고 자격증 취득율이 높이 올라갑니다.자격증을 많이 취득하여 취업이나 승진의 문을 두드려 보시면 빈틈없이 닫힌 문도 활짝 열릴것입니다.
NO.1 You executed the STARTUP MOUNT command to start your database. For which database operation
do you need to start the database in the MOUNT state?
A. dropping a user in your database
B. dropping a tablespace in your database
C. enabling or disabling redo log archiving
D. renaming the control files
E. re-creating the control files, after you lost all the control files in your database
Answer: C
NO.2 Which two operations require undo data? (Choose two.)
A. recovering from failed transactions
B. recording a transaction to redo log files
C. rolling back a transaction
D. committing a transaction
E. rolling forward during instance recovery
Answer: AC
NO.3 You specified extent management as local for a tablespace. How will it affect space management in the
tablespace?
A. The tablespace will be system managed and the users cannot specify the extent size.
B. Free extents will be managed by the data dictionary tables.
C. All the extents will be of the same size.
D. Bitmap will be used to record free and allocated extents.
Answer: D
NO.4 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.5 Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in
iSQL*Plus.?
A. The user must be granted the database administrator (DBA) privilege.
B. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant
the webDba role to the user.
C. The user must be listed in the password file for the authentication.
D. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
Answer: B
NO.6 Which statement regarding the contents of the V$PARAMETER view is true?
A. displays only the list of default values
B. displays the current contents of the server parameter file
C. displays the currently in effect parameter values
D. displays the list of all the parameter files of a database
E. displays only the list of all advanced parameters
F. displays only the list of all basic parameters
Answer: C
NO.7 The employee IDs of employees who have made sales in the company are transferred from the
EMPLOYEES table to the BONUS table with a default bonus value. Later, the human resources
department decides to give bonuses to employees as per the following conditions:
1. Employees with a salary of $8,000 or less should receive a bonus.
2. Employees who have not made sales get a bonus of 1% of their salary.
3. Employees who already made sales get an increase in their bonus equal to 1% of their salary.
What would you do to implement these changes in one step?
A. Use SQL*Loader utility.
B. Use the MERGE statement.
C. Use a multitable insert operation.
D. Use a correlated UPDATE statement.
Answer: B
NO.8 You have a text file that maintains information on thousands of items. The end-user application requires
the transfer of that information into a table in the database. What would you use to achieve this task?
(Choose two.)
A. Data Pump
B. SQL*Loader
C. External table
D. Oracle Text
E. Oracle Import
Answer: BC