Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 655 |
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.
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.
| I and IV only | |
| III and IV only | |
| I, II and III only | |
| II, III and IV only |
Question 655 Explanation:
Statement-I is TRUE because a VIEW of a table allows you to display updated version of the particular subset of the data in a database. A VIEW is a virtual table based on the result set of SQL
statement.
Statement-II is FALSE because E-R diagram useful to Conceptually model concepts.
Statement-III is FALSE because update anomaly is a data inconsistency results from partial update or data redundancy.
Statement-IV is FALSE because SQL is not a procedural language. A language is procedural when we call procedures( like functions, subroutine) but in SQL we don’t do any such calls.
statement.
Statement-II is FALSE because E-R diagram useful to Conceptually model concepts.
Statement-III is FALSE because update anomaly is a data inconsistency results from partial update or data redundancy.
Statement-IV is FALSE because SQL is not a procedural language. A language is procedural when we call procedures( like functions, subroutine) but in SQL we don’t do any such calls.
Correct Answer: D
Question 655 Explanation:
Statement-I is TRUE because a VIEW of a table allows you to display updated version of the particular subset of the data in a database. A VIEW is a virtual table based on the result set of SQL
statement.
Statement-II is FALSE because E-R diagram useful to Conceptually model concepts.
Statement-III is FALSE because update anomaly is a data inconsistency results from partial update or data redundancy.
Statement-IV is FALSE because SQL is not a procedural language. A language is procedural when we call procedures( like functions, subroutine) but in SQL we don’t do any such calls.
statement.
Statement-II is FALSE because E-R diagram useful to Conceptually model concepts.
Statement-III is FALSE because update anomaly is a data inconsistency results from partial update or data redundancy.
Statement-IV is FALSE because SQL is not a procedural language. A language is procedural when we call procedures( like functions, subroutine) but in SQL we don’t do any such calls.