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 181851). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4718Post New Perot Systems Interview Questions
What do you mean by table and field in sql?
What is a controller php?
If date field is a text field write test cases to validate it?
How many columns are in a database table?
Define satellite Assembly in .NET?
Explain the difference between plc and logic card?
What are the analyses provided by the study of human age pyramids?
What is the use of adding comments?
Why do you use abstract classes?
what does the track parameter mean in staad.pro?
What is the copy-and-swap idiom?
How do I tune a sql query?
What is “dirty read” in JDBC? Which isolation level prevents dirty read?
Does windows 10 come with word and excel?
What ports are used by dhcp and the dhcp clients?