Oracle 8 - Building Databases Part 1

Front 1

this contains system rollback segment, the data dictionary, stored procedures, and other structures necessary to run the Oracle instance.

Back 1

system tablespace

Front 2

which log files need to be protected most on a Oracle Server?

Back 2

redo and archive

Front 3

The maximum size of a oracle 8 datafile is?

Back 3

32gb

Front 4

The maximum number of datafiles per tablespace is

Back 4

1022

Front 5

The maximum size of a tablespace is

Back 5

32T

Front 6

When planning your database, you must allow enough space for datafiles and for what other data component?

Back 6

indexes

Front 7

These files sequentially accessed log files should be isolated from randomly accessed files in order to increase performance?

Back 7

redo and archive

Front 8

Which type of data should be isolated in the database?

Back 8

Sequentially accessed

Front 9

A oracle system Primarily queries and the database layout favors datafiles is?

Back 9

DSS

Front 10

a system that does a Large number of updates and Continuously creates archive files is characteristic of?

Back 10

OLTP

Front 11

RAID-5 is also known as?

Back 11

data guarding

Front 12

This is the fastest fault-tolerant method and offers the most protection. It is, however, the most costly?

Back 12

RAID 1

Front 13

This fault tolerent method is very fast for reading, but write performance is degraded. It is typically too slow for the redo log files, which need fast write access.

Back 13

raid 5

Hint 13

can be acceptable for datafiles and possibly for the archive log files.

Front 14

It is a good idea to put your operating system and redo log files on what kind of volume?

Back 14

raid 1

Front 15

Typically, the archive log files do not require fast performance and can reside on what kind of volume?

Back 15

raid 5

Front 16

What can be used in conjunction with archive log files and a recent backup to recover a database to the point of system failure?

Back 16

redo log

Front 17

When you create a database using a SQL script, you first need to create a?

Back 17

sql script

Front 18

When creating a database using Oracle Server Manager, the log file parameter is followed by the log-file name, which specifies the name of the?

Back 18

redo log

Front 19

This is a set of tables Oracle uses to maintain information about the database, including information about tables, indexes, clusters, and so on.

Back 19

data dictionary

Front 20

After the oracle database has been created, what two scripts should be run to create the data dictionary views?

Back 20

catalog.sql and catproc.sql

Front 21

Which Oracle SQL script creates many of the views used by the system and by the DBA?

Back 21

catalog.sql

Front 22

This script sets up the database for the procedural option along with scripts that set permissions, insert stored procedures into the system, and load a number of packages into the database.

Back 22

catproc.sql

Front 23

This SQL script a)Creates many views used by the system and the DBA, b)Creates synonyms and grants, c)Creates the V$ tables

Back 23

catalog.sql

Front 24

This SQL script a)Sets up the database for the procedural option, b)Runs other SQL scripts

Back 24

catproc.sql

Front 25

using this install method the NT bootstrap instance, database, and SYSTEM tablespace are created, and the CATALOG.SQL and CATPROC.SQL scripts are automatically executed.

Back 25

Database Assistant

Hint 25

It's a GUI install

Front 26

What does Advanced replication do using the Oracle Database Assistant install method?

Back 26

default users and stored procedure packages will be added.

Front 27

A block size of 2,048 is usually appropriate for which type of application?

Back 27

oltp

Front 28

To create the data dictionary views when using the Database Assistant, you must also run SQL scripts.

Back 28

false

Front 29

The open parameter opens the database for normal use. Optionally, you can specify the additional parameter?

Back 29

RESETLOGS or NORESETLOGS

Front 30

What is the parameter that is essential for data recovery in the event of media failure?

Back 30

archivelog

Front 31

Complete the command that is used to alter the database dogs so that it runs in ARCHIVELOG mode.

ALTER DATABASE

Back 31

dogs archivelog;

Front 32

Enter the command to open a closed database named cats

Back 32

alter database cats open;

Front 33

To make sure you are not running out of space, you can use

Back 33

storage manager utility

Hint 33

a subset of Enterprise Manager