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 18845why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
1 80011). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4889Post New Perot Systems Interview Questions
What's is the mechanism of for stroke engine
what is the format specifier for printing a pointer value?
What is the function of a replication server?
In a function declaration, what does extern mean?
What django collectstatic command does?
What is InnoDB?
How to make updates to updatable result sets in jdbc?
What is rownum in sql?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is difference between GTS bench mark and temporary bench mark
What does rdd mean?
What is green revolution?
How can we subscribed to an event in lightning component? : salesforce lightning component
What is aspect-oriented programming?
Why would we not include these?