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 | To print a list of system stored procedures
and owner names in database use the ____
system stored procedures |
| A) | sp_stored |
| B) | stored_procedures | | C) | sp_procedures | | D) | sp_stored_procedures | | | | Q. 2 | _________utility is used to connect to SQL
server. |
| A) | SQL server Query analyzer. |
| B) | SQL server Enterprise Manager. | | C) | Both A and B | | D) | Neither A and B | | | | Q. 3 | ___________ clause is an additional filters
that is applied to the result |
| A) | select |
| B) | group-by | | C) | having | | D) | order by | | | | Q. 4 | The number of attributes in a relation is called as its ____ |
| A) | Cardinality |
| B) | Degree | | C) | Tuples | | D) | Entity | | | | Q. 5 | Select the wrong statement |
| A) | A primary key is a minimal superkey |
| B) | An entity may have many candidate keys | | C) | A weak entity is always related to one or
more strong entities | | D) | All the above | | | | Q. 6 | _____ keyword is used to retrieve rows
within specified range of values |
| A) | BETWEEN |
| B) | AND | | C) | IN | | D) | None of these | | | | Q. 7 | To start SQL server as an application instead
of as windows NT server u can _________ |
| A) | Use SQL server agent. |
| B) | Type SQL server at command prompt | | C) | Not able to use as application | | D) | Both A and B | | | | Q. 8 | A complete new server installation require
________ Hard disk space |
| A) | 32.MB |
| B) | 50.MB | | C) | 90.MB | | D) | 148MB | | | | Q. 9 | _____ keyword specifies the condition on
which tables are to be joined and how to join
them |
| A) | FROM |
| B) | ON | | C) | JOIN | | D) | None of these | | | | Q. 10 | SQL server stores index information in the
_____ system table |
| A) | sysindexes |
| B) | systemindexes | | C) | sysind | | D) | sysindexes | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034