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
- 15413 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
What is correlated subquery in sql server?
What are the types of normalization?
How to delete all rows with truncate table statement in ms sql server?
What are types of subqueries?
What is nonclustered index on computed columns?
What are the hotfixes and patches in sql server?
Do you know what is similarity and difference between truncate and delete in sql?
How to view existing indexes on an given table using sys.indexes?
What is the maximum size of a dimension? : sql server analysis services, ssas
Explain the architecture of ms sql reporting service?
Can the “if update (colname)” statement be used in a delete trigger?
What new changes are being made in SQL Server?
How to perform key word search in tables?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is the difference between executequery () and executeupdate ()?
