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 2025, 2024, 2023 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. 1 | Following are the types of operators i. Arithmetic ii Comparison iii String Concatenation iv. Logical |
| A) | only i & iii |
| B) | only ii & iv | | C) | All the above | | D) | None of the above | | | | Q. 2 | Stored Procedures can i. Share Application Logic ii. Encapsulate Business Functionality iii. Provide security Mechanisms iv. Automatically Execute v. Increase Performance vi. Reduce Network Traffic |
| A) | i, ii, iii, vi only |
| B) | i, iv, v only | | C) | None of the above | | D) | All of the above | | | | Q. 3 | What are the advantages of 3-schema architecture. 1. provides data independence only at physical levels 2. changes can be carried out to the internal schema for the improvement in performance, without any impact on the user program 3. facilities easy growth & allows large application to develop in phases 4. provides independence to the existing application & allows to add new kinds of data & user application. 5. security to the stored data is achieved |
| A) | 2, 3, 4, 5 |
| B) | 1, 2, 3, 4, 5 | | C) | 1, 3, 4, 5 | | D) | 1, 2. 3, 4 | | | | Q. 4 | Match 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 | | | | Q. 5 | To 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 | | | |
Click here to get
Database Management Systems (BT0066 )
New Question
Home > Download > SMU - Question Paper
> BSc IT > BT0066