database concepts Flashcards
1
Q
list all 6 limitations of file system
A
difficult to access, data redundancy, inconsistency, isolation, dependence, controlled data sharing
2
Q
in general, a file is a collection of all related
A
records
3
Q
relational database is a collection of
A
tables
4
Q
_ helps to enforce integrity and identity the relationship between tables
A
key
5
Q
minimal superkeys are known as _
A
candidate keys
6
Q
rdbms must comply with atleast _ rules
A
6
7
Q
_ is an operation that is used to combine rows from two or more tables based on one or more common fields between them
A
join
8
Q
in a relational database, a referential integrity constraint can be specified with the help of
A
foreign key
9
Q
to specify additional checks in table attributes, the _ constraint is used
A
check
