Oracle Database
Description: database design Java/Oracle /C/C++Oracle | |
Number of Questions: 15 | |
Created by: Mira Shah | |
Tags: database design Java/Oracle /C/C++ Oracle |
Which of the following memory components of the SGA stores all the changes made in the database?
Which of the following contents of the program global area contains bind information and runtime memory structures?
Which of the following is a centralized container where the data is stored?
The contents of which of the following memory components of the system global area are shared by multiple users?
Which of the following logical storage structures is usually to facilitate security, performance or the availability of database objects such as tables and indexes?
Which of the following memory components of the system global area holds all the blocks read in from disk for query or modification?
Which of the following is made up of an Oracle instance and Oracle database?
Which of the following memory components of the system global area is used for handling large input/output requests of server processes?
Which of the following files maintains the timestamp of database creation?
Which of the following memory components of the program global area holds a session's variables and session-related information?
Which of the following is a good way to group objects in the database for purpose of security and access control?
Which of the following logical storage structures is a collection of extents allocated for a single type of object such as a table?
Which of the following memory components of the system global area is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures?
Which of the following logical storage structures is the lowest unit of allocation in an oracle database?
Which of the following memory components of the system global area is used by all session-specific java code and data within the JVM?