Home › Quizzes › Oracle Database Architecture and Memory Management

Oracle Database Architecture and Memory Management

This test contains the questions related to Oracle database concepts, which are useful for CS and GATE aspirants.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is the correct statement about the System Global Area (SGA) in memory structure of Oracle Database?

  1. It is a shared memory region that contains data and control information for one Oracle instance.
  2. The database buffers and the shared pool are not the parts of SGA.
  3. It also consists of stack-space and session-information.
  4. It maintains the memory in a non-shared medium.
  5. One can create a number of instances for the shared memory.
Question 2 Multiple Choice (Single Answer)

Which of the following is correct about the Archive log files in Oracle database?

  1. These files are used to copy the redo log file in a single location.
  2. These files are mandatory to apply changes to a standby database.
  3. These files are used exclusively for temporary storage data.
  4. These files provide the physical storage of data, which can consist of the data-dictionary data.
  5. It provides data specific usability in the system.
Question 3 Multiple Choice (Single Answer)

Which of the following is an incorrect statement about Control files in Oracle database?

  1. These files provide the physical storage of data, which consists of the data-dictionary data.
  2. These files have the information about the physical structure of a database.
  3. These files have the information about the time stamp of the database creation, the current log sequence number and the checkpoint information.
  4. At the physical level, data files comprise one or more data blocks.
  5. These files maintain the information of the database.
Question 4 Multiple Choice (Single Answer)

Which of the following is correct about 'Library cache' in Oracle database?

  1. It is responsible for storing the shared SQL statements and execution steps for that.
  2. It is used to enhance the amount of memory needed and the processing-time used for parsing and execution planning.
  3. It has user information and user privileges.
  4. In this cache, the information on space is allocated and used for schema objects.
  5. In this cache, the information is managed as per the specific execution plan.
Question 5 Multiple Choice (Single Answer)

Which of the following information does the data dictionary cache not contain in Oracle database?

  1. It has user information, such as user privileges.
  2. It contains the names and datatypes of all columns in database tables.
  3. It has integrity constraints defined for tables in the database.
  4. It has names and datatypes of all columns in database tables.
  5. It is not suitable for user authentication.
Question 6 Multiple Choice (Single Answer)

What is 'stack-space' in Program Global Area?

  1. It is the memory that holds the session's variables, arrays and so on.
  2. In this, the database instance stores its session-information in the PGA and the session-information goes in the SGA.
  3. It is an area that holds information such as bind-variables and runtime-buffers.
  4. It is an area in the PGA that holds information on sorts, hash-joins etc.
  5. It is the area that stores the information about memory management.
Question 7 Multiple Choice (Single Answer)

What is 'private SQL-area' in Program Global Area in Oracle database?

  1. It is the memory that holds the session's variables, arrays and so on.
  2. In this, the database instance stores its session-information in the PGA and the session-information goes in the SGA.
  3. It is an area that holds information such as bind-variables and runtime-buffers.
  4. It is an area in the PGA that holds information on sorts, hash-joins etc.
  5. It has the information about memory utilization.
Question 8 Multiple Choice (Single Answer)

Which of the following is incorrect about 'Shared Pool' in SGA?

  1. It stores the program code.
  2. It has information about a connected session, even if it is not currently active.
  3. It has the information needed during program execution.
  4. It has the information about the cached data that is also permanently stored on peripheral memory.
  5. It does not have the information related to cache and memory.
Question 9 Multiple Choice (Single Answer)

Which of the following is false statement about Automatic Locking in Oracle database?

  1. Oracle locking is performed automatically and requires no user action.
  2. Oracle's lock manager automatically locks table data at the row level.
  3. Oracle's lock manager maintains several different types of row locks.
  4. There are two general types of locks-exclusive locks and share locks.
  5. Exclusive lock checks the status of memory leak.
Question 10 Multiple Choice (Single Answer)

Which of the following information is incorrect about Streams Pool in System Global Area (SGA)?

  1. It specifies that Streams memory be allocated from a pool in the SGA .
  2. A stream pool can be created automatically.
  3. It is used in server memory for all session-specific Java code and data within the JVM.
  4. It provides memory synchronization.
  5. It is responsible for execution plan in pooled memory.
Question 11 Multiple Choice (Single Answer)

Which type of information does 'Shared Pool' stores in SGA (System Global Area)?

  1. It stores the most recently used blocks of data.
  2. It stores a log of changes made to the database.
  3. It contains information such as the parse tree and execution plan for the corresponding statement.
  4. It uses a non-shared SQL area to process every unique SQL statement submitted to the database.
  5. It is used to store the execution state of the database.
Question 12 Multiple Choice (Single Answer)

Which of the following is a false statement about the control of the SGA's use of Memory?

  1. The SGA can grow in response to a database administrator statement.
  2. The SGA can shrink in response to a database administrator statement, to an Oracle prescribed minimum.
  3. The buffer cache and the SGA pools can grow and shrink at runtime.
  4. The Dynamic SGA provides external controls for increasing and decreasing Oracle's use of physical memory.
  5. The Dynamic control provides controls for the execution of procedures in the database.
Question 13 Multiple Choice (Single Answer)

Which of the following is the incorrect statement about the Software Code Areas in Oracle database?

  1. These code areas are portions of memory used to store code that is being run or can be run.
  2. Software areas are usually static in size.
  3. Software areas are read only and can be installed shared or nonshared.
  4. The multiple instances of Oracle can use the same Oracle code area with different databases if running on the same computer.
  5. It is responsible for running the stored procedures in the database.
Question 14 Multiple Choice (Single Answer)

Which of the following is false about Real Application Clusters (RAC) in Oracle database?

  1. It comprises of several Oracle instances running on multiple clustered computers.
  2. RAC uses cluster software to access a shared database that resides on shared disk.
  3. It provides system redundancy, near linear scalability and high availability.
  4. It provides data synchronization.
  5. It contains the information of the database backup.
Question 15 Multiple Choice (Single Answer)

Which of the following is false about Quiesce Database?

  1. Database administrators occasionally need isolation from concurrent non-database administrator's actions.
  2. In this, the execution of data can be performed concurrently for each type of action.
  3. One can put the system into quiesced state without disrupting users.
  4. The execution of data is managed by this approach.
  5. It is used to synchronise the database.
← Back to Quizzes