OracleDBA數(shù)據(jù)庫(kù)結(jié)構(gòu)試題選一

1、OracleDBA 數(shù)據(jù)庫(kù)結(jié)構(gòu)試題選一OracleDBA數(shù)據(jù)庫(kù)結(jié)構(gòu)試題選一OracleDBA數(shù)據(jù)庫(kù)結(jié)構(gòu)試題 選一 q. 1 : physical disk resources in an oracle database are1.con trol files2. redo log files3. data files4. all of the above4q. 2 : what is a schema1. a physical orga ni zati on of objects in the database2. a logical orga ni zati on of objects in

2、 the database3. a scheme of in dex ing4. none of the above2q. 3 : an oracle in sta nee is1. oracle memory structures2. oracle i/o structures3. oracle backgro und processes4. all of the aboveq. 4 : the sga con sists of the followi ng items1. buffer cache2. shared pool3. redo log buffer4. all of the a

3、bove4q. 5 : the area that stores the blocks rece ntly used by sql stateme nts is called1. shared pool2. buffer cache3. pga4. uga2serverq. 6 : which of the following is not a background process in an oracle server1. db writer2. db reader3. log writer4. smon2q. 7 : which of the follow ing is a valid b

4、ackgro und serverprocesses in oracle1. archiver2. Igwr ( log writer )3. dbwr ( dbwriter )4. all of the above4q. 8 : the process that writes the modified blocks to the data files is1. dbwr2. lgwr3. pmon4. smon1 : oracle does n ot modify the data in data file. once the server process makes a cha nge i

5、n the memory, dbwr writes the modified blocks back to disk.theq. 9 : the process that records informationaboutcha nges made by all tran sacti ons that commit is1. dbwr2. smon3. ckpt4. none of the above4 : lgwr process records the in formati on about cha ngesto databaseq. 10 : oracle does n ot con si

6、der a tran sacti on committeduntil1. the data is writte n back to the disk by dbwr2. the lgwr successfully writes the cha nges to redo3. pmon process commits the process cha nges4. smon process writes the data2q. 11 : the process that performs in ternal operati ons like tablespace coalesc ing is1. pmon2. smon3. dbwr4. arch2q. 12 : the process that man ages the conn ectivity of usersessi ons is1. pmon2. smon3. serv4. net81q. 13 : the arch process is enabled when the databaseruns