《Oracle 数据库考试重点》由会员分享,可在线阅读,更多相关《Oracle 数据库考试重点(18页珍藏版)》请在金锄头文库上搜索。
1、【精品文档】如有侵权,请联系网站删除,仅供学习与交流Oracle 数据库考试重点.精品文档.1、Which two statements about online redo log members in a group is true?B、All members in a group are the same sizeC、The members should be on different disk drivers2、Which command does a DBA user to list the current status of archiving?A、ARCHIVE LOGLIST 3
2、、How many control files are required to create a database?A、one 4、Complete the following sentence: The recommended configuration fro control files is?C Two control files on two disks5、When you create a control file, the database has to be: C Open 6、Which data dictionary view shows that the database
3、is in ARCHIVELOG mode? C、V$DATABASE 7、What is the biggest advantage of having the control files on different disks? B Guards against failure 8、Which file is used to record all changes made to the database and is used only when performing an instance recovery? A, Archive log file 9、How many ARCn proc
4、esses can be associated with an instance? C ten 10、Whichtwo parameters cannot be used together to specify the archive destination?ALOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST第七章1、A collection of segments is a (an): C、TABLESPACE 2 When will the rollback information applied in the event of a database
5、 crash? C immediately after re-opening the database before the recovery 3、The data dictionary tables and views are stored in B、SYSTEM tablespace4 PCTFREE and PCTUSED together should not exceed:A 100 5 Which of the following three portions of a data block are collectively called as Overhead?C table d
6、irectory, row directory and data block header6 When the database is open , which of the following tablespace must be online? A, SYSTEM 7 Sorts can be managed efficiently by assigning _ tablespace to sort operations B TEMPORARY 8 The sort segment of temporary tablespace is created:A at the time of th
7、e first sort operation9 Which of the following segments is self administered?B ROLLBACK 10 What is the default temporary tablespace, if no temporary tablespace is defined? D SYSTEM11 Rollback segments are used for: D ,all of the above 12 Rollback segment stores:A old values of the data changed by ea
8、ch transaction第八章1 An Oracle instance is : D All of the above2 The SGA consists of the following items:D All of the above3 The area that stores the blocks recently used by SQL statements is called: B Buffer Cache 4 Which of the following is not a background server processes in Oracle? B LGWR 5 Which
9、 of the following is valid background server processes in Oracle? D All of the above6 The process that writes the modified blocks to the data files is: A DBWR 7 The process that records information about the changes made by all transactions that commit is :D None of the above8 Oracle does no conside
10、r a transaction committed until:B The LGWR successfully writes the changes to redo9 The process that performs internal operations like tablespace coalescing is :B SMON 10 The process that manages the connectivity of user sessions is: A PMON 第十章1 The Database must be in this mode for in instance to b
11、e started: C NOMOUNT 2 When Oracle startups up , what happens if a datafile or redo file no available or corrupted due to OS Problems?B Oracle returns a warning message and does not open the database3 The RESTRICTED SESSION system privilege should be given to B DBA, who perform structural maintenanc
12、e exports and imports the data 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?A Oracle returns a warning message and does not mount the database5 Bob tried to shutdown normal, Oracle said it was unavailable, and
13、 when he tried to startup, oracle said that it was already started. What is the best mode that bob can use to force a shutdown on the server? B ABORT 6 Tom issued a command to startup the database. What modes does the Instance and Database pass through to finally have the database open? B NOMOUNT, M
14、OUNT, OPEN7 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: A NORMAL 8 Which script file creates commonly used data dictionary views? B catalog.sql 9 In or
15、der to perform a full media recovery, the Database must be :C Mounted and Opened using ARCHIVELOG option 10 When is the parameter file read during startup?C During instance startup 第十二章1 The default tablespace clause in the create user command sets the location for:A Database Objects created by the user 2 What does sessions_per_user in a resource limit set?B No. of Sessions Per User3 What value sets the no activity time before a user is disconnected? A IDLE_TIME 4 Which of