Oracle Ind

4. The following table is created in Oracle 11g database.create table test(name varchar2(20),gender varchar2(10),id number unique);As part of this create statement normal ________ index will be created
6. Fill up the keyword to be used to start monitoring an exisiting index.alter index indexname monitoring _________
8. Information regarding the column on which the index is created in a table can be fetched from the view __________
11. Inorder to avoid the optimizer using an existing index during query execution, the following command must be given. Fill up with the appropriate keyword: alter index indexname ________
13. This type of index is created by default in oracle for a primary key column
14. Fill up the keyword to be used to change the name of an existing index.alter index old_index_name _________ to new_index_name

1. A user must have the ___________ system privilege to create an index in another schema
2. Name of an index created automatically by the server can be fetched from the view ____________
3. The dynamic performance view where a user can check whether an existing index is being used or not during query executions
5. The following table is created in Oracle 11g database.create table test(name varchar2(20),gender varchar2(10),id number unique);The table is always queried as follows: select id from TEST where UPPER(NAME)='EMPNAME'; What type of index must be created in this scenario so that the index will be used during query execution?
7. Fill up the keyword to be used to rebuild a disabled index.alter index indexname ___________
9. Fill up the blank with the appropriate keyword so that a user will be able to create a virtual index.CREATE unique INDEX indexname on tablename(colname) ________
10. Fill up the keyword to be used for disabling an existing index.alter index indexname ____________
12. UNIQUE keyword cannot be used during this type of index creation