P2Pprogrammer 2 programmer

Home > Download > SMU - Question Paper > BSc IT > BT0066

Database Management Systems

This is the collection of Sikkim Manipal University (SMU) question and answers for Database Management Systems . It will help to prepare your examination. All question paper are classified as per semester, subject code and question type of Part A, Part B and Part C with multiple choice options as same as actual examination. SMU question papers includes year 2023, 2022, 2021 Sem I, II, III, IV, V, VI examinations of all subjects.

SMU question test set of old, last and previous year are updated regularly and it is absolutely free to use. Question paper includes Visual basic 6, VB.Net, C#, ASP.Net, Web, Oracle, Database, SQL, Software Engineering, C, C++, OOPS, MBA, MCA, BSC IT I have requested you kindly send me the question paper of Database Management Systems , SMU - Bachelor of Science in Information Technology.

Course Name        BSc IT (Bachelor of Science in Information Technology)

Subject Code       BT0066 (Database Management Systems )

Get Questions        PART - A    PART - B    PART - C

Subject : Database Management Systems

     BT0066 : PART - C    

Q. 1Which of the following are DBMS utilities
i. Loading
ii. Storage
iii. Backup
iv. Performance monitoring
 A)i, ii, and iii
 B)iii, iv, v
 C)I, iii, iv, v
 D)All of the above
Q. 2Match the following types of access
methods with their description
Set A
Set B
a. an index based access is permitted for the
root record
b. the random access to root records is
provided using an index.
c. direct access to the root records is provided
using hashing & chaining method
d. child record of a particular parent are stored
consecutively after the parent itself
 A)1 - a, 2 - d, 3 - c, 4 - b
 B)1 - a, 2 - c, 3 - d, 4 - b
 C)1 - d, 2 - b, 3 - c, 4 - a
 D)1 - d, 2 - a, 3 - c, 4 - b
Q. 3Match the following
Set A
i. Domain Integrity
ii. Entity Integrity
iii. Referential Integrity
Set B
a. Default, Check
b. Primary key, unique
c. Foreign key
 A)i-a, ii-b, iii-c
 B)i-b, ii-a, iii-c
 C)i-c, ii-a, iii-b
 D)i-a, ii-c, iii-b
Q. 4Give the important performance measures
of a file organization.
a) time to process the data
b) time required to transfer data between
device and memory
c) time spent in waiting for processor and
device ability which is dependent on system
and its load
d) time required to locate data on device
e) time required for comparing files where
different number of sequential and random
access is required.
 A)a), b), c), d)
 B)b), c), d) and e)
 C)b) and only
 D)all a), b), c), and e)
Q. 5Match the following
i. Master
ii. Model
iii. Msdb
iv. Tempdb
a. records all of the system level information for
a SQL Server system
b. is used as the template for all databases
created on a system.
 A)i – a, ii – b, iii – c, iv – d
 B)i – b, ii – c, iii – d, iv – a
 C)i – c, ii – d, iii – a, iv – b
 D)i – d, ii – a, iii – b, iv – c
Click here to get Database Management Systems (BT0066 ) New Question

Home > Download > SMU - Question Paper > BSc IT > BT0066