Oracle DBA创建数据库试题选.doc

Oracle DBA创建数据库试题选Q.1:Thissymbol,Whenyouputinfrontofalineintheparameterfile,signifiesacomment 1.$ 2. 3.# 4.! 3 Q.2:Whenyouchangeaparametervalueintheparameterfile,whenwillthatchangetakesaffect? 1.Immediatelyaftersavingtheparameterfile 2.AtthefirstCHECKPOINTaftersavingtheparamterfile 3.WhentheDBWRfinisheswritingallthedirtybufferstothedisk 4.Atthenextinstancestartup 4 Q.3:ALTERSYSTEMDEFFEREDcommandmodifiestheglobalparametersfor 1.existingsessionsafteracertainamountoftime 2.newsessionsonly 3.existingandnewsessions 4.dependsontheSPIN_COUNTinitializationparameter 2 Q.4:Thelocationwheredebuggingtracefilesforbackgroundprocessesarewritten,isspecifiedby 1.LOGFILE_DEST 2.ORACLE_HOME 3.BACKGROUND_DUMP_DEST 4.CORE_DUMP_DEST 3 Q.5:Incaseofheavycontentionforlatches,settheLOG_SIMULTANEOUS_COPIESinitializationparameterto 1.TwicethenumberofCPUs 2.SameastheDBBlockBuffers 3.SameastheSharedPoolSize 4.Noneoftheabove 4 Q.6:Whatisthefirststepinmanuallycreatinganewdatabase 1.Startupaninstance 2.StartSQL*PlusandconnecttoOracle asSYSDBA 3.Checktheinstanceidentifierforyoursystem 4.Createaparameterfile 4 Q.7:Whichofthefollowingistrueregardingcontrolfiles 1.Oraclerecommedsatleasttwocontrolfilesstoredontwoseparatedisks 2.Oraclerecommedsatleasttwocontrolfilesstoredononedisk 3.Oraclerecommedstostoreonecontrolfile 4.Onecontrolfileisnotenoughtorunadatabase 1 Q.8:TomcreatedadatabasewithaDB_BLOCK_SIZEof2k,hewantstoincreasethisto4k,whatishisnextstep 1.IssueALTERSYSTEMSETDB_BLOCK_SIZE=4kcommand 2.recreatethedatabasewiththenewsetting 3.Itcanbedoneinboththeways 4.theDB_BLOCK_SIZEcannotbe4k 2 Q.9:HowmanyrollbacksegmentsarerequiredforOracletostartupapartfromSYSTEMrollbacksegment 1.Oraclecanstartwithjustthesystemrollbacksegment 2.OracleNeedsatleast3rollbacksegmentsbeforeitcanstart 3.OracleNeedsaTempRollbackSegmentbeforeitcanstart 4.Noneoftheabove 1 Q.10:TheunitofmeasurementforDB_BLOCK_SIZEintializationparameteris 1.BLOCKS 2.BYTE 3.PAGE 4.ROW 2 Q.11:Thistablespaceisamustbeforeyourunthedatabaseinstance 1.ROLLBACK 2.TOOLS 3.TEMP 4.SYSTEM 4 Q.12:Whichinitializationparameterdeterminestherollbacksegmentsthatcanbeusedby Oracle 1.ROLLBACKS 2.LOGFILEGROUP 3.ROLLBACK_SEGMENTS 4.DBA_ROLLBACK_SEGS 3 Q.13:WhichofthefollowingisavalidbutundocumentedparameterinOracle 1._CORRUPT_RBS 2._CORRUPT_REDO 3._CORRUPT_ROLLBACK_SEGMENTS 4.Noneoftheabove 3oracle dba数据库结构试题精选q. 1 : physical disk resources in an oracle database are 1. control files 2. redo log files 3. data files 4. all of the above 4 q. 2 : what is a schema 1. a physical organization of objects in the database 2. a logical organization of objects in the database 3. a scheme of indexing 4. none of the above 2 q. 3 : an oracle instance is 1. oracle memory structures 2. oracle i/o structures 3. oracle background processes 4. all of the above 4 q. 4 : the sga consists of the following items 1. buffer cache 2. shared pool 3. redo log buffer 4. all of the above 4 q. 5 : the area that stores the blocks recently used by sql statements is 1. shared pool 2. buffer cache 3. pga 4. uga 2 q. 6 : which of the following is not a background server process in an oracle 1. db writer 2. db reader 3. log writer 4. smon 2 q. 7 : which of the following is a valid background server processes in oracle1. archiver 2. lgwr ( log writer ) 3. dbwr ( dbwriter ) 4. all of the above 4 q. 8 : the process that writes the modified blocks to the data files is 1. dbwr 2. lgwr 3. pmon 4. smon 1 : oracle does not modify the data in data file. once the server process makes a change in the memory, dbwr writes the modified blocks back to disk. q. 9 : the process that records information about the changes made by all 1. dbwr 2. smon 3. ckpt 4. none of the above 4 : lgwr process records the information about changes to database q. 10 : oracle does not consider a transaction committed until 1. the data is written back to the disk by dbwr 2. the lgwr successfully writes the changes to redo 3. pmon process commits the process changes 4. smon process writes the data q. 11 : the process that performs internal operations like tablespace 1. pmon 2. smon 3. dbwr 4. arch 2 q. 12 : the process that manages the connectivity of user sessions is 1. pmon 2. smon 3. serv 4. net8 1 q. 13 : the arch process is enabled when the database runs in a 1. parallel mode 2. archive log mode 3. noarchivelog mode 4. none of the above 2 q. 14 : what performs the check point in the absence of a ckpt process 1. dbwr 2. lgwr 3. pmon 4. smon 2 : at a check point dbwr writes all data to data files from memory. at this time the datafile headers have to be updated by lgwr in the absence of a ckpt q. 15 : if an application requests data that is already in the memory, it is 1. cache read 2. cache hit 3. cache miss 4. cache latch 2 q. 16 : if the data requested is in the memory but had to be reloaded due to 1. cache hit 2. cache refresh 3. cache reload 4. none of the above 3 q. 17 : if the data requested is not in the servers memory, it is referred to 1. cache disk 2. cache miss 3. cache read 4. none of the above 2 q. 18 : you can dynamically resize the following parameters in the sga 1. buffer cache 2. library cache 3. dictionary cache 4. none of the above 4 q. 19 : the memory area that stores the parsed representation of most 1. buffer cache 2. library cache 3. dictionary cache 4. none of the above 2 q. 20 : the most recently used data dictionary information is stored in 1. data dictionary cache 2. shared cache 3. buffer cache 4. none of the above q. 21 : the server memory that holds session-specific information is referred 1. program or private global area 2. session global area 3. temp space 4. none of the above 1 q. 22 : the area of memory used by the server as temporary area for sorting 1. temp space 2. sort area 3. redo buffer 4. sort buffer 2 q. 23 : the fundamental unit of storage in a data file is 1. byte 2. bit 3. block 4. none of the above 3 q. 24 : the process that resolves the in-doubt transactions in a distributed 1. arch 2. proc 3. reco 4. none of the above 3 q. 25 : the size of each buffer in the database is set using this parameter 1. db_block_buffers 2. db_block_size 3. db_byte_size 4. none of the above 2 q. 26 : the number of block buffers in the database is set in the init.ora 1. db_block_size 2. db_block_buffers 3. db_buffer_cache 4. none of the above 2 q. 27 : the parameter that sets the size of the shared sql area is 1. shared_sql_area 2. shared_pool_size 3. shared_cache_size 4. none of the aboveOracle DBA 启动和关闭例程试题选Q. 1 : The Database must be in this mode for the instance to be started 1. MOUNT 2. OPEN 3. NOMOUNT 4. None 3 Q. 2 : When Oracle startups up, what happens if a datafile or redo log file not available or corrupted due to O.S Problems 1. Oracle returns a warning message and opens the database 2. Oracle returns a warning message and does not open the database 3. Oracle returns a warning message and starts the database recovery 4. Oracle ignores those files and functions normally 2 Q. 3 : The RESTRICTED SESSION system privilege should be given to 1. Users, who need extra security while transfering the data between client and the server through SQL*NET or NET8. 2. DBAs, who perform structural maintenance exports and imports the data. 3. All of the above 4. None of the above 2 Q. 4 : When Starting up a database, If one or more of the files specified in the CONTROL_FILES parameter does not exist, or cannot be opened 1. Oracle returns a warning message and does not mount the database 2. Oracle returns a warning message and mounts the database 3. Oracle ignores those files and functions normally 4. Oracle returns a warning message and starts database recovery 1 Q. 5 : Bob tried to shutdown normal, Oracle said it was unavailable, and when he tried to starup, oracle said that it was already started. What is the best mode that bob can use to force a shutdown on the server 1. NORMAL 2. ABORT 3. IMMEDIATE 4. NONE 2 Q. 6 : Tom issued a command to startup the database. What modes does the Instance and Database pass through to finally have the database open 1. OPEN, NOMOUNT, MOUNT 2. NOMOUNT, MOUNT, OPEN 3. NOMOUNT, OPEN, MOUNT 4. MOUNT, OPEN, NOMOUNT 2 Q. 7 : Diane is a new dba and issued a shutdown command while her server is being used. After a while she figures that oracle is waiting for all the users to sign off. What shutdown mode did she use 1. NORMAL 2. ABORT 3. IMMEDIATE 4. NONE 1 Q. 8 : Which script file creates commonly used data dictionary views 1. sql.bsq 2. catalog.sql 3. utlmontr.sql 4. catproc.sql 2 Q. 9 : In order to perform a full media recovery, the Database must be 1. Mounted and Opened using RESETLOG option 2. Mounted but not Opened 3. Mounted and Opened using ARCHIVELOG option 4. You cannot perform a full media recovery 2 Q. 10 : When is the parameter file read during startup 1. When opening the Database 2. When mounting the Database 3. During instance startup 4. In every stage 3 NextPageQ. 11 : What is the default mount option for an Oracle Database 1. SHARED 2. PARALLEL 3. EXCLUSIVE 4. RETRY 3 Q. 12 : You cannot start a database instance if you are connected to the database via a shared server process. 1. TRUE 2. FALSE 3. Depends on the O.S 4. Depends on the O.S and Network Protocol 1 Q. 13 : The shutdown mode that requires instance recovery at next startup is 1. NORMAL 2. ABORT 3. IMMEDIATE 4. None of the above 2 : Uncommitted transactions are not rolled back. So the instance needs recovery.Refer to Shutting Down instance. Q. 14 : Which command only mounts the database 1. STARTUP OPEN 2. STARTUP NOMOUNT 3. STARTUP FORCE 4. STARTUP MOUNT 3 Q. 15 : Which shutdown mode shuts down the instance but does not go through the dismount phase 1. NORMAL 2. ABORT 3. IMMEDIATE 4. NONE 2 Q. 16 : Which startup mode should you use to start up an instance for maintenance 1. OPEN 2. MOUNT 3. NOMOUNT 4. FORCE 2 : The database must be closed when you add, drop, rename the redo log files rename the datafiles perform full database recovery. Refer to Starting up an instance Q. 17 : Which command should you use to open a database for normal use while it is already mounted 1. ALTER DATABASE OPEN 2. ALTER SYSTEM OPEN DATABASE 3. STARTUP DATABASE 4. STARTUP OPEN 1 Q. 18 : Which shutdown mode waits for all users to disconnect before completing the shutdown 1. ABORT 2. IMMEDIATE 3. FORCE 4. NORMAL 4 Q. 19 : Which mount should you use if multiple instances will be allowed to access the database 1. RETRY 2. EXCLUSIVE 3. PARALLEL 4. NONE 3 Q. 20 : What is the fastest mode to shutdown the database 1. NORMAL 2. ABORT 3. IMMEDIATE 4. NONE 2 : The operation of writing all data in the buffers of the SGA to the datafiles and redo log files is skipped.Refer to Database and Instance Startup and Shutdown. Oracle DBA 用户管理试题选Q.1:Thedefaulttablespaceclauseinthecreateusercommandsetsthelocationfor 1.DatabaseObjectscreatedbytheuser 2.TemporaryObjectsCreatedBytheUser 3.SystemObjectsCreatedbytheuser 4.Noneoftheabove Q.2:Whatdoessessions_per_userinaresourcelimitset 1.NoofConcurrentSessionsforthedatabase 2.NoofSessionsPerUser 3.NoofProcessesPerUser 4.Noneoftheabove Q.3:Whatkeywordduringthecreateusercommand,limitsthespaceusedbyusersobjectsinthedatabase 1.Size 2.Next_Extent 3.Max_Extents 4.Quota Q.4:Whatvaluesetsthenoactivitytimeinminutesbeforeauserisdisconnected 1.IDLE_TIME 2.DISCONNECT_TIME 3.CONNECT_TIME 4.NONEOFTHEABOVE Q.5:WhatoperationsarelimitedbytheQuotaonatablespace 1.Update 2.Delete 3.Create 4.Allo