Oracle Fachvokabular

A join that joins more than two tables in a query.

An entry found in the sqlnet.ora file that defines the net service name search method hierarchy for a client.

A join that joins two tables using the columns with the same name and datatype in both tables.

A subquery within another subquery.

The name of an Oracle service on the network. This is the name the user enters when referring to an Oracle service.

A failure in the network connection between the client and the database; for example, a router reboot or a failure of a network card in the server.

The sequence pseudocolumn that will cause the generation of the next number from the sequence-number generator.

A database mode in which redo log files are not written to an archive destination before they are overwritten. A database in NOARCHIVELOG mode can recover only from an instance failure.

A join that joins two tables with a nonequality operator.

A network architecture involving at least three computers, typically a client computer, a middle-tier computer, and a database server.

A value that represents unknown or missing data. Most functions return NULL when called with a NULL argument.

Datatype used to store numeric values in table.

A database privilege that allows the grantee to perform a specific operation on a database object, such as a SELECT, an UPDATE, or a DELETE operation on a table.

A model for organizing mount points, directory structures, and files so that they will be easier to manage, maintain, and back up.

A container for bundling procedures, functions, and data structures.

The part of a package that contains the program implementation.

The part of a package that declares its external interface.

A backup that includes zero or more tablespaces, which in turn include zero or more data files; a control file is optional in a partial database backup.

A secret word associated with each user ID to authenticate a database connection.

The encrypted file that contains the usernames and passwords of users who have been granted SYSDBA and SYSOPER privileges.

A plain-text file that contains database-initialization parameters. Oracle reads this file at startup and uses the information to configure various aspects of the Oracle instance and database.

A TCP/IP utility that checks basic network connectivity between two computers.

Used with TCP/IP to name the ends of logical connections, which carry conversations between two computers.

A column or combination of column values that can identify a row uniquely. Primary key columns cannot have NULL values.

Permits only the minimal set of privileges that are required for the situation.

A restricted alias to another object.

The assigned permissions to create, modify, remove, or use a database object or a feature.

Monitoring the Oracle server for potential issues before they occur, thus avoiding the impact on the database’s performance, availability, or manageability.

A PL/SQL program that is invoked as a stand-alone statement.

The background process that cleans up failed user connections.

A set of limits on database resources or password characteristics.

An area of memory in which information for each client session is maintained. PGA includes bind variable, cursor information, and the client’s sort area.

A firewall that prevents information from outside the firewall from flowing directly into the corporate network. The firewall acts as a gatekeeper, inspecting packets and sending only the appropriate information to the corporate network.

A global alias to another object.