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 16643why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
1 73661). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4422Post New Perot Systems Interview Questions
How do I insert a header and footer in word 2007?
What is cost in sql execution plan?
What is transact-sql language?
What is behavior driven development (bdd)?
What is the difference between throw/catch and raise/rescue?
how to do partition in sqlserver
What are the variables in typescript?
Define commit log?
what is meant by motor startup supervision & motor load jam protection ?
What is the difference between viewstack vs viewstate?
Why is it beneficial to run AI models on edge devices (IoT)?
What is used to measure process performance and for generating mi (management information)?
How do you carry-forward account balances? : cost center accounting
How are the waters classified based on the degree of hardness?
Which is better chkdsk r or f?