1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
Answer Posted / srivas
What is mean by NULL value ?NULL means "" or 0 or
undefined ?
Answer : NULL means empty ie. ""
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
Why do we use trigger?
Write down the syntax and an example for create, rename and delete index?
Difference between report and query parameter.
What is 2nf in normalization?
How do you debug a procedure in sql server?
Is it true, that there is no difference between a rule and a check constraint?
What is a sql join?
Explain unique key in sql server?
Why would you use sql agent?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Explain isolation levels that sql server supports?
tell me the disaster recovery plan
What the different components of Replication and what is their use?
How to fine-tune reports?
Tell me what is use of except clause? How it differs from not in clause?