Can we insert data into materialized view?
What does select count (*) mean in sql?
What are triggers, and when would you use them?
what is d diff between grant,commit,rollback n savepoint
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
write a qurey for finding the length of the sting.
What is the purpose of a secondary key?
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
what is sub-query? : Transact sql
How would you pass hints to the sql processor?
How do you retrieve the last N records from a table?
What is data control language (dcl)?
what is the difference between char_length and length? : Sql dba