Why functions are used in sql server?
What is precedence constraint?
Can two tables share the same primary key?
Can we install sql server 2016 on windows 7?
Can you get second highest salary from the table?
How to download and install the scaled-down database adventureworkslt?
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 ?
hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
7 Answers Google, TCS, Unisys,
Explain the working of sql privileges?
List the different types of joins?
What are the types of model in sql server and explain
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is the difference between lock, block and deadlock? : sql server database administration