Chapter6

Question 1

is the main database object

Answer 1

Tables

Question 2

is defined with columns and stores rows of data

Answer 2

Table

Question 3

are used to hold temporary data specific to a transaction or session

Answer 3

Temporary tables

Question 4

• these types of columns do not consume storage space on disk
• database derives values in virtual columns from normal columns

Answer 4

Virtual columns

Question 5

• is a customized representation of data from one or more tables and/or view
• are queries stored in the database that select data from one or more tables

Answer 5

View

Question 6

is a way to generate continuous numbers

Answer 6

Sequence

Question 7

is an alias for any table, view, sequence, or other accessible database object

Answer 7

Synonym

Question 8

are objects used to summarize and replicate data

Answer 8

Materialized view

Question 9

is a logical structure to define the relationship between columns in a table

Answer 9

Dimension

Question 10

is a method of storing data from related tables at a common physical

Answer 10

Cluster

Question 11

are created with user-defined datatypes.

Answer 11

Object table

Question 12

is a collection of related database objects grouped together

Answer 12

schema

Question 13

is a schema object that enables you to access an object from a different database.

Answer 13

Database links

Question 14

is a stored PL/SQL program that gets executed when a specified condition occurs on the table.

Answer 14

Tiggers

Question 15

any java stuff

Answer 15

java objects

Question 16

• procedure
• function
• packages

Answer 16

PL/SQL programs

Question 17

is a PL/SQL programmatic construct

Answer 17

procedure

Question 18

like procedure but it returns a value

Answer 18

function

Question 19

it is a grouping of related PL/SQL

Answer 19

package

Question 20

• variable length strings (backward compatibility)
• discourage in Oracle
• 2GBYTES

Answer 20

long

Question 21

variable length binary string

2Kbytes

Answer 21

raw

Question 22

• variable length binary strings

- 2GBYTES

Answer 22

long raw

Question 23

• is one of the Large Object datatypes provided to store variable length character data
• Character large object

Answer 23

CLOB

Question 24

is one of the Large Object datatypes and stores variable-length Unicode character data

Answer 24

NCLOB

Question 25

- represents all non-Oracle numeric datatypes(floats, decimal, integer) - can store both fixed-point and floating-point number

Answer 25

Number

Question 26

datatype represents a 32-bit floating-point number

Answer 26

Binary_Float

Question 27

datatype represents a 64-bit floating-point number

Answer 27

BINARY_DOUBLE

Question 28

it a subtype of Number ans is internally represented as Number

Answer 28

FLOAT

Question 29

it stores date and time information

Answer 29

date

Question 30

- stores date and time information with fractional seconds precision - fractional_seconds_precision

Answer 30

timestamp

Question 31

Equivalent to Number (p,0)

Answer 31

INTEGER

Question 32

NCHAR with max 4K bytes, no blank-padded

Answer 32

NVARCHAR2

Question 33

Base-64 string unique row address

Answer 33

ROWID

Question 34

Base-64 string index-organized table

Answer 34

UROWID

Question 35

Binary large object

Answer 35

BLOB

Question 36

locator to a large binary file outside database

Answer 36

BFILE

Question 37

the special characters allowed in identifier name are the $, _ , #

Answer 37

also do not use quotation marks on identifier name

Question 38

table and column names are ____ | - can be up to 30 characters long

Answer 38

identifiers

Question 39

the existing data in the table is validated to verify that it conforms to the constraint.

Answer 39

Enable validate

Question 40

This does not validate the existing data but enables the constraint for future constraint checking

Answer 40

Enable Novalidate

Question 41

The constraint id disable but the constraint is kept valid

Answer 41

Disable Validate

Question 42

the constraint is disabled and no checks are done on or future or existing data

Answer 42

Disable novalidate

Question 43

index in the form of a balanced tree

Answer 43

B-tree index

Question 44

- each bit position represents a row that may or may not contain the indexed value - best for low-cardinality column

Answer 44

bitmap index

Question 45

is a structure associated with tables used to speed up the queries

Answer 45

index