P2Pprogrammer 2 programmer

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. 1In snapshot, ______ clause tells oracle how
long to wait between refreshes.
 A)COMPLETE
 B)FORCE.
 C)NEXT
 D)REFRESH
   
Q. 2Identify 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. 3SQL 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. 9SQL *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. 10To 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