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
Explain syntax for disabling triggers?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain four layers of abstraction microsoft architectured?
Explain what are page splits? : SQL Server Architecture
What is the difference between having clause and where clause in sql server?
what's new in sql server 2016?
What is sql server profiler?
Explain sql delete command?
What are the diifferences between the ms sql server vs mysql?
Explain why variables called the most powerful component of ssis?
Why Master database is required?
What is forward - only cursors / read only cursor?
How and why use sql server?
What is logshipping and its purpose?
What is SQL Azure?