In a shared server environment, which of the following areas is located in the SGA and is shared by server process?

Which of the following is the centralized repository where the data is stored?

Which of the following STARTUP command options is used to open the database for queries only?

Which of the following SHUTDOWN command options is a case of an improper shutdown?

All objects created in the database by users have their data physically stored in which of the following files?

In which of the following options of SHUTDOWN command will all currently active transactions be allowed to complete?

Which of the following options in STARTUP commands is used to perform media recovery, while starting the database?

Which of the following files keeps a record of the names, size and locations of the different physical files of the database?

Which of the following files contains a record of all the changes made in the database?

Which of the following options of STARTUP command is used when you want only users, who possess the privilege to access the database?

Which of the following consists of the memory components of oracle and various background processes?

Which of the following files can be used when you use database authentication?

Which of the following can be reorganized and backed up with minimal impact to other users, whose data may be in other tablespaces?

The blocks that need to be modified, are modified in the memory and are written back to disk periodically in which of the following caches?

Which of the following logical objects is the smallest unit of storage in an oracle database?