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 raid and what are different types of raid configurations? : Sql server database administration
Difference between LEN() and DATALENGTH() in sql server ?
How to execute stored procedure and set temp table in sql server?
How to apply filtering criteria at group level with the having clause in ms sql server?
How to fine-tune reports?
What are binary string data types in ms sql server?
What is meant by referential integrity?
How to drop existing indexes in ms sql server?
What Is Rdbms?
What is the use of =,==,=== operators?
What is clustered primary key?
How to create a simple stored procedure in ms sql server?
What are the different kinds of ssrs reports?
Mention what are the different types of ssrs reports?
Can you explain different types of locks in sql server?