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 LOGLIST3、How many control files are required to create a database?A、one4、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 Open6、Which data dictionary view shows that the database is in ARCHIVELOG mode? C、V$DATABASE7、What is the biggest advantage of having the control files on different disks? B Guards against failure8、Which file is used to record all changes made to the database and is used only when performing an instance recovery? A，Archive log file9、How many ARCn processes can be associated with an instance? C ten10、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、TABLESPACE2 When will the rollback information applied in the event of a database crash? C immediately after re-opening the database before the recovery3、The data dictionary tables and views are stored inB、SYSTEM tablespace4 PCTFREE and PCTUSED together should not exceed:A 1005 Which of the following three portions of a data block are collectively called as Overhead?C table directory, row directory and data block header6 When the database is open , which of the following tablespace must be online? A，SYSTEM7 Sorts can be managed efficiently by assigning _____ tablespace to sort operations B TEMPORARY8 The sort segment of temporary tablespace is created:A at the time of the first sort operation9 Which of the following segments is self administered?B ROLLBACK10 What is the default temporary tablespace, if no temporary tablespace is defined? D SYSTEM11 Rollback segments are used for: D ，all of the above12 Rollback segment stores:A old values of the data changed by each 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 Cache4 Which of the following is not a background server processes in Oracle?B LGWR5 Which 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 DBWR7 The process that records information about the changes made by all transactions that commit is :D None of the above8 Oracle does no consider a transaction committed until:B The LGWR successfully writes the changes to redo9 The process that performs internal operations like tablespacecoalescing is :B SMON10 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 NOMOUNT2 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 toB DBA, who perform structural maintenance exports and imports the data4 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 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 ABORT6 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, MOUNT, 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.sql9 In order to perform a full media recovery, the Database must be :C Mounted and Opened using ARCHIVELOG option10 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 user2 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_TIME4 Which of the following statements is incorrect when used with ALTER USER usera? A 、ADD QUOTA 5M5 What view consists information about the resource usage parameters for each profile? B、DBA_PROFILES6 Which of the following is not a system privilege?A SELECT7 What keyword during the create user command, limits the space used by users objects in the database? D QUOTA8 What operations are limited by the Quota on a tablespace? D All of the above9 Profiles cannot be used to restrict which of the following? D time spent reading blocks10 Which of the following is not a role?D CREATE SESSION第十三章1 What option of Exporting allows quicker data extractions? D、Direct = y2 How are exports useful? C Can be used to recover dropped tables due a user error3 What are the 3 levels of Exports?B FULL, USER, TABLE4 The following methods can be used to run exports:D all of the above5 Which of the following are valid parameters for an Export utility? DAll of the above6 What Incremental Parameters can be used with exports?D all of the above7 What can you do to reduce the burden on a rollback segment during the import of a large table?C、COMMIT= Y8 What is an Incremental Export?B Export of rows that have changed since last export9 An Incremental Export is a good strategy for:C all of the aboveD none of the above10 What is a Cumulative Export? A Export of the objects that have changed since last export11 What option of export utility allows for faster extraction of data? B DIRECT = Y简答题：1，为EXAMPLE表空间添加一个数据文件，文件名为example02.dbf,大小为20MB.ALTER TABLESPACE EXAMPLE ADD DATAFILE‘D:\ORACLE\ORADATA\ORCL\example02.dbf’ SIZE 20M’;2，修改USERS表空间中的userdata03.dbf为自动扩展方式，每次扩展5MB，最大为100MB。