What are constraints? Explain different types of
constraints?
Answer Posted / rohit
MySQL does not support the use of CHECK constraint
Is This Answer Correct ? | 4 Yes | 12 No |
Post New Answer View All Answers
Give an example of why you would want to denormalize a database
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is sql profiler. What are the default templates with it? : sql server database administration
What is database isolation in sql server? : sql server database administration
Explain datetimeoffset data type in sal server 2008?
What is tcl in sql server?
How to fetch the next row from a cursor with a "fetch" statement?
Do you know what guidelines should be followed to help minimize deadlocks?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is identity?
What happens if you are trying to access a schema not owned by you?
What is SQL Azure Federations?
Is sql server is free?
Benefits of Stored Procedures?