How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }
DELL,
2 8492Types of indexes. What is the default key created when a primary key is created in a table ?
TCS,
5 12819What is clustered, non-clustured and unique index. How many indexes can be created on a table ?
TCS,
3 10479What is difference between triggers and stored procedures. And advantages of SP over triggers ?
4 23709Write a query to get 2nd maximum salary in an employee table ?
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,
69 102303
What are keys in sql?
Explain what is a column in a table?
Explian rowid, rownum?
How many aggregate functions are available there in sql?
Why do we use sql constraints?
What are different types of statements supported by sql?
What is difference between sql function and stored procedure?
How does rowid help in running a query faster?
How do I add a primary key to a table?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Are stored procedures faster than queries?
what is try_catch block in procedure
What are the two types of exceptions.
Which are the different types of indexes in sql?
What are tables in sql?