Oracle 1Z0-042 시험 개요:

Oracle 1Z0-042 시험 요강 주제:

최신 10g DBA 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 data from database buffer cache
B) because of redo data from redo log file
C) because of undo data from the undo tablespace
D) because of data from a temporary tablespace

2. Examine the following commands executed in your database:
SQL> ALTER SESSION RECYCLEBIN=ON;
Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Table created.
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp; Table dropped.
What happens in this scenario?

A) The table is moved to the SYSAUX tablespace.
B) The table is moved to the SYSTEM tablespace.
C) The table is renamed and remains in the TBSFD tablespace.
D) The table is removed from the database permanently.

3. You created a response file and want to check it before starting installations in silent mode. You started installation of Oracle software in interactive mode by providing the response file. In the middle of the installation, you realize that the behavior of the Oracle Universal Installer (OUI) is not consistent with the response file. What action would you take to detect the cause of this behavior?

A) Compare the contents of the installActions.log file with that of the response file.
B) Refer to the alert log file for information regarding the actions performed by OUI during installation.
C) Refer to the contents of the oraInst.loc file to verify the steps performed by OUI.
D) Compare the contents of the install.log file with the response file.

4. Your database instance is started using the server parameter file (SPFILE). Control files are multiplexed and stored on different disks. Because of a disk failure, you lost one of these control files. You replaced the damaged disk. What is the correct sequence of steps that you would follow to recover the control file?
1.Shut down the instance, if not already done.
2.Copy one of the remaining control files to a new location.
3.Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4.Start up the database instance to the NOMOUNT stage.
5.Recover the database to the point of failure of the control file.
6.Open the database.

A) 2,4,3,4,5
B) 5,2,3,4
C) 1,2,4,3,5
D) 4,5,6,2,3

5. View the Exhibit.
Which statement regarding the dept and emp tables is true?

A) When you delete a row from the emp table, automatically the corresponding rows are deleted from the dept table.
B) When you delete a row from the emp table, you would receive a constraint violation error.
C) When you delete a row from the dept table, you would receive a constraint violation error.
D) When you delete a row from the emp table, automatically the corresponding rows are updated with null values in the dept table.
E) When you delete a row from the dept table, automatically the corresponding rows are deleted from the emp table.
F) When you delete a row from the dept table, automatically the corresponding rows are updated with null values in the emp table.

질문과 대답: