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 | Select * 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. 2 | SQL SERVER installation options are
i. Licensing Mode
ii. Network Support
iii. Character Set
iv. Sort Order
v. Unicode Collation |
| | A) | i, ii, iv only |
| B) | i, iii, v only | | C) | ii, iii, iv only | | D) | i, ii, iii, iv, v only | | | | | Q. 3 | Limitations of sequential file are |
| | A) | Used for small files |
| B) | Used for intermediate results of operations | | C) | Used when the file has high hit ratio but
infrequent updates | | D) | All of the above | | | | | Q. 4 | Match the following with respect to cursors
Set A
i. Prior
ii. First
iii. Last
iv. Absolute n
v. Relative n
Set B
a. Returns last row within the result set
b. Returns first row within the result set
c. Returns nth r |
| | A) | i-a, ii-b, iii-c, iv-d, v-e |
| B) | i-d, ii-b, iii-a, iv-c, v-e | | C) | i-b, ii-e, iii-c, iv-a, v-d | | D) | i-c, ii-a, iii-d, iv-e, v-b | | | | | Q. 5 | Match 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 | | | |
Click here to get
Database Management Systems (BT0066 )
New Question
Home > Download > SMU - Question Paper
> BSc IT > BT0066