Define compound operators?
No Answer is Posted For this Question
Be the First to Post Answer
What you can do to delete a table without the delete trigger firing?
what protocol both networks use? : Sql server database administration
Define model database?
What are the 2 types of classifications of constraints in the sql server?
What is policy management?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What do you understand by physical_only option in dbcc checkdb?
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 ?
Tell me when is the update_statistics command used?
Explain the creation and execution of a user-defined function in the sql server?
Can we drop user if user mapped to any logins
What are different types of data sources?