Oracle 大数据库考试重点

1、Which two statements about online redo log members in a group is true?

B、All members in a group are the same size

C、The members should be on different disk drivers

2、Which command does a DBA user to list the current status of archiving?

A、ARCHIVE LOGLIST

3、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 disks

5、When you create a control file, the database has to be:

C Open

6、Which data dictionary view shows that the database 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 processes can be associated with an instance? C ten

10、Whichtwo parameters cannot be used together to specify the archive destination?

A．LOG_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 crash? C immediately after re-opening the database before the recovery

3、The data dictionary tables and views are stored in

B、SYSTEM tablespace

4 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 directory, row directory and data block header

6 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 the first sort operation

9 Which of the following segments is self administered?

B ROLLBACK

10 What is the default temporary tablespace, if no temporary tablespace is defined? D SYSTEM

11 Rollback segments are used for: D ，all of the above

12 Rollback segment stores:

A old values of the data changed by each transaction

第八章

1 An Oracle instance is : D All of the above

2 The SGA consists of the following items:

D All of the above

3 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 of the following is valid background server processes in Oracle?

D All of the above

6 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 above

8 Oracle does no consider a transaction committed until:

B The LGWR successfully writes the changes to redo

9 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 be 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 database