What is an Integrity Constrains ?
Answers were Sorted based on User's Feedback
Answer / din dayal singh
Integrity constraints are used to ensure accuracy and
consistency of data in a relational database.[citation
needed] Data integrity is handled in a relational database
through the concept of referential integrity. There are many
types of integrity constraints that play a role in
referential integrity.
Entity integrity
Referential Integrity
Domain Integrity
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
Integrity constraints provide a way of ensuring that changes made to the database by authorized users do not result in a loss of data consistency.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / deva
Primary key and unique key constraints are known as
integrity constraints where they are supposed to check the
unique of the records.
| Is This Answer Correct ? | 0 Yes | 2 No |
Is it possible to enter only time value into a column of a table in sql?
Define 'view' advantage ?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is meant by an index?
Write a trigger example in oracle?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
6. Display the client name and order date for all orders using the traditional method.
What is truncate oracle?
What are a cluster and non-cluster index?
What are the components of logical database structure in oracle database?
What are the different types of databases?
20. Using a set operator, display the client number of all clients who have never placed an order.