Question Papers For Board Examinations 2018

Class – XII

Subject – Database Management Application

Subject : Database Management Application

Class : XII

Year : 2018

General Instructions :

• Please check that this question paper contains 4 printed pages.
• Code number given on the right hand side of the question paper should be written on the title page of the answer-book by the candidate.
• Please check that this question paper contains 4 questions.
• Please write down the Serial Number of the question before attempting it.
• 15 minute time has been allotted to read this question paper. The question paper will be distributed at 10.15 a.m. From 10.15 a.m. to 10.30 a.m., the students will read the question paper only and will not write any answer on the answer-book during this period.

Questions :

SECTION A

1. Multiple Choice Questions (Choose the most appropriate option) : 1x6=6
(a) Consider the statement :
Employee (Employee_id, Emp_name, designation)
Here the Employee_id, Emp_name and designation are _______ and Employee is a ___________ . 1
(i) Tuples, Relation
(ii) Attributes, Relation
(iii) Tuples, Attribute
(iv) Relations, Attribute

(b) A group of statements which get executed based on a condition is called 1
(i) Selection
(ii) Sequential
(iii) Iteration
(iv) None of these

(c) Which SQL command is used to modify the structure of any table ? 1
(i) MODIFY TABLE
(ii) ALTER TABLE
(iii) UPDATE TABLE
(iv) CHANGE TABLE

(d) Which of the following is true regarding Referential Integrity ? 1
(i) Each primary key value must match a primary key value in a related table.
(ii) Each primary key value must match a foreign key value in a related table.
(iii) Each foreign key value must match a primary key value in a related table.
(iv) Each foreign key value must match a foreign key value in a related table.

(e) Which segment do eBay and Amazon belong to ? 1
(i) B2B (Business to Business)
(ii) C2C (Consumer to Consumer)
(iii) C2B (Consumer to Business)
(iv) B2C (Business to Consumer)

(f) Which of the following statement(s) is/are true in relation to B2C (Business to Consumer) commerce ? 1
I. Business gets a wide reach to customers.
II. Availability 24 hours a day seven days a week.
III. Privacy of transaction is always maintained.
(i) I and II
(ii) II and III
(iii) I and III
(iv) I only

SECTION B

2. Short Answer Questions : 2x8=16
(a) State any two advantages of using DBMS over traditional file system. 2

(b) Find the output of the following code. How many times will the loop be executed ? 2
for (int count = 1; count <= 10; count = count + 2)
{
System.out.println (count);
}

(c) Define Variable. Write the code to declare a variable to store your age. 2

(d) What is NULL value ? Write the query to retrieve all the records from table ‘Result’ where marks are NULL. 2

(e) What do you mean by Work Integrated Learning ? Give example. 2

(f) Why is Java known as a Platform independent language ? 2

(g) Write any two advantages of Online learning. 2

(h) What do you mean by Entity and its attribute ? 2

Click Here To Download Full Paper

<< Go Back To Main Page

Courtesy: CBSE