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. 1To print a list of system stored procedures and owner names in database use the ____ system stored procedures
 A)sp_stored
 B)stored_procedures
 C)sp_procedures
 D)sp_stored_procedures
   
Q. 2 _________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. 3 ___________ clause is an additional filters that is applied to the result
 A)select
 B)group-by
 C)having
 D)order by
   
Q. 4The number of attributes in a relation is
called as its ____
 A)Cardinality
 B)Degree
 C)Tuples
 D)Entity
   
Q. 5Select the wrong statement
 A)A primary key is a minimal superkey
 B)An entity may have many candidate keys
 C)A weak entity is always related to one or more strong entities
 D)All the above
   
Q. 6 _____ keyword is used to retrieve rows within specified range of values
 A)BETWEEN
 B)AND
 C)IN
 D)None of these
   
Q. 7To start SQL server as an application instead of as windows NT server u can _________
 A)Use SQL server agent.
 B)Type SQL server at command prompt
 C)Not able to use as application
 D)Both A and B
   
Q. 8A complete new server installation require ________ Hard disk space
 A)32.MB
 B)50.MB
 C)90.MB
 D)148MB
   
Q. 9 _____ 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. 10SQL server stores index information in the _____ system table
 A)sysindexes
 B)systemindexes
 C)sysind
 D)sysindexes
   
Click here to get DBMS & SQL server (MT0034) New Question


Home > Download > SMU - Question Paper > MSc IT > MT0034