GATE DBMS: Subject Wise Solved Question Papers

Previously we posted Operating System solved paper MCQ from previous years GATE computer Science Questions paper. Now in the next part of the GATE Subject wise solved question papers series we are posting DBMS questions, these questions are in the form of test from the last 15 years GATE CS papers

DBMS 1 Marks Questions

Data Base Management System one marks questions from previous years GATE Computer Science paper
Shaded items are complete.

DBMS 2 Marks Questions

DBMS 2 Marks Questions from GATE previous years papers
Shaded items are complete.


6 Responses to “GATE DBMS: Subject Wise Solved Question Papers”

  1. Superb Post Bro,

    Do this for all subjects

    • priya says:

      Q- 1. Answer following: (any 7). 14
      1. What is a NULL value?
      A:- A NULL value is also known as Unknown.
      A NULL is used when an entity does not have a value for any attribute.
      2. Name any 4 DBMS?
      A:- FOXPRO, MS-Access, SQL Server, MY SQL, ORACLE, etc.
      3. What are disjoint and overlapping design constraints?
      A:- Disjoint: Disjoint constrain specifies the relationship between members of the sub-classes. These sub-classes can either be disjoint or overlapping.
      A disjoint-ness constraint requires that an entity belong to no more than one lower-level entity set.
      In a disjoint-ness design constraint, an entity can belong to not more than one lower-level entity set
      In overlapping generalizations, the same entity may belong to more than one lower-level entity set within a single generalization. For an illustration, consider the employee work team example, and assume that certain managers participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower-level entity sets of employee
      In overlapping generalizations, the same entity may belong to more than one lower-level entity sets.
      The disjoint rule states an entity instance of a super type can only be a member of one subtype.
      The overlap rule states an entity instance of a super type can be a member of multiple subtypes.
      4. What is candidate key?
      • A candidate key is sufficient to identify each and every entity uniquely within an entity set.
      • Candidate key is a minimal of super key.
      • If a relation contains more than one relation keys, then they each are called Candidate key.
      5. List the functions of file manager.
      • System-Level Data Recovery.
      • Application-Level Data Recovery.
      • Application Data Availability.
      • Multi-Level Data Security.
      • DBMS Autonomics and Process Automation.
      • Application Performance.
      6. What is Query?
      A: – A query is a statement requesting the retrieval of information.
      The set of operations to answer a query. Such operations define algorithms that make use of access methods.
      7. How redundancy can be reduced?
      A: – Due to centralized database, it is possible information. And it leads to reduced data redundancy.
      Reduced data redundancy prevents memory wastage.
      Also, it eliminates extra processing time to get required data in a large database.
      8. What is system R?
      A: – R is a relation schema.
      9. Difference between logical and physical independence?
      • Logical data independency is the ability to modify the logical (conceptual) schema without requiring any change in applications programs.
      Physical data independency is the ability to modify the physical (internal) schema without requiring any change in application programs.
      • Logical data independency, modifications at the logical level are necessary whenever the logical structure of the database is altered.
      Physical data independency modifications at the internal level are occasionally necessary to improve performance.
      • Logical data independency separates external level from the conceptual view.
      Physical data independency separates conceptual level from the internal level.
      • Comparatively, it is difficult to achieve Logical data independency.
      Comparatively, it is easy to achieve Physical data independency.

      10. What is usage of foreign key? Explain with example.
      • A foreign key is a set of one or more columns whose values are derived from the primary key or unique key of other table. A foreign key is used to maintain or ensure consistency among records of the two tables.
      • A foreign key is used to establish relationships among relations in the relational model. Technically, a foreign key is a column (or columns) appearing in one relation that is (are) the primary key of another table. Although there may be exceptions, the values in the foreign key columns usually must correspond to values existing in the set of primary key values. This correspondence requirement is created in a database using a referential integrity constraint on the foreign key.
      11. What do you mean by total participation in a relationship?
      A: – Total participation:
      • Every member of entity set must participate in the relationship
      • Represented by double line from entity rectangle to relationship diamond
      • In a relational model we will use the references clause.
      12. What is difference between IN and = operator.
      A: – In IN operator, IN compares single value to a set of values provided with in predicate.
      In = operator, = compares single value to another single value.
      13. List the requirements DBMS.
      14. List out any 2 DDL statements and any 2 TCL statements.
      A: – DDL: Data Definition Language.
      • Create, alter, drop and truncate.
      TCL: Transaction Control Language.
      DML: Data Mainpulation Language.
      • Insert, update, delete, and lock.
      DQL: Data Query Language.
      • Select.
      DCL: Data Control Language.
      • Commit rollback, savepoint, grant and revoke.
      15. What is data manager? List responsibilities of database manager.
      A: – Databases typically require lots of storage space (gigabytes). This must be stored on disks. Data is moved between disk and main memory (MM) as needed.
      The goal of the database system is to simplify and facilitate access to data. Performance is important. Views provide simplification.
      So the database manager is responsible for:
       Interaction with the file manager: Storing raw data on disk using the file system usually provided by a conventional operating system. The database manager must translate DML statements into low-level file system commands (for storing, retrieving and updating data in the database).
       Integrity enforcement: Checking that updates in the database do not violate consistency constraints (e.g. no bank account balance below $25)
       Security enforcement: Ensuring that users only have access to information they are permitted to see.
       Backup and recovery: Detecting failures due to power failure, disk crash, software errors, etc., and restoring the database to its state before the failure.
       Concurrency control: Preserving data consistency when there are concurrent users.

      16. Difference between trivial and non-trivial dependency.
      Answer: – Trivial V/S Non-trivial.
      • TRIVAL:-A function dependency is trivial if it is satisfied by all instances of relation.
       A FD: X->Y is Trivial if and only if the right hand side is a subset of the left hand side.
      • NON-TRIVIAL:- A function dependency is non- trivial if it is satisfied by all instances of relation.
       In other words, a FD: X->Y is non-trivial if Y is not contained in X.
      17. What is query processor?
       A: – It is one of the functional components of DBS. It translates statements in a query language into low-level instructions the database manager understands. It may also attempt to find an equivalent but more efficient form.
      It contains following components:
      a. DML compiler – It converts DDL statements to a set of tables containing metadata stored in a data dictionary. It also performs query optimization.
      b. DDL interpreter – It interprets DDL statements and records definitions into data dictionary.
      c. Query evaluation engine – It executes low-level instructions generated by DML compiler.
      They mainly deal with solving all problems related to queries and query processing. It helps database system simplify and facilitate access to data.
      Query Processor: It translates statements in a query language into low-level instructions the database manager understands. It may also attempt to find an equivalent but more efficient form.
      18. What is physical data modeling?
      A: – Physical data modeling are used for a higher level description of storage structure and access mechanism.
      19. Describe multivalued dependencies.
      A: – A multivalued dependency is a full constraint between two sets of attributes in a relation.
      20. What is logical data independence?
      A: – Logical data independency is the ability to modify the logical (conceptual) schema without requiring any change in applications programs.
      21. Define DBMS.
      A: – A database management system is a collection of inter-related data and a set of programs to manipulate those data.
      In other words, DBMS can be described as: – DBMS=Database + A set of Programs.
      The primary goal of a DBMS is to provide efficiently and convenience in storing and retrieving database information.
      22. What is difference between drop and delete?
      • Delete statement performs conditional based deletion, whereas Drop command deletes entire records in the table.
      • Delete statement removes only the rows in the table and it preserves the table structure as same, whereas, Drop command removes all the data in the table and the table structure.
      • Delete operation can be rolled back and it is not auto committed, while Drop operation cannot be rolled back in any way as it is an auto committed statement.

  2. reka says:

    thanks…great effort…kindly do it for TOC,CN also…

  3. pihoo says:

    please provide me answers of question papers of sy-bca sem-3 from vnsgu i.e. rdbms,data structure,c++,software engineering of previous five years. before 20-10-2012

  4. Suchismita Rout says:

    Great..good job..carry on..:)

Leave a Reply

© 2015 Techvyom. All rights reserved. Site Admin · Entries RSS · Comments RSS
Powered by WordPress · Designed by Theme Junkie
Read more:
NIT IIIT MTech Admissions 2013 Through GATE Score Cards

As you may be knowing that last year NITs conducted joint counselling for MTech Admissions. This year also there will...