问题：单选题Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）A Rebuild the index using the online option. B Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
查看答案
问题：单选题Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）A Restore the data file for the SYSTEM tablespace then open the database. B Restore all redo logs form last night's backup, then restart the database. C Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. D Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
问题：单选题Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）A ROWSB SKIPC LOADD BINDSIZE
问题：单选题You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types？（）A ADDRESS_LISTB SID_NAMEC LISTENERD SERVICE_LIST
问题：单选题What is the maximum database block size supported for the Oracle9i database？（）A 16KBB 32KBC 64KBD 128KB
问题：单选题What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）A It is NOT possible to switch unless no active transaction exist in UNDO1. B It is possible to switch to UNDO2； but current active transactions will abort. C It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. D It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.
问题：单选题Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）A RESTORE DATAFILE ’/DISK2/user_data01.dbf’B RESTORE DATAFILE ’/DISK3/user_data01.dbf’C SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’D SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
问题：单选题In user-managed backup and recover procedures， how are data files backed up？ （）A Using SQL commands.B Using SQL*Plus commands.C Using operating system commands.D Using Recover Manager commands.
问题：单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）A Only bring the tablespace back online.B Only recover the tablespace and then bring the tablespace back online.C Shut down the database， recover the data file and then start up the database.D Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.E Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
问题：多选题Which four occur during the processing of a request using Oracle Shared Server？（）AThe dispatcher returns the response to the user.BThe dispatcher places the request into the request queue.CThe shared server places the response in the response queue.DThe response is handed off to the next available dispatcher.EA shared server picks up the request from the request queue and processes the request.
问题：单选题The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）A Only MEMORY is updated.B Only SPFILE values are updated.C Only init.ora parameters are updated.D Both init.ora parameters and SPFILE values are updated.
问题：单选题You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45， which is needed to perform complete recovery， is invalid. You then begin incomplete recovery-You receive this prompt： ORA-00279：change 309012...03/09/01 11：33：56 needed for thread ORA-00289： suggestion ： /disk1/archive/arch_45.rdo ORA-00280： change 309012 for thread 1 is in sequence #45 Specify log： {=suggested | filename | AUTO | CANCEL} What is the correct response？（）A Enter the keyword AUTO.B Enter the keyword CANCEL.C Press the Enter or Return key.D Provide the filename ’/disk1/archive/arcg_46.rdo’
问题：多选题Which three types of information does the control file contain？（）ACurrent log sequence.BRecover tuning parameters.CRedo log names and locations.DData file names and locations.EUndo segment names and locations.
问题：单选题The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）A mediaB instanceC statementD user process
问题：单选题Which of the following commands cannot be executed when the database open？（）A RECOVER DATABASEB RECOVER TABLESPACEC RECOVER DATAFILED ALTER DATABASE RECOVER DATAFILE
问题：多选题Oracle Net is responsible for establishing and maintaining the connection between the client application and the server. On the client side， Oracle Net is responsible for which three connectivity issues？（）AThe location of the server.BThe Oracle user being connected.CPrivileges and role information.DProtocol involved in the connection.EHow to handle exceptions and interrupts.
问题：单选题Which script must you to query to display the code associated with RMAN stored scripts？（）A RC_STORED_SCRIPTB RC_STORED_SCRIPT_LINEC RC_SCRIPTSD RC_STORED_LINE_SCRIPTE None of the other alternatives apply
问题：多选题Some data storage and transfer media have fixed-length physical records. When the data records are short， more then one can be stored in a single， physical record to use the storage space efficiently. Consider this data： 1119 Smith 1120 Yvonne 1121 Albert 1130 Thomas Which two statements can you use to load the data into the EMP table？（）AABBCCDD
问题：多选题Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）ASYNC or ASYNC to identify the network transmission mode.BLGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.CAFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.DPROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
问题：多选题Which two SQL*Loader instructions are used to assemble logical records？（）AWHENBINFILECCONTINUEIFDCONCATENATEETRAILING NULLCOLS
