问题:单选题There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations?()A...
Monday, July 3, 2023
问题:单选题Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by ‘safe literals only’?()A No literal value is su...
Saturday, December 2, 2023
问题:单选题What is the maximum database block size supported for the Oracle9i database?()A 16KBB 32KBC 64KBD 128KB...
Monday, April 1, 2024
问题:单选题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view?()A During a query’s parse time only. B During a query’s execution time only. C During any kind of DML statement execution. D During the execution of an INSERT statement only....
问题:Examine the RMAN command: SWITCH DATAFILE ’/DISK3/user_data0...
Friday, September 16, 2022
问题:单选题When performing recover of a database in NOARCHIVELOG mode with RMAN, the target database must be in the () state to restore the control file.A OPENB IDLEC MOUNTD NOMOUNT...
Sunday, January 22, 2023
问题:单选题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...
Tuesday, January 16, 2024
问题:单选题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...
Wednesday, October 11, 2023
问题:多选题A web browser can connect directly to an Oracle server using which two?()AHTTPBIIOPCTCP/IPDNamed PipesETCP/IP with SSL...
Sunday, December 17, 2023
问题:单选题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...
Sunday, July 23, 2023
问题:多选题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....
问题:单选题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...
问题:多选题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...
Thursday, August 17, 2023
问题:单选题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...
Thursday, September 7, 2023
问题:多选题Examine the list of variables and their data types: AME DATA Type TS, TS1 TIMESTAMP TSZ TIMESTAMP WITH TIME ZONE TLZ TIMESTAMP WITH LOCAL TIME ZONE IYM INTERVAL YEAR TO MONTH IDS, IDSI INTERVAL YEAR To SECOND Which three expressions using the n...
Friday, November 24, 2023
问题:单选题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...
Thursday, April 6, 2023
问题:单选题Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to...
Saturday, January 27, 2024
问题:单选题Which phrase best describes RMAN multiplexed backup sets?()A Stripes a single backup set across multiple channels.B Identical copies of backup pieces within a backup set.C Multiple backup sets with multiple channels configured.D Simultaneous reads from...
问题:单选题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...
问题:多选题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...