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 15443why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
1 70441). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4138Post New Perot Systems Interview Questions
Is there any sign of larvae or mature insects with the naked eyes?
What is the basic rule for block diagram reduction technique?
How you can add an event handler?
what is the certificates in biztalk?
Cucumber execution starts from where?
What are the differences between value types and reference types?
Explain difference between static and dynamic ip?
What best practices should you follow while writing multithreaded code in java?
Explain the disadvantages/limitation of the cursor?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
In power transmission using open belts or horizontal shafts it is preferable to have the slack side of the belt on the top because
How do I get windows 10 on my computer?
How do I truncate a word?
How to grow more methylobacterium?
What is the diffrence between a local-tx-datasource and a xa-datasource? Can you use transactions in both?