Installing Oracle Part 1

Front 1

The physical files that reside on the system and the logical pieces such as the database schema are called?

Back 1

Database

Front 2

This is the method used to access the data and consists of processes and system memory?

Back 2

instance

Front 3

The physical layer of the database consists of these 3 file types?

Back 3

data files, redo log files, control files.

Front 4

This information is used in the event of a system failure to reapply changes that have been made and committed, but that might not have been made to the datafiles.

Back 4

redo log files

Hint 4

If this info is lost, you cannot recover the system.

Front 5

One or more of these contain information used to start an instance, such as the location of datafiles and redo log files.

Back 5

control files

Hint 5

Every time the system is modified, it is recorded here.

Front 6

One or more store the information contained in the database.

Back 6

datafiles

Hint 6

The information for a single table can span many of these or many tables can share a set.

Front 7

The logical layer of the Oracle Database consists of?

Back 7

tablespace and database schema

Front 8

consists of items such as tables, clusters, indexes, views, stored procedures, database triggers, sequences, and so on

Back 8

database schema

Front 9

is divided into one or more logical pieces known as this?

Back 9

tablespace

Hint 9

used to logically group data together

Front 10

Contains information about tables, indexes, clusters, etc.

Back 10

data dictionary

Front 11

Tablespace where the data dictionary is kept?

Back 11

system

Front 12

consist of structures such as tables, clusters, indexes, views, stored procedures, database triggers, and sequences.

Back 12

schema objects

Front 13

Consists of name and rows and columns of data, is the basic logical storage unit in the Oracle database?

Back 13

table

Hint 13

is stored within a tablespace; often, many of these share a tablespace.

Front 14

Set of tables physically stored together as one table that shares a common column.

Back 14

cluster

Hint 14

Because of the structure of this, related data requires much less I/O overhead if accessed simultaneously.

Front 15

Structure created to help retrieve data more quickly and efficiently

Back 15

index

Hint 15

is declared on a column or set of columns.

Front 16

A window into one or more tables. It does not store any data; it presents table data.

Back 16

view

Hint 16

can be queried, updated, and deleted as a table without restriction.

Front 17

predefined SQL query that is stored in the data dictionary designed to allow more efficient queries

Back 17

stored procedures

Hint 17

can reduce the amount of information that must be passed to the RDBMS and thus reduce network traffic and improve performance.

Front 18

a procedure that is run automatically when an event occurs.

Back 18

trigger

Front 19

The space used to store data is controlled by the use of these 3 logical structures?

Back 19

data blocks, extents, segments

Front 20

This data structure consists of data blocks and is used to minimize the amount of wasted (empty) storage?

Back 20

extents

Hint 20

As more and more data is entered, the number of extents used to store that data can grow or shrink as necessary

Front 21

This data structure is a set of extents used to store a particular type of data?

Back 21

segments

Front 22

The smallest unit of storage in an Oracle database.

Back 22

data blocks

Hint 22

in most systems is 2KB

Front 23

List the 4 types of segments

Back 23

data, index, rollback, temporary

Front 24

This consists of the Oracle processes, including user and background processes, and shared memory necessary to access information in the database.

Back 24

instance

Front 25

The 2 basic memory structure associated with Oracle are?

Back 25

sga and pga

Front 26

shared memory region used to store data and control information for one Oracle instance.

Back 26

sga

Hint 26

is allocated when the Oracle instance starts and is deallocated when the Oracle instance shuts down

Front 27

The information in the SGA consists of these three elements?

Back 27

database buffer cache, redo log buffer and shared pool.

Front 28

Stores a log of changes made to the database. It is used for instance recovery in the event of a system failure.

Back 28

redo log buffers

Front 29

stores the most recently used data blocks

Back 29

database buffer

Hint 29

can contain dirty data blocks, clean blocks or blocks that have not been modified

Front 30

modified data that has not yet been written to disk is referred to as? Blocks that have been written to disk since modification are?

Back 30

dirty data blocks, clean blocks