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 | SOL Server: |
| | A) | Allocates computer resources among
multiple concurrent users. |
| B) | Prevents logical problems, such as users who
want to update the same data concurrently. | | C) | Ensures data consistency and integrity. | | D) | All the above | | | | | Q. 2 | What will be the output of following?
BEGIN TRANSACTION
DELETE FROM customer WHERE state =
“Karnataka”
ROLL BACK TRANSACTION
DELETE FROM customer WHERE state =
“Kerala”
COMMIT TRANSACTION
|
| | A) | 2 Rows are deleted from customer |
| B) | 1 row deleted from customer | | C) | NO row is deleted | | D) | error | | | | | Q. 3 | Depending on the various requirements,
information can be of ____ categories.
a) Information required for short term and long
term planning. The performance of the
organization has to be evaluated and plans
have to be made accordingly |
| | A) | a), b) and c) |
| B) | a) and b) | | C) | b) and c) | | D) | only b) | | | | | Q. 4 | A character set is a set of ____ uppercase
and lowercase letters, digits, and symbols that
SQL server recognizes in your database |
| | A) | 256 |
| B) | 512 | | C) | 1024 | | D) | None of the above | | | | | Q. 5 | An extent is __ contiguous pages, or ___
KB. Therefore, a database has ___ extents per
megabyte. |
| | A) | 8, 64, 16 |
| B) | 8, 16, 64 | | C) | 16, 8, 64 | | D) | 64, 8, 16 | | | |
Click here to get
DBMS & SQL server (MT0034)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0034