What is an index? What are the types of indexes? How many clustered indexes can be created on a table?


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

Post New Answer

More SQL PLSQL Interview Questions

7. Where would you look for errors from the database design?

1 Answers   Fintellix,


I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  


What are the different dcl commands in sql?

0 Answers  


How do you write an index?

0 Answers  


What is a primary key? Explain

0 Answers  






what is pragma ?

1 Answers   Polaris,


How to select all records from the table?

0 Answers  


I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,


How can we avoid duplicating records in a query?

0 Answers  


Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,


write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  


What is scalar function?

0 Answers  


Categories