304
CSE/IT/DS/CS
Jharkhand University of Technology, Ranchi
B.Tech. 3rd Semester Examination, 2024 (NEP)
Subject : Database Management System Subject Code : CSE-304
Time Allowed : 3 Hours Full Marks :70
Answer in your own words.
Answer any five questions in which Question No.1 is compulsory.
The figures in the nargin indicate full marks.
All questions carry equal narks.
1. Choose the correct answer: 2×7=14
(i) Which type of data can be stored in the database?
(a) Image oriented data (b) Data in the form of audio or video
(c) Text, files containing data (d) Allof these
(ii) In SQL the command 'Insert' is
(a) Data Manipulation Language command
(b) Data Query Language command
(c) Data Definition Language command
(d) Data Control Language command
(ii) What is information about data called?
(a) Hyper data (b) Meta data
(c) Tera data (d) Relations
(iv) Transaction processing is associated with everything below except
(a) producing detail summary or exception reports.
(b) confirming an action or triggering a response.
(c) recording a business activity.
(d) maintaining a data.
(v) The uniqueness of each row in a database table is ensured by
(a) Primary Key (b) Super key
(c) Foreign key (d) Candidate key
(vi) Identify the characteristics of transactions
(a) Atomicity (b) Durability
(d) All of the mentioned
(c) Isolation
Please Turn Over
37472
652
CSE/IT/DS/CS
Jharkhand University of Technology, Ranchi
B.Tech. 3rd Semester Examination, 2024 (NEP)
Subject : Database Management System Subject Code : CSE-304
Time Allowed : 3 Hours Full Marks :70
Answer in your own words.
Answer any five questions in which Question No.1 is compulsory.
The figures in the nargin indicate full marks.
All questions carry equal narks.
1. Choose the correct answer: 2×7=14
(i) Which type of data can be stored in the database?
(a) Image oriented data (b) Data in the form of audio or video
(c) Text, files containing data (d) Allof these
(ii) In SQL the command 'Insert' is
(a) Data Manipulation Language command
(b) Data Query Language command
(c) Data Definition Language command
(d) Data Control Language command
(ii) What is information about data called?
(a) Hyper data (b) Meta data
(c) Tera data (d) Relations
(iv) Transaction processing is associated with everything below except
(a) producing detail summary or exception reports.
(b) confirming an action or triggering a response.
(c) recording a business activity.
(d) maintaining a data.
(v) The uniqueness of each row in a database table is ensured by
(a) Primary Key (b) Super key
(c) Foreign key (d) Candidate key
(vi) Identify the characteristics of transactions
(a) Atomicity (b) Durability
(d) All of the mentioned
(c) Isolation
Please Turn Over
37472
652
