单选题The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?()AALTER TABLE employees monitor index employee_idx_fk; BALTER INDEX employee_idx_fk monitoring on; CALTER TABLE employees monitor all indexes; DALTER INDEX employee_idx_fk monitoring usage;

单选题
The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?()
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; 


参考解析

解析: 暂无解析

相关考题:

单选题Using the command shown here, what time format must you specify to recover the database until a point-in-time?()  SQL RECOVER DATABASE UNTIL TIME ’’;AYYYY-DD-MM:HH24:SS:MI BYYYY-DD-MM:HH24:SS:MM CYYYY-MM-DD:HH24:MI:SS DYYYY-DD-MM:SS:MI:HH24

单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?()AThe filename format. BInformation stored inside a data dictionary table. CInformation stored in the ALERT.LOG file for the corresponding instance. DInformation stored inside the corresponding initialization parameter file for the instance.

单选题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?()Ahost naming methodBlocal naming methodCdirectory naming methodDexternal naming method

多选题SQ L*Loader is a utility that can perform which two tasks?()ALoad data from a disk, tape, or named pipes.BLoad data into an Oracle database using DML statements.CExtract, reorganize, and insert data within an Oracle database.DLoad data from external files into tables in an Oracle database.ELoad data into an Oracle database using operating system commands.FLoad data directly from a non-Oracle database to an Oracle database.

单选题Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users?()AIGNORE=YBDIRECT=YCCONSISTENT=YDBUFFER=Y

单选题You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()AADDRESS_LISTBSID_NAMECLISTENERDSERVICE_LIST