What are the advantages of indexing?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

what are the advantages of package?

7 Answers   iFlex,


In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,


what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  


How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  


What are triggers and its uses?

0 Answers  






Does inner join return duplicate rows?

0 Answers  


what are the authentication modes in sql server? : Sql dba

0 Answers  


What is server name sql?

0 Answers  


Wat is SGA ?

3 Answers   ABB,


create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,


What is a trigger in sql?

0 Answers  


What is clause?

0 Answers  


Categories