2. Which command is used to remove an index from the database in SQL? DELETE INDEX DROP INDEX REMOVE INDEX ROLL BACK INDEX
3. What is the name given to the database management system which is able to handle full text data, image data, audio and video? Full media Graphics media Multimedia Hypertext
4. Which password management feature ensures a user cannot reuse a password for a specified time interval? Account Locking Password History Password Verification Password Expiration and Aging
5. Which privilege is required to create a database? SYSDBA DBA SYSOPER RESOURCE
6. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles? Full Backup Consistent Backup Inconsistent Backup Differential Backup
7. Which type of file is part of the Oracle database? Control file Password file Parameter files Archived log files
8. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure? Application failure Instance Failure Media Failure Rollback failure
9. What Oracle backup and recovery file contains user and system data? Control file Data file OnLine ReDo file Offline ReDo file
10. When is the SGA created in an Oracle database environment? When the database is created When a user process is started When the database is mounted When the instance is started
Score = Correct answers: