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 18512Post New Perot Systems SQL Server Interview Questions
Recall a time when you faced a dissatisfied and aggressive customer. How did you handle it?
How we can communicate (voice communication) in LAN by using core java?
What is workflow? What are the components of the workflow manager?
what does the interviewer mean by saying "have a good life " cheerfully at the end of an HR interview??? is this positive to be selected reply yes or no
To get data from webserver to android application, which of the following class you need to use to establish connection?
What is a java singleton?
How can I use variable size items?
What does br mean in html?
Is a spring bean a singleton?
How can you use the recovery scenario in selenium webdriver?
What are the tools and techniques of the Quantitative Risk Analysis process? A. Checklists, flowcharting, interviewing B. Interviewing, sensitivity analysis, decision tree analysis, simulation C. Checklists, sensitivity analysis, decision tree analysis, information-gathering techniques D. Interviewing, checklists, assumptions analysis, risk probability impact
State bullet types available in HTML?
How do I run a program in pl sql?
Who wrote stl?
Give the logic expression for an AOI gate. Draw its transistor level equivalent. Draw its stick diagram