Database Management Systems

This parameter in the create sequence command of SQL specifies that the values of the sequence are not preallocated.

These segments in oracle are created when the application creates the table or cluster with the Create command.

This component of SGA are shared by multiple users as the contents of its memory area.

This schema in a distributed database specifies that the fragments are really the logical portions of the global relation, which are physically dispersed at different sites of the network, and defines at which site a fragment is allocated.

This component of data block in oracle contains information about tables that have data in the data block.

A schema is a collection of all objects that a user has created.

A profile is a set of predefined resource parameter that can be used to monitor and control various database resources.

Operating system authentication mechanism is used to manage the password for the account.

STORAGE_ERROR is raised if PL/SQL runs out of memory or if memory is corrupted.

LOGIN_DENIED is raised when login to ORACLE failed because of invalid username and password

This is the table used in SQL for performing arithmetic calculation.

This pool is a memory area used by the Oracle streams product for its functioning.

Private SQL area contains bind information and runtime memory structures.

This cache in SGA is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures.

This view gives information about various database objects.