What are all ddl commands?
write a query to display diference between two dates in sql server
what is global temporary tables and how use that tables in pl/sql packages
What is right join in sql?
What is foreign key and example?
What is the difference between count 1 and count (*) in a sql query?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is flag in sql?
What is pessimistic concurrency control? : Transact sql
What is trigger in sql?
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.
Why primary key is required?
What is the use of prepared statement?