Relation Schemas Design Multiple Choice Questions (MCQs) PDF Download - 48

Considering the relational database, the functional dependency between two attributes A and B is denoted by

1. A → B
2. B ← A
3. AB → R
4. R ← AB

The specification given to database management system regarding the data whether it is string, integers or special characters is classified as

1. type of data stored
2. type of query asked
3. type of structure developed
4. sequence of data cycle

The command in high level programming which completes the release of buffers and perform other cleanup operations remaining is classified as

1. read command
2. find next command
3. close command
4. insert command

The category which considers the union of super class entities is called

1. total super class
2. partial super class
3. disjoint super class
4. joined super class

If the attribute of relation schema R is member of some candidate key then this type of attributes are classified as

1. atomic attribute
2. candidate attribute
3. nonprime attribute
4. prime attribute