Chapter7

Question 1

a customized representation of data from one or more tables and/or views

Answer 1

view

Question 2

the tables that the view is referencing

Answer 2

base table

Question 3

the views that actually copy data from the data from base tables and take up storage are called ______

Answer 3

materialized views

Question 4

the maximum number of columns that can be defined in a view is _______

Answer 4

1000

Question 5

note1:

Answer 5

When the database instance terminates abnormally or the DBA performs SHUTDOWN ABORT on the database instance, the sequence numbers cached are lost.

Question 6

is a named sequential-number generator

Answer 6

sequence

Question 7

access the next number in the sequence

Answer 7

NEXTVAL(sequence_name.nextval)

Question 8

get the last sequence number your session has generated

Answer 8

CURRVAL(sequence_name.currval)

Question 9

forces the data dictionary to be updated for each sequence number generated

Answer 9

NOCACHE

Question 10

defines the size of the block of sequence numbers held in memory

Answer 10

CACHE

Question 11

is an alias for another database object

Answer 11

synonym

Question 12

synonym that is available to all user

Answer 12

public

Question 13

synonym that is available to only one owner

Answer 13

private

Question 14

• common index type

- high cardinality

Answer 14

B-tree

Question 15

• primarily used for decision-support or static data

Answer 15

bitmap