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 18566Post New Perot Systems SQL Server Interview Questions
what are the iterator and generic algorithms.
Java is Pass by Value or Pass by Reference?
Why NIIT Technologies?
What are the benefits of stored procedures?
How to extend a bo?
Write command to generate a component in specific module in angular cli?
How much of the total hydro power potential has been exploited so far in india?
how many sql ddl commands are supported by 'mysql'? : Sql dba
I am a electrical engg. diploma holder,applied for junior engineer (electrical),Kolkata RRB. Have I to attend all electrical,mechanical&civil portion in written exam.???
Explain the bead work of western region
what do you mean by measuring point tables?
What is OLEDB?
What is output value? How many types of output values are there in qtp?
How you will restore deleted users OneDrive?
State the difference between the expected value and mean value?