• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/12

Click to flip

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.