UGC NET COMPUTER SCIENCE SOLVED PAPERS 2014-16 - UGC NET Computer Science Paper 2 August 2016

16. DBMS provides the facility of accessing data from a database through

  • Option : A
  • Explanation :
    1- DML stands for data manipulation language. The SQL commands that deals with the manipulation of data present in the database belong to DML or Data Manipulation Language including retrieving, storing, modification, deletion, insertion and updation of data in a database. Examples of DML: SELECT, INSERT, UPDATE, DELETE.
    2- DDL - Data Definition Language - This commands in SQL includes the creation, deletion and modification of structure of database objects. Examples of DDL commands: CREATE, DROP, ALTER, TRUNCATE, COMMENT, RENAME. It provides the facility of accessing data from a database.
    3- Functions of a DBA include: Schema definition, Storage structure and access-method definition, Schema and physical-organization modification, Granting of authorization for data access, Routine maintenance.
    4- Schema: The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.
    So, option (A) is correct.
Cancel reply
Cancel reply

17. Relational database schema normalization is NOT for:

  • Option : A
  • Explanation :
  • Relational database schema normalization is NOT for reducing the number of joins required to satisfy a query.
  • Relational database schema normalization is for eliminating uncontrolled redundancy of data stored in the database.
  • Relational database schema normalization is for eliminating number of anomalies that could otherwise occur with inserts and deletes.
  • Relational database schema normalization is for ensuring that functional dependencies are enforced.
  • So, option (A) is correct.
Cancel reply
Cancel reply

18. Consider the following statements regarding relational database model:
(a) NULL values can be used to opt a tuple out of enforcement of a foreign key.
(b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is also in BCNF.
(c) The difference between the project operator (Π) in relational algebra and the SELECT keyword in SQL is that if the resulting table/set has more than one occurrences of the same tuple, then Π will return only one of them, while SQL SELECT will return all.
One can determine that:

  • Option : D
  • Explanation :
    In relational database model:
    (a) NULL values can be used to opt a tuple out of enforcement of a foreign key. Correct
    (b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is also in BCNF. Correct
    (c) The difference between the project operator (Π) in relational algebra and the SELECT keyword in SQL is that if the resulting table/set has more than one occurrences of the same tuple, then Π will return only one of them, while SQL SELECT will return all. Correct
    So, option (D) is correct.
Cancel reply
Cancel reply

20. Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ?

  • Option : B
  • Explanation :
    SELECT A FROM R; legal query SELECT A, COUNT(*) FROM R; Illegal query because we can't SELECT A, COUNT(*) unless it is grouped by A. SELECT A, COUNT(*) FROM R GROUP BY A; legal query SELECT A, B, COUNT(*) FROM R GROUP BY A, B; legal query So, option (B) is correct.
Cancel reply
Cancel reply