What is referential integrity? What are the advantages of it?
Answer Posted / ramakrishna
refrential nothing but forgein key
| Is This Answer Correct ? | 13 Yes | 32 No |
Post New Answer View All Answers
Describe in brief sql server monitoring ways.
What is the partitioning method?
can an order by clause be used in a creation of a view?
How can you set the threshold at which sql server will generate keysets asynchronously?
Explain cross join or cartesian product in sql?
What are data regions?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
Name few endpoints exposed by ssrs 2012?
What is fill factor and pad index?
Can we insert data into view sql server?
Tell me about joins in database system and explain each in detail.
Explain activity monitors
How many types of attribute relationships are there? : sql server analysis services, ssas
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What are the differences between sql server and mysql.