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 | In snapshot, ______ clause tells oracle how long to wait between refreshes. |
| A) | COMPLETE |
| B) | FORCE. | | C) | NEXT | | D) | REFRESH | | | | Q. 2 | Identify the criteria for designing database from the point of view of user |
| A) | No redundancy |
| B) | No inapplicable attributes | | C) | Uniformity in naming & definitions of the
data items | | D) | All the above | | | | Q. 3 | SQL server stores index information in the
_____ system table |
| A) | sysindexes |
| B) | systemindexes | | C) | sysind | | D) | sysindexes | | | | Q. 4 | ________ is preferred method for enforcing
data integrity |
| A) | Constraints |
| B) | Stored Procedure | | C) | Triggers | | D) | Cursors | | | | Q. 5 | _______ holds all temporary tables and temporary stored procedures |
| A) | model |
| B) | msdb | | C) | Tempd | | D) | Northwind | | | | Q. 6 | ____________ application is responsible business logic ad presenting data to the user |
| A) | Database |
| B) | Client | | C) | Server | | D) | none of the above | | | | Q. 7 | Anything that affects the database schema is a part of |
| A) | DML |
| B) | DCL | | C) | DDL | | D) | All of the above | | | | Q. 8 | _____ table store information about
database or about the system |
| A) | SQL |
| B) | Nested | | C) | System | | D) | None of these | | | | Q. 9 | SQL *Plus is used by Database administrator to ____ |
| A) | Specify rights and privileges to users |
| B) | Query and retrieve data from the database | | C) | Generate reports | | D) | All the above | | | | Q. 10 | To disable constraint, include the ______
option in alter table statement |
| A) | NOCHECK |
| B) | WITH NOCHECK | | C) | Either A) or B) | | D) | Neither A) nor B) | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034