Relation Schemas Design Multiple Choice Questions (MCQ) PDF - 48

MCQ 236: 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

MCQ 237: 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

MCQ 238: 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

MCQ 239: 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

MCQ 240: 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