P2Pprogrammer 2 programmer

Home > Download > SMU - Question Paper > BSc IT > BT0066

Database Management Systems


This is the collection of Sikkim Manipal University (SMU) question and answers for Database Management Systems . 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 2022, 2021, 2020 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 Database Management Systems , SMU - Bachelor of Science in Information Technology.

Course Name        BSc IT (Bachelor of Science in Information Technology)

Subject Code       BT0066 (Database Management Systems )

Get Questions        PART - A    PART - B    PART - C

Subject : Database Management Systems

     BT0066 : PART - A    


Q. 1To determine whether a constraint is
enabled or disabled on a table, execute the
____ system stored procedure
 A)Help
 B)Sp_Help
 C)SPHELP
 D)None of these
   
Q. 2 __________ is a precompiled, named colleen
of Transact- SQL statements that executes to
gathers
 A)Stored procedure
 B)Trigger
 C)constraint
 D)None of the above
   
Q. 3______ converts data but does not support
styles
 A)Convert
 B)Cast
 C)Typecast
 D)None of these
   
Q. 4In an ER model, ____ is described in the
database by storing its data.
 A)Entity
 B)Attribute
 C)Relationship
 D)Notation
   
Q. 5_______ holds all temporary tables and
temporary stored procedures
 A)model
 B)msdb
 C)Tempd
 D)D Northwind
   
Q. 6The default installation path for the
program and data files is ____________
 A)C:\ MSQL7
 B)C:\ Msql7
 C)C:\ Mssql7
 D)C:\ Mssql7
   
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. 8 _____ 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. 9 ____is time to locate required block on a
track.
 A)Latency time
 B)Seek time
 C)Transfer rate
 D)Lead time
   
Q. 10To 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
   
Click here to get Database Management Systems (BT0066 ) New Question


Home > Download > SMU - Question Paper > BSc IT > BT0066