Home > Download > SMU - Question Paper
> MSc IT > MT0034
DBMS & SQL server
This is the collection of
Sikkim Manipal University (SMU) question and answers for DBMS & SQL server. 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 2026, 2025, 2024 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 DBMS & SQL server, SMU - Master of Science in Information Technology.
Course Name
MSc IT (Master of Science in Information Technology)
Subject Code MT0034 (DBMS & SQL server)
Get Questions
PART - A
PART - B
PART - C
Subject : DBMS & SQL server
MT0034 : PART - A
| Q. 1 | _____ number of columns can be specified
in ORDERBY clause |
| | A) | 8 |
| B) | 16 | | C) | 32 | | D) | 256 | | | | | Q. 2 | ____is time to locate required block on a
track. |
| | A) | Latency time |
| B) | Seek time | | C) | Transfer rate | | D) | Lead time | | | | | Q. 3 | To disable constraint, include the ______
option in alter table statement |
| | A) | NOCHECK |
| B) | WITH NOCHECK | | C) | Either A) or B) | | D) | Neither A) nor B) | | | | | Q. 4 | The setup program creates db and log files
for ________ db.
i) Master
ii) Model
iii)Tempdb
iv)msdb
v) pubs
vi) North wind |
| | A) | i, iii, iv |
| B) | i, ii,iii, v, vi | | C) | i, iii, iv, vi. | | D) | All of the above | | | | | Q. 5 | In Transaction Processing Model,
implements start, commit, abort besides read &
write & provides resilience to failures |
| | A) | Buffer Manager |
| B) | Recovery Manager | | C) | Scheduler | | D) | Transaction Manager | | | | | Q. 6 | For using a specific database _______
command is used |
| | A) | use databasename |
| B) | databasename use | | C) | both A & B | | D) | neither A nor B | | | | | Q. 7 | The DBMS utility, ____ allows to
reconstruct the correct state of database from
the backup and history of transactions |
| | A) | Backup |
| B) | Recovery | | C) | Monitoring | | D) | Data loading | | | | | Q. 8 | ____________ application is responsible
business logic ad presenting data to the user |
| | A) | Database |
| B) | Client | | C) | Server | | D) | none of the above | | | | | Q. 9 | Which of these is incorrect statement |
| | A) | A candidate key is minimal super key |
| B) | The number of tuples in a relation is called
its cardinality | | C) | The columns ofa relation are called tuples | | D) | None of the above | | | | | Q. 10 | To eliminate duplicate rows _____ is used |
| | A) | NODUPLICATE |
| B) | ELIMINATE | | C) | DISTINCT | | D) | None of these | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034