How do we know whether an index is created on a table ???

Question Posted / ashok

2 Answers
5901 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do we know whether an index is created on a table ???..

Answer / anithaletchumi

select index_name from dba_indexes where table_name=upper
('table_name');

dba_indexes -> This view has the description for all
indexes in the database.

Is This Answer Correct ?

6 Yes

5 No

How do we know whether an index is created on a table ???..

Answer / urmi

select index_name from user_indexes u where u.TABLE_NAME=upper('table_name');

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

what is a view?

7 Answers

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers

DBMS vs. RDBMS

2 Answers TCS,

what is primary key and foreign key when and where have to use

5 Answers

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers

What is PL/SQL ?

3 Answers

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers

What do database buffers contain?

0 Answers

How to synchronize 2 schema's objects?

0 Answers Virtusa,

11. Display the client number and name and the client number and name of the person who referred that client.

0 Answers Wipro,

Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions

1 Answers

For more Oracle General Interview Questions Click Here