Study your flashcards anywhere!

Download the official Cram app for free >

  • 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/9

Click to flip

9 Cards in this Set

  • Front
  • Back
what is the init.ora
file containing entries that determine the runtime environment of the oracle9i database as it operates.
how much data can a BLOB store?
4GB
what is the difference between ddl and dml?
ddl = statements that define or delete database objects such as tables or views.
dml = any SQL statement that begins with select, insert, update or delete.
describe the long data type
stores variable-length character data.
what are the 3 categories of database files?
data files, control files, and redo log files.
what is the SGA?
System Global Area. chunk of memory acquired when the server is started.
what is DML
data manipulation language
what is DDL
data definition language
all SQL statements fall into what 2 general categories?
DDL and DML