Info Task

1. changes to data are written to datafile by the ___ background process

lgwr

ldwr

dfwn

dbwn

2. SHUTDIWN____waits for all users to log off prohibits new connection

normal

transactional

immediate

abort

3. a data block is typically___

4kb

8kb

16kb

32kb

4. a file is an adminstrative file containg up to date information on the data structure log files checkpoints, critical file for opening the database

redo log

datafile

control

tablespace

5. a___ is a physicalfile on the computer desk containing data,as tables and index

redo log

data file

control

tablespace

6. startup__ starts up all the background and allociated space in the memory for all orcale dtabase instance memory buffers

nomount

mount

open

7. shutdown automatically shutdown_____ simply stops oecale prosserros and all memory buffers

normal

transactional

immedate

abort

8. the database is___ mode automatically node log files

redolog

log

archiveredolog

archivelog

9. the prefixes _____ is used for dynamic performance views

users

all

dba

v$

10.the binary parameter file is used in the startup command by default and is loacted by default in the _____/databse directory

orcacle_HOME

orcacle_base

home

base

11._____ views provide system related information by querying the database internal mangment tables and presenting the data as views (metadata view

managed files

storage manager

ofa

data dictionary

12.to log on to SQL*plus with sydba privelages using the os authecation method you can type the following command line ___________

sqlplus/sys

sqlplus/nolog

sqlplus/dba

sqlplus/admin

13._____________means making reduandant copies of files to gurantee that if the oringal file is dmge another can take its place

splitting

replicating

multiplexing

rollbacking

14.the ___________tool guides you through database setuo and creation using windows with instruction for each step

DBCA

SQL*plus

Omf

OFA

15.to startup the database you can use the sql plus _______command

startuo start

init

run

16.a databse in_________ mode automatically archives redo log files

redolog

log

archiveredolog

archivelog

17.____________mode retricts acess to a database to adminstration level only

nomount

mount

safe

admin

18.To shutdown the database you can use the SQL *plus _________command

SHutdown

end

exit

quit