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 18598Post New Perot Systems SQL Server Interview Questions
Actinium-227 has a long half-life and emits alpha particles. How can this property be harnessed in radiation detectors or other monitoring devices?
what is the difference between site_url() and home_url()?
What is nic?
sir i want model and previous year question paper of RRB. please send it to my mail id. im a mechanical engg.
Is there an ifs function in excel?
Explain application layer?
Explain transaction and various methods to manage it?
What is difference between bind by copy and bind by reference?
where to store informatica rejected data?
How would rate yourself in technical and communication skills?
What is the command manager?
sir,i have L&T infotech campus placements in the next week. can u please send me the actual procedure,previous written test papers and technical questions?
What is human resource information systems (chris)? : sap abap hr
What is nsoperation and nsoperationqueue?
What are lock objects?