Which of the following statement(s) is/are FALSE in the context of Relational…
2016
Which of the following statement(s) is/are FALSE in the context of Relational DBMS ?
I. Views in a database system are important because they help with access control by allowing users to see only a particular subset of the data in the database.
II. E-R diagrams are useful to logically model concepts.
III. An update anomaly is when it is not possible to store information unless some other, unrelated information is stored as well.
IV. SQL is a procedural language.
- A.
I and IV only
- B.
III and IV only
- C.
I, II and III only
- D.
II, III and IV only
Attempted by 171 students.
Show answer & explanation
Correct answer: B
Answer: Statements III and IV are FALSE.
Statement I: True. Views provide a way to present only a subset or a particular perspective of the data, which helps with access control and security.
Statement II: True. E-R diagrams are used for conceptual and logical modelling of entities and relationships in a database design.
Statement III: False. The described situation (cannot store information unless some unrelated information is stored) is an insertion anomaly. An update anomaly is when redundant copies of data lead to inconsistent values after updates.
Statement IV: False. SQL is a declarative language (it specifies what result is desired). Procedural extensions exist (for example PL/SQL), but standard SQL is not a procedural language.
Therefore, the false statements are III and IV.