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 18512why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
1 78851). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4789Post New Perot Systems Interview Questions
How do you implement session management in SQL Server mode?
What is bias-variance trade-off in machine learning?
What is workflow? Name the person who can assist you while configuring a workflow for a system.
Explain what is the difference between powerplay transformer and power play reports?
Mention how storm application can be beneficial in financial services?
Explain how to perform remoting?
What is hidden field?
Where i can get the objective type question for Voip. please let me know soon.
How to remove 2 duplicate records and copy only one using job control language?
State the basic elements of an export sales contract.
What is a connector in blue prism and mention the types of it?
Before deploying the hadoop instance, what are the checks that an individual should do?
Define redefine and its syntax?
What is raid controller technology?
What is shuffle in spark?