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 2024, 2023, 2022 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. 1Match the following
SET A
i. Master
ii. Model
iii. Msdb
iv. Tempdb
SET B
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.
c
 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
   
Q. 2Match 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. 3To locate required block on a track is called
latency time. It is also known as ______
 A)Seek-time
 B)Rotational delay
 C)Rotational Time
 D)Transfer Rate
   
Q. 4Select * from tablename will
 A)include all columns of table
 B)include all rows of table
 C)Both A & B
 D)Neither A nor B
   
Q. 5Match the following Type of integrity with
their constraint type
SET A
i. Domain
ii. Entity
iii. Referential
SET B
a. DEFAULT, CHECK
b. PRIMARY, UNIQUE
c. FOREIGN, KEY
 A)i – a, ii – b, iii – c
 B)i – b, ii – c, iii – a
 C)i – c, ii – a, iii – b
 D)i – a, ii – c, iii – b
   
Click here to get Database Management Systems (BT0066 ) New Question


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