Q. 1 : The Database must be in this mode for the instance to be started
1. MOUNT
2. OPEN
3. NOMOUNT
4. None
3
Q. 2 : When Oracle startups up, what happens if a datafile or redo log file not available or corrupted due to O.S Problems
1. Oracle returns a warning message and opens the database
2. Oracle returns a warning message and does not open the database
3. Oracle returns a warning message and starts the database recovery
4. Oracle ignores those files and functions normally
2
Q. 3 : The RESTRICTED SESSION system privilege should be given to
1. Users, who need extra security while transfering the data between client and the server through SQL*NET or NET8.
2. DBAs, who perform structural maintenance exports and imports the data.
3. All of the above
4. None of the above
2
Q. 4 : When Starting up a database, If one or more of the files specified in the CONTROL_FILES parameter does not exist, or cannot be opened