Oracle 8 - Database Schema Part 1

Front 1

structure that is used by Oracle to store data.

Back 1

table

Hint 1

structure is referenced in terms of rows and columns.

Front 2

A table is created in a?

Back 2

table segment

Front 3

The table segment, in turn, consists of one or more?

Back 3

extents

Front 4

The data from the table is stored in?

Back 4

database blocks

Front 5

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.

Back 5

sequential

Hint 5

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.

Front 6

opposite of sequential data access.

Back 6

random access

Hint 6

use a small block size and pack the data less with this type of access.

Front 7

If a data block has inadequate room to store 1 or more rows, the row is split & referred to as a?

Back 7

chained row

Hint 7

consist of multiple row pieces

Front 8

row of data consisting of the row header and the actual row data.

Back 8

row piece

Front 9

stores information about the row, the row piece, column definitions, and information about chaining and cluster keys (if applicable).

Back 9

row header

Front 10

Scalar data type. Fixed-length character. This can be any length between 1 and 255 bytes.

Back 10

char

Front 11

Scalar data type. Variable-length character data up to 2GB in size.

Back 11

long

Front 12

scalar data type. Variable-length character data up to 2GB in size, but not converted via Oracle utilities the way long data is.

Back 12

long raw

Front 13

For use with Trusted Oracle, this data type stores the binary format of the system label.

Back 13

mlslabel

Front 14

Stores a triplet that consists of the data block, the row, and the datafile. Every row in a nonclustered table has a one?

Back 14

rowid

Front 15

A variable-length character data type. This data type is not guaranteed to remain the same.

Back 15

varchar

Front 16

A variable-length character data type that stores 1–2,000 characters. Anything larger requires LONG or LONG RAW.

Back 16

varchar2

Front 17

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.

Back 17

varray

Hint 17

The number of elements in an array varies

Front 18

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.

Back 18

ref

Front 19

references large pieces of data, such as video or text.

Back 19

large schema object (lob)

Front 20

is an unstructured binary data field. This might be something like video or picture information.

Back 20

blob (binary large schema object)

Front 21

A large field that consists of standard, single-byte characters. This might be something like a document.

Back 21

clob

Front 22

Is similar to the CLOB type, but consists of single or multibyte characters from the National Character Set.

Back 22

nlob

Front 23

Essentially a pointer to an externally stored file.

Back 23

bfile

Front 24

A variable number (set) of built-in types or objects, each with an index that corresponds to its position in the array

Back 24

varray

Front 25

What Oracle schema contains the schema objects that are created by default when the database is created?

Back 25

sys

Front 26

The primary advantage of using the CREATE TABLE and ALTER TABLE commands is the ability to include this clause?

Back 26

storage

Hint 26

this clause can be used to define how your space is created and how it grows.

Front 27

this clause is used to define the storage parameters on a tablespace.

Back 27

default storage

Hint 27

The STORAGE clause always takes priority over this clause

Front 28

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.

Back 28

inital 3m next 3m pctincrease 10

Front 29

The type of partitioning that Oracle supports. Assigns rows to different tablespaces or partitions based on the value of that data.

Back 29

range partitioning

Front 30

oracle is a ORDBMS. This stands for

Back 30

object-relational database management system.

Front 31

The structure of the object type is referred to as?

Back 31

object attribute

Front 32

functions or procedures that are used by that object type are referred to as?

Back 32

method

Front 33

a window into a table is referred to as?

Back 33

view

Hint 33

logical structures that look like tables but are actually supersets or subsets of a table.

Front 34

A view derives its data from other tables, which are referred to as?

Back 34

base tables