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
7. Where would you look for errors from the database design?
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?
What are the different dcl commands in sql?
How do you write an index?
What is a primary key? Explain
what is pragma ?
How to select all records from the table?
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)
How can we avoid duplicating records in a query?
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
write an sql query to find names of employee start with 'a'? : Sql dba
What is scalar function?