Relation Schemas Design MCQ with Answers PDF Download – Test 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