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
Define full outer join in sql server joins?
Can you insert NULL in unique column?
What is a collation in ms sql server?
Data table as parameter in sql server?
Why use “in” clause in sql server?
Explain in details security in SQL azure?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
How to turn on the mssql api module in php?
What is the largest component inside a field?
Please differentiate between a local and a global temporary table?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What are the advantages of user-defined functions over stored procedures in sql server?
How optimize sql query with multiple joins in sql server?
what is the maximum size of a row? : Sql server database administration