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 15488Post 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 xss vulnerability scenarios in angular?
How does normalization of huge pointer works?
what is nonclustered index
Which is better jdbc or hibernate?
Define gdg?
What is bus group id? Explain its importance.
What are isolated unit tests?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
Explain how to run the hybris in cluster mode?
How would you sell a used toothbrush? A broken pen? A bitten apple?
Plz tell me how we can find that particular company has vacancy or not
which batch require to use for analytical method validation?
How to prove a new block cipher, is resistant against differential cryptanalysis attack
What are the different types of network security?
How are microarrays related to dna?
