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 | State whether true or false
i. Indexes enforces uniqueness
ii. Indexes are created and maintained in
ascending sorted order
iii. Indexes are not created on columns of high
degree of selectivity
iv. Indexes not accelerate queries |
| | A) | TTFF |
| B) | TFTF | | C) | TTFT | | D) | FFTT | | | | | Q. 2 | Match the following
SET A
i. SQL Server Enterprise Manager
ii. SQL Server Client Configuration Utility
iii. SQL Server Performance Monitor
iv. SQL Server Profiler
SET B
a. Primary graphical management interface for
SQL Server. Uses Database Designer and Q |
| | 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 | | | | | Q. 3 | 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 | | | | | Q. 4 | 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. 5 | 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 | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034