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

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


Play button


Play button




Click to flip

34 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
structure that is used by Oracle to store data.
structure is referenced in terms of rows and columns.
A table is created in a?
table segment
The table segment, in turn, consists of one or more?
The data from the table is stored in?
database blocks
If your data will be frequently accessed this way, you can use a large block size and storage parameters that pack as many rows as possible into the data blocks.
The advantage here is that when the first row in the block is requested, the entire block is loaded into memory.
When subsequent rows are requested, they are already loaded into memory.
opposite of sequential data access.
random access
use a small block size and pack the data less with this type of access.
If a data block has inadequate room to store 1 or more rows, the row is split & referred to as a?
chained row
consist of multiple row pieces
row of data consisting of the row header and the actual row data.
row piece
stores information about the row, the row piece, column definitions, and information about chaining and cluster keys (if applicable).
row header
Scalar data type. Fixed-length character. This can be any length between 1 and 255 bytes.
Scalar data type. Variable-length character data up to 2GB in size.
scalar data type. Variable-length character data up to 2GB in size, but not converted via Oracle utilities the way long data is.
long raw
For use with Trusted Oracle, this data type stores the binary format of the system label.
Stores a triplet that consists of the data block, the row, and the datafile. Every row in a nonclustered table has a one?
A variable-length character data type. This data type is not guaranteed to remain the same.
A variable-length character data type that stores 1–2,000 characters. Anything larger requires LONG or LONG RAW.
data type consists of a set of built-in types or objects referred to as elements of the array. Each element has an index that corresponds to the position in the array.
The number of elements in an array varies
Think of this data type as a pointer to an object. This can also be used in a manner similar to a foreign key in an RDBMS.
references large pieces of data, such as video or text.
large schema object (lob)
is an unstructured binary data field. This might be something like video or picture information.
blob (binary large schema object)
A large field that consists of standard, single-byte characters. This might be something like a document.
Is similar to the CLOB type, but consists of single or multibyte characters from the National Character Set.
Essentially a pointer to an externally stored file.
A variable number (set) of built-in types or objects, each with an index that corresponds to its position in the array
What Oracle schema contains the schema objects that are created by default when the database is created?
The primary advantage of using the CREATE TABLE and ALTER TABLE commands is the ability to include this clause?
this clause can be used to define how your space is created and how it grows.
this clause is used to define the storage parameters on a tablespace.
default storage
The STORAGE clause always takes priority over this clause
Complete the following code to specify that the initial tablespace extents will be three megabytes, the second extent will be three megabytes, and all subsequent extents will be 10% larger.
inital 3m next 3m pctincrease 10
The type of partitioning that Oracle supports. Assigns rows to different tablespaces or partitions based on the value of that data.
range partitioning
oracle is a ORDBMS. This stands for
object-relational database management system.
The structure of the object type is referred to as?
object attribute
functions or procedures that are used by that object type are referred to as?
a window into a table is referred to as?
logical structures that look like tables but are actually supersets or subsets of a table.
A view derives its data from other tables, which are referred to as?
base tables