Oracle数据库考试重点.docVIP

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 defin