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. 1RELTAB 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. 3The 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. 4In 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. 8In 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. 9The ________ 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