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.) A.Data Pump B.SQL*Loader C.External table D.Oracle Text E.Oracle Import Show Answer

Read More

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? 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 […]

Read More

Which two operations require undo data?

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 Show Answer

Read More

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 or less should receive a bonus.2. Employees who […]

Read More

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? A.Set the warning threshold for the Current Logons Count metric. B.Set the limits in the profiles used by users. C.Use the Database […]

Read More

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.) A.a shareable table lock for the table containing the row B.null lock on the table containing the row C.exclusive table-level lock […]

Read More

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

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 […]

Read More

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? A.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2; B.RECOVER LOGFILE BLOCK […]

Read More