1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the criteria while applying index to any column on
any table.

Question Posted / shah.sonal2988


What is the criteria while applying index to any column on any table...

Answer / vijay_1994

index syntax
-----------------
create index index_name on table_name (column_name)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

what is global variable in package

3 Answers   Polaris,

What is data abstraction in sql?

0 Answers  

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  




What is the difference between truncate and drop statements?

0 Answers  

How many types of index are there?

0 Answers  

What if we write return in procedure?

0 Answers  

What is normalization in sql?

0 Answers  

Which constraints we can use while creating database in sql?

0 Answers  

What are all the different normalizations?

0 Answers  

What is bitemporal narrowing?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories