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
What is molap and its advantage? : sql server analysis services, ssas
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is user-defined function?
What is change data capture (cdc) feature?
Find columns used in stored procedure?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is page-level compression?
How to find the login name linked to a given user name?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is the purpose of the model database?
What is factless fact table? : sql server analysis services, ssas
What are the components of sql server service broker?
Will sql server 2005 allow you to reduce the size of a column?
What is difference between delete and truncate commands?
List all the types of user-defined functions?