Question Papers For Board Examinations 2019

Class – XII

Subject – Database Management Application

Subject : Database Management Application

Class : XII

Year : 2019

General Instructions :

(i) This question paper contains 31 questions, out of which the candidate needs to attempt only 23 questions.
(ii) Question paper is divided into two sections.

SECTION A

• Multiple choice questions / Fill in the blanks/Direct questions : contains total 12 questions of 1 mark each. Answer any 10 questions.
• Very short answer type questions : contains total 7 questions of 2 marks each. Answer any 5 questions. 
• Short answer type questions : contains total 7 questions of 3 marks each. Answer any 5 questions.

SECTION B

• Long answer / Essay type questions : contains total 5 questions of 5 marks each. Answer any 3 questions.

Questions :

SECTION A

Multiple Choice Questions (Choose the most appropriate option). Attempt any ten questions from the following : 1x10=10

1. The set of all possible values that an attribute may contain is called the ___________ of an attribute. 1
(a) Domain
(b) Relation
(c) Set
(d) Schema

2. If x = 20, y = 10, what will be the value of x, if we write the statement x +=  y ? 1
(a) 30
(b) 20
(c) 10
(d) 21

3. Identify the operator that performs pattern searching in MYSQL. 1
(a) EXISTS operator
(b) BETWEEN operator
(c) LIKE operator
(d) SEARCH operator

4. Which of the following is not a DDL statement ? 1
(a) CREATE
(b) SELECT
(c) ALTER
(d) DROP

5. The term used to describe the information, systems and applications that support and drive business processes, most often using web technologies, is called 1
(a) E-education
(b) E-governance
(c) E-commerce
(d) E-business

6. Which one of the following is not a search engine ? 1
(a) Bing
(b) Yahoo
(c) Google
(d) Windows

7. Which of the following is an SQL aggregate function ? 1
(a) Max
(b) Avg
(c) Sum
(d) Count

8. Which SQL statement is used to update data in a database ? 1
(a) Save
(b) Update
(c) Saveas
(d) Modify

9. An expression involving byte, int and literal numbers is promoted to which
of these ? 1
(a) int
(b) long
(c) byte
(d) bloat

10. Which of these is an incorrect statement ? 1
(a) It is necessary to use new operator to initialize an array.
(b) Array can be initialized using comma separated expressions
surrounded by curly braces.
(c) Array can be initialized when it is declared.
(d) None of the above

11. What is the output of relational operators ? 1
(a) Integer
(b) Boolean
(c) Characters
(d) Double

12. An example of broadcasting model of E-governance is _____________. 1
(a) Online cheque transfer
(b) Online judgements
(c) Online cash transfer
(d) None of the above 

Click Here To Download Full Paper

<< Go Back To Main Page

Courtesy: CBSE