Oracle DBA创建数据库试题选Word文档下载推荐.docx
《Oracle DBA创建数据库试题选Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《Oracle DBA创建数据库试题选Word文档下载推荐.docx(15页珍藏版)》请在冰豆网上搜索。
saving
file
At
first
CHECKPOINT
paramter
DBWR
finishes
writing
all
dirty
buffers
to
disk
next
instance
startup
4
3
ALTER
SYSTEM
DEFFERED
command
modifies
global
parameters
for
existing
sessions
certain
amount
time
new
only
and
depends
on
SPIN_COUNT
initialization
2
4
The
location
where
debugging
trace
files
back
ground
processes
are
written,
is
specified
by
LOGFILE_DEST
ORACLE_HOME
BACKGROUND_DUMP_DEST
CORE_DUMP_DEST
5
In
case
heavy
contention
latches,set
LOG_SIMULTANEOUS_COPIES
Twice
number
CPUs
Same
as
DB
Block
Buffers
Shared
Pool
Size
None
above
6
What
step
manually
creating
database
Startup
an
Start
SQL*Plus
connect
Oracleas
SYSDBA
Check
identifier
your
system
Create
7
Which
following
true
regarding
control
Oracle
recommeds
atleast
two
stored
separate
disks
one
store
One
not
enough
run
1
8
Tom
created
with
DB_BLOCK_SIZE
2k,
he
wants
increase
this
4k,
what
his
1.
Issue
SET
DB_BLOCK_SIZE=4k
recreate
setting
It
can
be
done
both
ways
cannot
4k
9
Howmany
rollback
segments
required
apart
from
segment
start
just
Needs
before
it
Temp
Rollback
Segment
10
unit
measurement
intialization
BLOCKS
BYTE
PAGE
ROW
11
tablespace
must
ROLLBACK
TOOLS
TEMP
12
determines
used
byOracle
ROLLBACKS
LOGFILE
GROUP
ROLLBACK_SEGMENTS
DBA_ROLLBACK_SEGS
13
valid
but
undocumented
Oracle
_CORRUPT_RBS
_CORRUPT_REDO
_CORRUPT_ROLLBACK_SEGMENTS
oracledba数据库结构试题精选
q.1:
physicaldiskresourcesinanoracledatabaseare
1.controlfiles
2.redologfiles
3.datafiles
4.alloftheabove
4
q.2:
whatisaschema
1.aphysicalorganizationofobjectsinthedatabase
2.alogicalorganizationofobjectsinthedatabase
3.aschemeofindexing
4.noneoftheabove
2
q.3:
anoracleinstanceis
1.oraclememorystructures
2.oraclei/ostructures
3.oraclebackgroundprocesses
q.4:
thesgaconsistsofthefollowingitems
1.buffercache
2.sharedpool
3.redologbuffer
q.5:
theareathatstorestheblocksrecentlyusedbysqlstatementsis
1.sharedpool
2.buffercache
3.pga
4.uga
q.6:
whichofthefollowingisnotabackgroundserverprocessinanoracle
1.dbwriter
2.dbreader
3.logwriter
4.smon
q.7:
whichofthefollowingisavalidbackgroundserverprocessesinoracle
1.archiver
2.lgwr(logwriter)
3.dbwr(dbwriter)
q.8:
theprocessthatwritesthemodifiedblockstothedatafilesis
1.dbwr
2.lgwr
3.pmon
1:
oracledoesnotmodifythedataindatafile.oncetheserverprocess
makesachangeinthememory,dbwrwritesthemodifiedblocksbacktodisk.
q.9:
theprocessthatrecordsinformationaboutthechangesmadebyall
2.smon
3.ckpt
4:
lgwrprocessrecordstheinformationaboutchangestodatabase
q.10:
oracledoesnotconsideratransactioncommitteduntil
1.thedataiswrittenbacktothediskbydbwr
2.thelgwrsuccessfullywritesthechangestoredo
3.pmonprocesscommitstheprocesschanges
4.smonprocesswritesthedata
q.11:
theprocessthatperformsinternaloperationsliketablespace
1.pmon
3.dbwr
4.arch
q.12:
theprocessthatmanagestheconnectivityofusersessionsis
3.serv
4.net8
1
q.13:
thearchprocessisenabledwhenthedatabaserunsina
1.parallelmode
2.archivelogmode
3.noarchivelogmode
q.14:
whatperformsthecheckpointintheabsenceofackptprocess
2:
atacheckpointdbwrwritesalldatatodatafilesfrommemory.atthis
timethedatafileheadershavetobeupdatedbylgwrintheabsenceofackpt
q.15:
ifanapplicationrequestsdatathatisalreadyinthememory,itis
1.cacheread
2.cachehit
3.cachemiss
4.cachelatch
q.16:
ifthedatarequestedisinthememorybuthadtobereloadeddueto
1.cachehit
2.cacherefresh
3.cachereload
3
q.17:
ifthedatarequestedisnotintheserversmemory,itisreferredto
1.cachedisk
2.cachemiss
3.cacheread
q.18:
youcandynamicallyresizethefollowingparametersinthesga
2.librarycache
3.dictionarycache
q.19:
thememoryareathatstorestheparsedrepresentationofmost
q.20:
themostrecentlyuseddatadictionaryinformationisstoredin
1.datadictionarycache
2.sharedcache
3.buffercache
q.21:
theservermemorythatholdssession-specificinformationisreferred
1.programorprivateglobalarea
2.sessionglobalarea
3.tempspace
q.22:
theareaofmemoryusedbytheserverastemporaryareaforsorting
1.tempspace
2.sortarea
3.redobuffer
4.sortbuffer
q.23:
thefundamentalunitofstorageinadatafileis
1.byte
2.bit
3.block
q.24:
theprocessthatresolvesthein-doubttransactionsinadistributed
1.arch
2.proc
3.reco
q.25:
thesizeofeachbufferinthedatabaseissetusingthisparameter
1.db_block_buffers
2.db_block_size
3.db_byte_size
q.26:
thenumberofblockbuffersinthedatabaseissetintheinit.ora
1.db_block_size
2.db_block_buffers
3.db_buffer_cache
q.27:
theparameterthatsetsthesizeofthesharedsqlareais
1.shared_sql_area
2.shared_pool_size
3.shared_cache_size
4.noneoftheabove
OracleDBA启动和关闭例程试题选
Q.1:
TheDatabasemustbeinthismodefortheinstancetobestarted
1.MOUNT
2.OPEN
3.NOMOUNT
4.None
Q.2:
WhenOraclestartupsup,whathappensifadatafileorredologfilenotavailableorcorruptedduetoO.SProblems
1.Oraclereturnsawarningmessageandopensthedatabase
2.Oraclereturnsawarningmessageanddoesnotopenthedatabase
3.Oraclereturnsawarningmessageandstartsthedatabaserecovery
4.Oracleignoresthosefilesandfunctionsnormally
Q.3:
TheRESTRICTEDSESSIONsystemprivilegeshouldbegivento
1.Users,whoneedextrasecuritywhiletransferingthedatabetweenclientandtheserverthroughSQL*NETorNET8.
2.DBAs,whoperformstructuralmaintenanceexportsandimportsthedata.
3.Alloftheabove
4.Noneoftheabove
Q.4:
WhenStartingupadatabase,IfoneormoreofthefilesspecifiedintheCONTROL_FILESparameterdoesnotexist,orcannotbeopened
1.Oraclereturnsawarningmessageanddoesnotmountthedatabase
2.Oraclereturnsawarningmessageandmountsthedatabase
3.Oracleignoresthosefilesandfunctionsnormally
4.Oraclereturnsawarningmessageandstartsdatabaserecovery
Q.5:
Bobtriedtoshutdownnormal,Oraclesaiditwasunavailable,andwhenhetriedtostarup,oraclesaidthatitwasalreadystarted.Whatisthebestmodethatbobcanusetoforceashutdownontheserver
1.NORMAL
2.ABORT
3.IMMEDIATE
4.NONE
Q.6:
Tomissuedacommandtostartupthedatabase.WhatmodesdoestheInstanceandDatabasepassthroughtofinallyhavethedatabaseopen
1.OPEN,NOMOUNT,MOUNT
2.NOMOUNT,MOUNT,OPEN
3.NOMOUNT,OPEN,MOUNT
4.MOUNT,OPEN,NOMOUNT
Q.7:
Dianeisanewdbaandissuedashutdowncommandwhileherserverisbeingused.Afterawhileshefiguresthatoracleiswaitingforalltheuserstosignoff.Whatshutdownmodedidsheuse
3.IMME