1Z0-032 题目列表
单选题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？（）AOnly bring the tablespace back online.BOnly recover the tablespace and then bring the tablespace back online.CShut down the database， recover the data file and then start up the database.DIssue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.ERecover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
单选题What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）AIt is NOT possible to switch unless no active transaction exist in UNDO1. BIt is possible to switch to UNDO2； but current active transactions will abort. CIt is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. DIt is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.
单选题What is the maximum database block size supported for the Oracle9i database？（）A16KBB32KBC64KBD128KB
多选题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.
单选题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？（）ARestore the data file for the SYSTEM tablespace then open the database. BRestore all redo logs form last night's backup, then restart the database. CPerform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. DMount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
单选题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？（）AmediaBinstanceCstatementDuser process
单选题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？（）ARebuild the index using the online option. BTake 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. CWithout setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. DTake 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.
多选题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？（）AOnly MEMORY is updated.BOnly SPFILE values are updated.COnly init.ora parameters are updated.DBoth init.ora parameters and SPFILE values are updated.
单选题You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types？（）AADDRESS_LISTBSID_NAMECLISTENERDSERVICE_LIST
多选题Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）AGrand privileges on the interim table.BInvoke the dbms_redefinition.can_redef_table procedure.CInvoke the dbms_redefinition.sync_interim_table procedure.DCreate any triggers， indexes， or constraints on the interim table.ECreate an empty interim table with all the desired characteristics.
单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）AOnly the damaged or lost data files.BAll of the data files of the database.COnly the data files belonging to the SYSTEM tablespace.DThe data files belonging to the SYSTEM tablespace and the damaged or lost data files.
单选题You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）ARCO1 only.BDB01 only.CDB02 only.DDB01 and DB02 only.EDB01，DB02，and RC01.
多选题Which two statements are true regarding the use of UTF-16 encoding？ （）AEnables easier loading of multinational data.BUses a fixed-width Multibyte encoding sequence.CAsian characters are represented in three characters.DUsed a variable-width Multibyte encoding sequence.EEuropean characters are represented on one or two bytes.
单选题Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）AV$DATAFILEBV$TEMPFILECV$DBFILEDV$DATAFILE_HEADER