Explain the key constraints and constraints on Null Values
with examples?
Answers were Sorted based on User's Feedback
Answer / amit
hi ,
key constraits i.e. referential integerity means
all values in foreign key must be in primary key , but it
may happnes that NULL values may be in foreign key , but
not in primary key .
this is done to cater some of the exception conditions.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / navin kumar
because the key constraints can contains NULL value
but constrains not.
navin south delhi
| Is This Answer Correct ? | 0 Yes | 0 No |
Whats is an OLTP Database
Explain the terms database and dbms?
What is a key in dbms?
When should you consider denormalization?
List few disadvantages of file processing system.
Explain the difference between a dynamic and materialized view.
What is the role of database management system?
Which two statements are true about a foreign key?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
What is difference between database and schema?
What is the role of database server in database management system?
What is dbms and types of dbms?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)