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 2024, 2023, 2022 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 - C
Q. 1 | 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 row within the result set
d. Returns prev |
| 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. 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 | In transaction model, ______ implements start, commit, abort besides read & write, provides resilience to failures |
| A) | Buffer Manager |
| B) | Recovery Manager | | C) | Scheduler | | D) | Transaction Manager | | | | Q. 4 | 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 | | | | Q. 5 | Database server function includes: 1 Query optimization 2. Stored procedure 3. Transaction management 4. Compile queries 5. Backup & recovery 6. Data Management |
| A) | 2, 3, 4, 5, 6 |
| B) | 1, 2,3,5,6 | | C) | 1, 2,3,4,5 | | D) | 1, 2, 3, 4, 5, 6 | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034