问题：单选题What is the maximum database block size supported for the Oracle9i database？（）A 16KBB 32KBC 64KBD 128KB

Monday, August 5, 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

Friday, July 12, 2024

问题：单选题The direct handoff connection method to an Oracle9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture. Which type of message has been eliminated？（）A The initial request from the client to the listener.B Messages between the dispatcher and the shared server background processes.C A redirect message from the listener to the client during client connections.D Round-trip messages between the listener and the shared server background processes.

Monday, August 5, 2024

问题：单选题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.

Thursday, September 7, 2023

问题：单选题The Oracle Net architecture is based on which of the following？（）A OCIB OSIC TCP/IPD SNMP

Thursday, April 6, 2023

问题：多选题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.

Sunday, December 15, 2024

问题：单选题You have lost all members of your current redo log file group. You issue this query： SQL> select * from v$log；  GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME  1                  60           153600        NO INACTIVE            01-03-09：19：34  2                  61           153600        NO CURRENT            01-03-09：19：50  You then perform an incomplete recover. You receive this message： ORA-00279：  change 309141...03/09/01 19：50：14 Needed for thread 1  ORA-00289： suggestion ： /disk1/archive/arch_61.rdo ORA-00280： change 309043 for thread 1 is in  sequence #61 Specify log： {=suggested | filename | AUTO | CANCEL} How should you respond to this message？（）A Enter the keyword AUTO.B Enter the keyword CANCEL.C Press the Enter or Return key.D Enter the filename ’/disk1/archive/log2a.rdo’.

Sunday, December 17, 2023

问题：单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A ’SQL ALTER DATABASE OPEN’；B SQL ALTER DATABASE ’OPEN’；C OPEN DATABASE；D DATABASE OPEN

Sunday, December 15, 2024

问题：单选题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

Sunday, December 17, 2023

问题：多选题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.

Wednesday, July 3, 2024

问题：单选题Which tool can be used to create and configure listeners to receive client connections？（）A Oracle Net ManagerB Oracle Net Control UtilityC Oracle Net Configuration Assistant

Saturday, October 5, 2024

问题：单选题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. 

Thursday, August 22, 2024

问题：单选题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.

Friday, August 16, 2024

问题：单选题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.

Monday, August 5, 2024

问题：多选题Online index rebuild functionality has been extended to include which four index structures？（）ABitmap indexes.BReverse key indexes.CFunction-based indexes.DKey-compressed indexes on regular tables.EKey-compressed indexes on IOT （including secondary indexes）

Saturday, November 9, 2024

问题：单选题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.

Sunday, December 17, 2023

问题：多选题When a check point occurs the （）. （）. and （） are synchronized.Adata filesBcontrol filesCredo log filesDparameter filesEarchive log files

Friday, May 17, 2024

问题：多选题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.

Wednesday, July 3, 2024

问题：多选题When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）AAt the end of every RUN block.BAfter every SET CONTROLFILE AUTOBACKUP FORMAT command.CAfter every BACKUP or COPY command issued at the RMAN prompt.DAt the end of every RUN block if the last command in the block was either BACKUP or COPY.EWhenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY.FAfter every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

Wednesday, December 11, 2024

问题：多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.

Sunday, December 15, 2024