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
Tell me about normalization in DBMS.
Do you think BCNF is better than 2NF & 3NF? Why?
What is user defined stored procedures?
what is hash nonclustered index
How do you create type- insensitive operator?
How to rebuild indexes with alter index ... Rebuild?
What are policy management terms?
Does the unique constraint create an index?
What is the difference in accessing db between sql server vs sql azure?
Explain what is “asynchronous” communication in sql server service broker?
Why do you want to join software field as you have done your BE in Electronics?
How to insert new line characters into strings?
What stored by the model? : sql server database administration
What is serializable?
What is the contrast between sql and pl/sql?