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 18847Post New Perot Systems SQL Server Interview Questions
If you are rejected today, then what will you do?
How to edit the joined fields values in join?
No of ways of doing deployments?
Is trigger a stored procedure?
Why is there little or no grass in the forest?
How do you update microsoft word?
How do I open outlook 365 without an account?
What are different sales document in sap system? How to create a sales document?
What are the basic principles of elisa test?
What is raid in windows server 2008?
What are the differences between tableau software, gooddata and traditional bi (business objects, etc.)?
What do you mean by lookup table?
Have you used lexical parameters in reports?
Explain serialization and deserialization?
What is the difference between const and static read-only?