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 16643Post New Perot Systems SQL Server Interview Questions
- Perot Systems ASP Interview Questions (1)
- Perot Systems VB Script Interview Questions (1)
- Perot Systems ASP.NET Interview Questions (4)
- Perot Systems VB.NET Interview Questions (1)
- Perot Systems Oracle General Interview Questions (1) Perot Systems SQL Server Interview Questions (1)
- Perot Systems Linux Commands Interview Questions (1)
- Perot Systems Unix Commands Interview Questions (2)
- Perot Systems Test Director Interview Questions (2)
- Perot Systems JCL Interview Questions (3)
- Perot Systems DB2 Interview Questions (1)
- Perot Systems Business Objects Interview Questions (2)
- Perot Systems HR Questions Interview Questions (1)
- Perot Systems Business Administration Interview Questions (1)
- Perot Systems Accounting AllOther Interview Questions (1)
- Perot Systems Call Centre AllOther Interview Questions (2)
- Perot Systems General Aptitude Interview Questions (1)
- Perot Systems Placement Papers Interview Questions (3)
How to handle a web browser resize operation?
What are the uses of the information in the data dictionary? : abap data dictionary
Can we use pl sql in sql server?
When should I use an java applet instead of ajax?
What is the significance of addrspc parameter in exec statement?
State the factors, for the choice of electrical system for an aero turbine.
What is df command in linux?
If you could design your ideal job, what would it look like?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What should be the level/ Percentage of Arsenic in Arsenic free zinc.
what is audit & activities of auditor?
Explain active/passive and active/active cluster configurations?
How to calculate wire length,size & current? ( related to control panel)
What are the different types of exception?
Is xpath a programming language?
