当前分类： 1Z0-032
问题：多选题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.DTh...
查看答案
问题：单选题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 strat...
问题：单选题The Oracle Net architecture is based on which of the following？（）A OCIB OSIC TCP/IPD SNMP...
问题：单选题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...
问题：You configured automatic archive logging for the database. O...
问题：单选题What is the maximum database block size supported for the Oracle9i database？（）A 16KBB 32KBC 64KBD 128KB...
问题：多选题You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）ANOCHECKSUMBMAXCORRUPTCCH...
问题：单选题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 tran...
问题：单选题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 belo...
问题：单选题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 upd...
问题：单选题While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）A ARCnB CKPTC DBWnD LGWRE PMONF SMON...
问题：单选题You can control instance recover performance by setting parameters to define targets for（）A The size of the redo buffer in SGA. B The instance that will perform recovery in Real Application Cluster database. C The number of blocks to be read during ins...
问题：单选题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...
问题：单选题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 inva...
问题：单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A A text copy of the control file.B A binary copy of the control file.C A file containing a SQL statement which will re-create the database.D A fil...
问题：单选题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...
问题：多选题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 be...
问题：单选题The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（） 1. Shot down and start up the former primary instance wi...
