A.It can contain parameters with distinct values for each distance.
B.It can contain only parameters with identical values for each instance.
C.It must contain an IFILE parameter for each instance’s individual parameter file.
D.It must be located in the default location for the primary instance’s parameter file.
您可能感兴趣的试卷
你可能感兴趣的试题
A.Data blocks have to be written more frequently by DBWR.
B.Redo blocks have to be written more frequently by LGWR.
C.You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records.
D.You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
A.The standby database is protected against write operations.
B.The primary database is protected against write operations.
C.The primary database is protected against data loss and data divergence.
D.The standby database is protected against data loss and data divergence.
A.An improved version of multithreaded server configuration.
B.A connection pooling configuration where several clients are connected to the same server process.
C.Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected.
D.A configuration of Real Application Cluster where the client connection is routed to the least busy instance.
A.The CONNECT INTERNAL is disallowed.
B.The Server Manager tool is no longer supplied.
C.The listener must be running to make a connection.
D.The use of remote password login file (orapw<sid>) is unchanged.
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 instance recovery, or the time needed to complete instance recovery.
D.The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.
A.ALTER TABLE employees monitor index employee_idx_fk;
B.ALTER INDEX employee_idx_fk monitoring on;
C.ALTER TABLE employees monitor all indexes;
D.ALTER INDEX employee_idx_fk monitoring usage;
A.It readily responds to dynamic changes for concurrent access.
B.It improves performance and space utilization in a multiple-instance environment.
C.It requires fewer space related options then freelist managed structures.
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.
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.
A.External tables can be updated.
B.External tables are read-only tables.
C.Indexes can be created on external tables.
D.Indexes cannot be created on external tables.
最新试题
Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()
The three tasks shown have been completed in order to configure a naming method: Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor Task 2: Started default listener on port 1521 Task 3: Added global database name to the listener.ora file. Which naming method was configured?()
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state, prior to the load operation?()
Which of the following options would you choose to implement controlled access using remote authentication for your networks?()
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
Which data dictionary views displays the error information related to a data file, when an internal read fails on that file?()
After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME, the information in the control file is overwritten by RMAN. What is this parameter’s default value?()
Which of the following parameters must be specified to define the number of dispatchers that need to be started?()
The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database?()