4 votes 4 votes Which of the following statement(s) is/are FALSE in the context of Relational DBMS? Views in a database system are important because they with access control by aloowing users to see only a particular subset of the data in the databse E-R diagrams are useful to logically model concepts An update anamoly is when it is not possible to store information unless some other, unrelated information is stored as well SQL is a procedural language I and IV only III and IV only I, II and III only II, III and IV only Databases ugcnetcse-june2016-paper2 databases + – go_editor asked Aug 14, 2016 • recategorized Nov 5, 2017 by Devshree Dubey go_editor 4.9k views answer comment Share Follow See 1 comment See all 1 1 comment reply Anjali_aspirant commented Aug 14, 2016 reply Follow Share Ans is (A)? 0 votes 0 votes Please log in or register to add a comment.
4 votes 4 votes ans should be D II , III and IV are false (update anamoly is concerned with related information amd sql is not procedure oriented PL/SQL is ) https://stackoverflow.com/questions/4279089/what-is-the-difference-between-logical-data-model-and-conceptual-data-model Sanjay Sharma answered Aug 14, 2016 • edited Sep 24, 2017 by Sanjay Sharma Sanjay Sharma comment Share Follow See all 0 reply Please log in or register to add a comment.
3 votes 3 votes II , III and IV are wrong ER diagram is used for conceptual modelling - not logical modelling sql is non procedure language the given anomaly is insertion anomaly Sankaranarayanan P.N answered Sep 15, 2016 Sankaranarayanan P.N comment Share Follow See all 2 Comments See all 2 2 Comments reply Shubham Pandey 2 commented Sep 15, 2016 reply Follow Share wht is diffrence betwween conceptual modelling and logical modelling and what kind of lang SQL is 1 votes 1 votes anchitjindal07 commented Jul 25, 2018 reply Follow Share Sql is declarative language. Declarative means you just tell what to do, not how to do that. In SQL queries you just specify what data to fetch or update. We don't specify how to insert or update data in SQL queries. So SQL is declarative language 0 votes 0 votes Please log in or register to add a comment.
