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 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 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 | 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. 2 | __________ is a precompiled, named colleen
of Transact- SQL statements that executes to
gathers |
| | A) | Stored procedure |
| B) | Trigger | | C) | constraint | | D) | None of the above | | | | | Q. 3 | In an ER model, ____ is described in the
database by storing its data. |
| | A) | Entity |
| B) | Attribute | | C) | Relationship | | D) | Notation | | | | | Q. 4 | _______ are physical files that are used in
transact SQL Statement and operating system
file names.
I) *. Mdf
II) *. Ndf
III) *. Ldf
IV) *. Mdb |
| | A) | (I) & (IV) |
| B) | (I), (II), (III) | | C) | (I) (III), (IV) | | D) | All the above | | | | | Q. 5 | _______ holds all temporary tables and
temporary stored procedures |
| | A) | model |
| B) | msdb | | C) | Tempd | | D) | Northwind | | | | | Q. 6 | _____ table store information about
database or about the system |
| | A) | SQL |
| B) | Nested | | C) | System | | D) | None of these | | | | | Q. 7 | ___________ clause is an additional filters
that is applied to the result |
| | A) | select |
| B) | group-by | | C) | having | | D) | order by | | | | | Q. 8 | ____is time to locate required block on a
track. |
| | A) | Latency time |
| B) | Seek time | | C) | Transfer rate | | D) | Lead time | | | | | Q. 9 | 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. 10 | ____________ is full form of SQL |
| | A) | standard query language |
| B) | sequential query language | | C) | structured query language | | D) | server side query language | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034