Oracle 8 - Database Schema Part 1
Terms
undefined, object
copy deck
- structure that is used by Oracle to store data.
- table
- A table is created in a?
- table segment
- The table segment, in turn, consists of one or more?
- extents
- 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.
- sequential
- opposite of sequential data access.
- random access
- If a data block has inadequate room to store 1 or more rows, the row is split & referred to as a?
- chained row
- 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.
- char
- Scalar data type. Variable-length character data up to 2GB in size.
- long
- 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.
- mlslabel
- Stores a triplet that consists of the data block, the row, and the datafile. Every row in a nonclustered table has a one?
- rowid
- A variable-length character data type. This data type is not guaranteed to remain the same.
- varchar
- A variable-length character data type that stores 1–2,000 characters. Anything larger requires LONG or LONG RAW.
- varchar2
- 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.
- varray
- 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.
- ref
- 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.
- clob
- Is similar to the CLOB type, but consists of single or multibyte characters from the National Character Set.
- nlob
- Essentially a pointer to an externally stored file.
- bfile
- A variable number (set) of built-in types or objects, each with an index that corresponds to its position in the array
- varray
- What Oracle schema contains the schema objects that are created by default when the database is created?
- sys
- The primary advantage of using the CREATE TABLE and ALTER TABLE commands is the ability to include this clause?
- storage
- this clause is used to define the storage parameters on a tablespace.
- default storage
- 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?
- method
- a window into a table is referred to as?
- view
- A view derives its data from other tables, which are referred to as?
- base tables