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 - B
| Q. 1 | Match the Following:
Set A:
i DDL
ii DML
iii DCL
Set B:
a. insert, delete, modify
b. grant, revoke
c. modify, grant, revoke
d.create, drop, alter |
| | A) | i-d, ii-a, iii-b |
| B) | i-d, ii-c, iii-b | | C) | i-a, ii-d, iii-c | | D) | i-d, ii-a, iii-c | | | | | Q. 2 | Out of following, which is not a type of
operator in SQL? |
| | A) | Arithmetic |
| B) | Comparison | | C) | Both A) and B) | | D) | Neither A) nor B) | | | | | Q. 3 | A composite index uses more then one
_______ to index data. |
| | A) | row |
| B) | column | | C) | table | | D) | database | | | | | Q. 4 | Select sname, coursename, idue from
studentinfo where idue in (5500, 12000)
The above query returns |
| | A) | all the records whose idue value greater than
5500 and less than 12000 |
| B) | all the records whose idue value greater than
5500 | | C) | all the records whose idue value greater
than 12000 | | D) | all the records of idue value 5500 and 12000 | | | | | Q. 5 | Based on the usages of database file, give
the classification of the same |
| | A) | Master file, Backup file and Permanent file |
| B) | Temporary file, Reference file, Local file,
Permanent file | | C) | Physical file, Logical file, Transaction file and
Master file | | D) | Master file, Transaction file, Reference file
and History file | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034