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.)
Which step do you need to perform to enable a user with the SYSDBA privilege to log in as
SYSDBA in iSQL*Plus?
You specified extent management as local for a tablespace. How will it affect space management
in the tablespace?
Which two operations require undo data? (Choose two.)
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?
The ST_INFO master table has millions of rows that are updated very rarely. It has a
STATE_CODE column that contains the value for 25 states. The table is frequently queried on the
STATE_CODE column. Which type of index would you suggest to improve the query
You want to monitor and control the resource usage by sessions. You want to be warned
automatically when more than 100 sessions are opened with your database. What action would
you take to achieve this?
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not
committed the transaction. What are the two types of locks that this scenario would lead to?
Which statement regarding the contents of the V$PARAMETER view is true?
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?