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 | RELTAB table contains: |
| A) | definition of indexes |
| B) | definition of columns declared as unique | | C) | description of user defined tables | | D) | description of column defined for tables | | | | Q. 2 | ______ database is used as template for all
databases created |
| A) | Master |
| B) | Model | | C) | Tempdb | | D) | None of the above | | | | Q. 3 | The sequential file is used. |
| A) | when the file has high hit ratio but
infrequent updates |
| B) | for small files | | C) | for intermediate results of operations | | D) | All the above | | | | Q. 4 | In which of the following situations, sequential file organization is not preferred? |
| A) | In which of the following situations,
sequential file organization is not preferred? |
| B) | For intermediate results of operations | | C) | For small files | | D) | None of these | | | | Q. 5 | _____ indexes use more than one column
in a table to index data |
| A) | Unique |
| B) | Composite | | C) | Both A) and B) | | D) | Neither A) nor B) | | | | Q. 6 | _________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. 7 | _____ 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. 8 | In DBMS, ____ refers to the rights of individuals and organizations so that they can decide who could be permitted access to their data |
| A) | Data Integrity |
| B) | Security | | C) | Privacy | | D) | Correctness | | | | Q. 9 | The ________ expression returns one of many values that satisfy the condition & is mainly used to represent data to the external user |
| A) | Case Value |
| B) | Row Value | | C) | Nullif & Coalesce | | D) | Both A) & B) | | | | Q. 10 | ______ converts data but does not support
styles |
| A) | Convert |
| B) | Cast | | C) | Typecast | | D) | None of these | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034