0

Oracle Database

Description: database design Java/Oracle /C/C++Oracle
Number of Questions: 15
Created by:
Tags: database design Java/Oracle /C/C++ Oracle
Attempted 0/15 Correct 0 Score 0

Which of the following memory components of the SGA stores all the changes made in the database?

  1. Streams pool

  2. SQL work area

  3. Redo log buffer

  4. Instance creation

  5. Read only


Correct Option: C
Explanation:

This memory component of the SGA stores all changes made in the database.

Which of the following contents of the program global area contains bind information and runtime memory structures?

  1. Private SQL area

  2. SQL work area

  3. Stream pool

  4. Extent

  5. Mounting the database


Correct Option: A
Explanation:

This content 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?

  1. Oracle instance

  2. Extent

  3. Instance creation

  4. Oracle database

  5. Read only


Correct Option: D
Explanation:

This is the 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?

  1. Stream pool

  2. Shared pool

  3. Instance creation

  4. SQL work area

  5. Force


Correct Option: B
Explanation:

The contents of this component 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?

  1. Extent

  2. Oracle instance

  3. Tablespace

  4. Mounting the database

  5. Archive files


Correct Option: C
Explanation:

This logical storage structure 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?

  1. Stream pool

  2. SQL work area

  3. Archive file

  4. Mounting the database

  5. Database buffer cache


Correct Option: E
Explanation:

This memory component 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?

  1. Oracle instance

  2. Oracle server

  3. Archives files

  4. Stream pool

  5. pfile


Correct Option: B
Explanation:

The oracle server is made up of an oracle instance and oracl database.

Which of the following memory components of the system global area is used for handling large input/output requests of server processes?

  1. SQL work area

  2. Instance creation

  3. Read only

  4. Large pool

  5. Stream pool


Correct Option: D
Explanation:

This memory component 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?

  1. Archive file

  2. Parameter file

  3. Control file

  4. Instance creation

  5. Read only


Correct Option: C
Explanation:

Control files maintain 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?

  1. Session memory

  2. SQL work area

  3. Stream pool

  4. Instance creation

  5. ABORT


Correct Option: A
Explanation:

This memory component 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?

  1. Schema

  2. Extent

  3. Oracle instance

  4. Parameter file

  5. Force


Correct Option: A
Explanation:

A schema is a good way to group objects in the database for purposes 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?

  1. Extent

  2. Oracle instance

  3. Archive file

  4. Registration

  5. Segment


Correct Option: E
Explanation:

This logical storage structure is a collection of extents allocated for a single type of object such as 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?

  1. Stream pool

  2. Library cache

  3. SQL work area

  4. Instance creation

  5. pfile


Correct Option: B
Explanation:

This memory component 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?

  1. Data files

  2. Database block

  3. Extent

  4. Instance creation

  5. Stream pool


Correct Option: A
Explanation:

All objects created in the database by users have their data physically stored in the data files.

Which of the following memory components of the system global area is used by all session-specific java code and data within the JVM?

  1. Java applet

  2. Java pool

  3. Stream pool

  4. SQL work area

  5. Mounting the database


Correct Option: B
Explanation:

This memory component of the system global area is used by all session-specific java code and data within the JVM.

- Hide questions