Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
12 Cards in this Set
- Front
- Back
|
What is iSQL*Plus?
|
a browser-based interface that uses the SQL*Plus processing engine in a three-tier model.
|
|
|
iSQL*Plus is comprised of what three-tier model?
|
Client (Web browser)
Middle tier (Application Server) Database (Oracle Database) (installed by default when you install Oracle 9i, 10g, or 11g.) |
|
|
Character Field
|
A field composed of non-numeric data. This field will not display a heading longer than the width of the data stored in the field.
|
|
|
Clause
|
Each section of a statement that begins with a keyword (SELECT clause, FROM clause, WHERE clause, etc.).
|
|
|
Column Alias
|
Another name substituted for a column name. A column alias is created in a query and displayed in the results.
|
|
|
Data Type
|
The type provided during the CREATE TABLE statement that determines the type of data to be allowed in a particular column (integer, varchar, date, etc.).
|
|
|
Keywords
|
Words used in a SQL query that have a predefined meaning to Oracle9i. Common keywords include SELECT, FROM, and WHERE.
|
|
|
Numeric Column
|
A column composed of only numeric data. In output, the column will display the entire column heading, regardless of the width of the field. (Also known as a numeric field.)
|
|
|
Projection
|
Choosing specific column(s) in a SELECT statement
|
|
|
Query
|
A question posed to the database
|
|
|
String Literal
|
Alphanumeric data, enclosed within single quotation marks, that instructs the software to interpret ―literally‖ exactly what has been entered and to show it in the resulting display.
|
|
|
Syntax
|
The basic structure, pattern, or rules, for a SQL statement. For an SQL statement to execute properly, the correct syntax must be used.
|
