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 - C    


Q. 1Database server functions are:
i. Data management
ii. Backup and recovery
iii. Compile queries
iv. Result formatting & presentation
v. Query optimization
 A)i, iii, iv
 B)only ii
 C)i, ii, v
 D)All of the above
   
Q. 2i. The EXECUTE statement cannot include a
string literal, a string local variable, or a
concatenation of both.
ii. All items within the EXECUTE string must
consist of character data; you, must convert all
numeric data prior to using th
 A)i – T, ii – T, iii – T, iv – T
 B)i – T, ii – F, iii – T, iv – F
 C)i – F, ii – T, iii – F, iv – T
 D)i – F, ii – F, iii – F, iv – F
   
Q. 3_______ is defined between two record
types representing one-to-many / one-to-one
relationship
 A)Link
 B)Join
 C)Dependency
 D)Trees
   
Q. 4Match the following
SET A
i. Constraint
ii. Rule
iii. View
iv. . Stored procedure
SET B
a. Defines rules regarding the values allowed in
columns and is the standard mechanism for
enforcing database integrity.
b. Con
 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. 5Of the following, which is not a fact for
creating Clustered Index?
a. Each table can have only one clustered index
b. The physical row order of the table and the
order of rows in the index are the not same
c. Uniqueness of key values
 A)only a and b
 B)only b and d
 C)a, b, c
 D)All the above
   
Click here to get Database Management Systems (BT0066 ) New Question


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