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.)
Which step do you need to perform to enable a user with the SYSDBA privilege to log in asSYSDBA in iSQL*Plus?
You specified extent management as local for a tablespace. How will it affect space managementin 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 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 […]
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?
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?
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?
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?