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 ?
- 10 Answers
- 16588 Views
- Perot Systems, I also Faced
- E-Mail Answers
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
Does windows server 2016 come with sql server?
What is the syntax for encrypting a column in SQL Server?
Do you know the different ddl commands in sql?
What are the encryption mechanisms in sql server?
What are the new data types are introduced in sql 2000?
What is the use of keyword with encryption.
What is schemabinding a view?
What is report snapshot in ssrs?
What are the 3 types of schema?
Explain magic tables in sql server?
What protocol does sql server use?
Define Unique Key?
What are tables in sql server?
What is a view and what are its advantages?
What is difference in performance between insert top (n) into table and using top with insert?
