Oracle Fachvokabular

The portion of the system global area (SGA) where cached SQL statements and supported metadata are stored.

Functions that operate on a single row at a time. These functions know how many arguments they will operate on at compile time, before any data is fetched.

A subquery that returns only one row.

A network architecture in which the client and server processes all run on the same computer.

A traditional tablespace that can have multiple data files, each limited to 2²² data blocks in size.

A buffer where the previously executed SQL statement is stored. SQL in the buffer can be edited, or it can be run using the / command.

The Oracle bulk load program to load data from a flat file.

A single SQL command that can include subqueries.

The failure of a single database operation such as a Data Manipulation Language (DML) statement; for example, INSERT, UPDATE, and so on. See also Data Manipulation Language (DML).

The inputting of service-name information directly into the listener.ora file.

The portion of the system global area (SGA) that is used to cache Oracle queuing information when the Oracle Streams feature is used. See also system global area (SGA).

The English-like language developed to allow users to easily query and manipulate the data stored in relational databases.

A query within another query. A subquery answers queries that have multiple parts. The subquery answers one part of the question, and the parent query answers the other part.

A variable that will accept values from the user during execution of the SQL.

Summary rows (created by the ROLLUP and CUBE clauses) containing NULL in the grouped expressions. The GROUPING function returns a 1 for these summary rows and a 0 for the nonsummary rows, and it is used to distinguish the summary rows
from the nonsummary rows.

Support Workbench can be used to examine a database problem and contact Oracle Support for a resolution.

An alias to another object.

A special database authorization given to users to manage ASM instances.

A built-in function to get the current system date and time.

A special all-empowering database authorization assigned to users that allows them to perform any database task.

A special database authorization assigned to users that allows them to perform a variety of database tasks, such as startup and shutdown. Its capabilities are not as encompassing as SYSDBA.

A unique number sequentially assigned to each transaction in the database.

The shared memory structure that Oracle uses to cache application users’ SQL statements, data, index, and rollback buffers, Java, and redo information.

The background process that is responsible for instance recovery, temporary tablespace management, and space management.

A database privilege that allows the grantee to perform a specific system operation, such as creating a session or altering any table.

The basic structure in the database to store data. Tables are defined with columns and contain rows of data.

An alias name for a table in queries generally used to qualify ambiguous columns to tell Oracle specifically to which table the column belongs.

A logical storage area for database segments.

The tablespace in which a user’s temporary segments are stored.

A multibyte character set that can represent characters from any language. Unicode can, for example, represent characters from English, Greek, Urdu, and Japanese within a single character set.

A view that queries from more than one table and can be used to update the base tables through the view.

SQL statement used to modify existing rows in a table.

A user operation that does not generate an error message, but whose result was unintended, such as accidentally dropping a table.

An area in either the system global area (SGA) or program global area (PGA) used to keep track of session-specific information. See also program global area (PGA); system global area (SGA).