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 2022, 2021, 2020 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 - B    


Q. 1Based on the usages of database file, give
the classification of the same
 A)Master file, Backup file and Permanent file
 B)Temporary file, Reference file, Local file, Permanent file
 C)Physical file, Logical file, Transaction file and Master file
 D)Master file, Transaction file, Reference file and History file
   
Q. 2 _______ refers to the range of valid entries
for a given column
 A)Entity integrity
 B)Domain integrity
 C)Referential integrity
 D)None of the above
   
Q. 3Per Seat License



 A)Client Access License is assigned to a workstation.
 B)Unlimited number of simultaneous workstation connections to multiple servers,
 C)Both A) and B)
 D)Neither A) nor B)
   
Q. 4State T or F
I) Indexes accelerate data re
II) Normalization is process of organization data
into
III) Indexes are created and maintained in
descending sorted order
V) Each table can have only one clustered
table.
 A)TTFT
 B)TFFT
 C)TTTT
 D)TFFF
   
Q. 5 What are the criteria to be considered,
while designing a database from users point of
view?
a) Meaningful grouping of attributes
b) No inapplicable attributes
c) Define constraints so that correctness of data
will be ensured.
d) Uniformity in naming and definitions of the
data items
 A)a), b), c) and d)
 B)a), and c)
 C)b), and d)
 D)a), b) and d)
   
Click here to get Database Management Systems (BT0066 ) New Question


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