NIELIT Question Paper : A Level Course Introduction to Database Management System
Name of the Institute : National Institute of Electronics and Information Technology (nielit.gov.in)
Name of the Course : A Level Course
Subject Code/Name : A7R4/Introduction to Database Management System
Document Type : Old Question Paper
Location : India
Website : nielit.gov.in
Download Model/Sample Question Paper :
January 2012 : https://www.pdfquestion.in/uploads/nielit.in/7080-jan12A7-R4.pdf
JULY 2012 : https://www.pdfquestion.in/uploads/nielit.in/7080-jul12A7-R4.pdf
January 2013 : https://www.pdfquestion.in/uploads/nielit.in/7080-jan13A7-R4.pdf
JULY 2013 : https://www.pdfquestion.in/uploads/nielit.in/7080-jul13A7-R4.pdf
January 2014 : https://www.pdfquestion.in/uploads/nielit.in/7080-jan14A7-R4.pdf
July 2014 : https://www.pdfquestion.in/uploads/nielit.in/7080-jul14A7-R4.pdf
NIELIT Database Management System Sample Paper :
A7-R4:
PART ONE
(Answer all the questions)
1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1×10)
Related : NIELIT Question Paper A Level Course Data Structures Through C++ : www.pdfquestion.in/7079.html
1.1 Which one of the following is not an example of 1:N relationship?
A) Faculty-belongsto-Department
B) BANK-has-Branches
C) University-has-Vicechancellor
D) None of the above
1.2 Consider the relation R(ABCDE) with following functional dependencies:
AB ® C, CD ® E, DE ® B
The key of the relation is
A) AC
B) AB
C) ABD
D) A
1.3 Capacity to change Conceptual schema without making changes in external schema is called
A) Logical Data Independence
B) Physical Data Independence
C) Both A) and B)
D) None of the above
1.4 In Database Systems, language used to specify Conceptual and Internal Schema is called
A) DML
B) DDL
C) VDL
D) None of the above
1.5 Collection of concepts used to describe a database is called
A) Schema
B) Model
C) Meta data
D) None of the above
1.6 Clustering indexes are created on
A) Every file
B) File sorted on a key value
C) File sorted on a Non-key value
D) None of the above
1.7 A relational database which is in 2NF may still have undesirable data redundancies because there may exist
A) Non-Trivial functional dependencies involving prime attributes on RHS.
B) Trivial functional dependencies involving prime attribute only on LHS.
C) Transitive functional dependencies.
D) Non-Trivial functional dependencies involving prime attributes on LHS only.
1.8 Relationship is an association among
A) Two entities
B) Three entities
C) Two or More entities
D) None of the above
1.9 Which of the following command is used to remove the table from database?
A) Delete
B) Remove
C) Drop
D) None of the above
1.10 Which of the following is not an example of aggregate function?
A) COUNT
B) MAX
C) AVC
D) None of the above
2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and ENTER in the “tear-off” sheet attached to the question paper, following instructions therein. (1×10)
2.1 COUNT function will not count NULL values if used with a column name.
2.2 Group by function cannot group the data from the source table based on more than one column.
2.3 Null values are required when the value of the attribute is 0.
2.4 An entity in a subclass inherits all the attributes as well as relationships of its super class.
2.5 An entity can participate in more than one relationship type.
2.6 Primary key can have redundant attributes.
2.7 Tuples in a relation are always inserted in a order.
2.8 Using Distinct clause we can print duplicate values.
2.9 Having clause is used with grouping function
2.10 A category can be total or partial.
4.1 The BETWEEN operator is used to specify a ________ of values.
4.2 ________ entity do not have key attribute.
4.3 ________ is done through the like operator.
4.4 Without any joining condition the join becomes ________.
4.5 ________ operator combines two or more queries into one result.
4.6 ________ attributes can be divided into smaller parts.
4.7 Description of data stored in a database is called ________.
4.8 ________ commands are used to insert records in a table.
4.9 Constraints that says primary key cannot be null is called ________ constraints.
4.10 ________ key can have NULL value.
PART TWO
(Answer any FOUR questions) 5.
a) What is the goal of having three different levels of a database?
b) What is Data Independence? Explain Logical Data Independence and Physical Data Independence with the help of examples.
c) What is Program-data Independence? Explain. (4+6+5)
6. a) How redundancy is controlled in DBMS?
b) What are cardinality ratios? What are the possible cardinality ratios for a binary relationship? Explain with examples.
c) Differentiate between Primary Key and Candidate Key. (5+6+4)
I need important questions of DBMS for nielit for July exam 2017.
Nice questions but posted some more important questions