Exam information

Exam 1Z0-042: Database 10g: Administration I (updated June 13th, 2013)

Other

What would you use to achieve this task?


You have a text file that maintains information on thousands of items. The end-user applicationrequires the transfer of that information into a table in the database. What would you use toachieve this task? (Choose two.)

you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?

Which step do you need to perform to enable a user with the SYSDBA privilege to log in asSYSDBA in iSQL*Plus?

How will it affect space management in the tablespace?

You specified extent management as local for a tablespace. How will it affect space managementin the tablespace?

Which two operations require undo data?

Which two operations require undo data? (Choose two.)

What would you do to implement these changes in one step?

The employee IDs of employees who have made sales in the company are transferred from theEMPLOYEES table to the BONUS table with a default bonus value. Later, the human resourcesdepartment decides to give bonuses to employees as per the following conditions:1. Employees with a salary of $8,000 […]


Which type of index would you suggest to improve the query performance?

The ST_INFO master table has millions of rows that are updated very rarely. It has aSTATE_CODE column that contains the value for 25 states. The table is frequently queried on theSTATE_CODE column. Which type of index would you suggest to improve the queryperformance?

What action would you take to achieve this?

You want to monitor and control the resource usage by sessions. You want to be warnedautomatically when more than 100 sessions are opened with your database. What action wouldyou take to achieve this?

What are the two types of locks that this scenario would lead to?

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has notcommitted the transaction. What are the two types of locks that this scenario would lead to?(Choose two.)

Which statement regarding the contents of the V$PARAMETER view is true?

Which statement regarding the contents of the V$PARAMETER view is true?

Which command would you execute to proceed further?

Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, andarchiving has stopped. All the redo logs are filled and database activity is halted. Database writerhas written everything to disk. Which command would you execute to proceed further?



Page 1 of 1712345...10...Last »