UGC NET Dec-2020 and June-2021 Paper-2
December 3, 2023Question 965 – Nielit Scientist-B IT 4-12-2016
December 3, 2023UGC NET Dec-2020 and June-2021 Paper-2
| Question 13 |
Consider following two statements:
Statement I: Relational database schema represents the logical design of the database.
Statement II: Current snapshot of a relation only provides the degree of the relation.
In the context to the above statements, choose the correct option from the options given below:
Statement I: Relational database schema represents the logical design of the database.
Statement II: Current snapshot of a relation only provides the degree of the relation.
In the context to the above statements, choose the correct option from the options given below:
| Both Statement I and Statement II are FALSE | |
| Both Statement I and Statement II are TRUE | |
| Statement I is FALSE but Statement II is TRUE | |
| Statement I is TRUE but Statement II is FALSE |
Question 13 Explanation:
Relational databases schema were originally proposed to separate the physical storage of data from its conceptual representation and to provide a mathematical foundation for data representation and querying. It represents the logical design of the database. Hence statement 1 True.
Current snapshot or instance of a relation represent everything about the relation like degree of the relation, cardinality of the relation etc. Hence statement 2 is wrong.
Current snapshot or instance of a relation represent everything about the relation like degree of the relation, cardinality of the relation etc. Hence statement 2 is wrong.
Correct Answer: D
Question 13 Explanation:
Relational databases schema were originally proposed to separate the physical storage of data from its conceptual representation and to provide a mathematical foundation for data representation and querying. It represents the logical design of the database. Hence statement 1 True.
Current snapshot or instance of a relation represent everything about the relation like degree of the relation, cardinality of the relation etc. Hence statement 2 is wrong.
Current snapshot or instance of a relation represent everything about the relation like degree of the relation, cardinality of the relation etc. Hence statement 2 is wrong.