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 186021). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4823Post New Perot Systems Interview Questions
Explain the role of Streams API?
How state is useful for react?
being a b.c.a student why do you want to go for a call centre job
Why is used in excel?
When root canal procedure is performed?
Does the w3c support any web service standards?
What are the features of windows 10 operating system?
What is difference between secondary Air & Tertiary Air and Their use.?
What you know about this company?
How do you make a picture transparent in powerpoint 2007?
List the considerations in developing testing methodology
How to join a work group in windows xp?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to Initialize an array or record to null?
What are some advantages of selenium grid?