问题:单选题A client/server application has been configured to use local naming. The client and server run on separate machines. When the client tries to connect, it receives a TNS error. By carefully examining the environment, a tnsnames.ora is found only on the ...
查看答案
问题:单选题Under the Oracle Shared Server architecture, client-user processes ultimately connect to a()A serviceB listenerC dispatcherD shared server process...
问题:多选题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 pro...
问题:多选题Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file?()ACOPYBBACKUPCCHANGEDDELETEECATALOG...
问题:多选题Which three features are provided by Oracle Net Services? ()AData encryption.BUser authentication.CTransparent data conversionDConfiguration and administration mechanisms.ESupport for multiple network transport protocols....
问题:单选题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...
问题:多选题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...
问题:单选题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 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...
问题:单选题What is the maximum database block size supported for the Oracle9i database?()A 16KBB 32KBC 64KBD 128KB...
问题:单选题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 have just run this syntax to start the listener from the...
问题:单选题You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests. Which naming method can you use?()A Only hostB Only localC Either host or localD Both host and local...
问题:单选题Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?()A PMONB SMONC LGWRD CKRT...
问题:单选题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...
问题:多选题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...
问题:单选题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...
问题:单选题Examine the statement: DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement?()A AB BC CD D...
问题:单选题When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()A Until SCNB Until timeC Until cancelD Recover using backup control file....