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 2023, 2022, 2021 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. 1Which of these is incorrect statement
 A)A candidate key is minimal super key
 B)The number of tuples in a relation is called its cardinality
 C)The columns ofa relation are called tuples
 D)None of the above
   
Q. 2Syntax for dropping a database is .
 A)Drop database- name
 B)Drop DATABASE Database_name
 C)Delete database-name
 D)Drop DATABASE Database_name
   
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. 4Each table is in turn broken down into
__________, which is made up of ______
 A)Entity, attributes
 B)Records, fields
 C)columns, rows
 D)fields, relation
   
Q. 5 ____ is used for arranging data in
descending order
 A)DSC
 B)DESC
 C)BOTH A) and B)
 D)Neither A) nor B)
   
Q. 6______ converts data but does not support
styles
 A)Convert
 B)Cast
 C)Typecast
 D)None of these
   
Q. 7The value of the ‘Golden ratio’ is ____
 A)Sqrt (5)
 B)Sqrt (12)+1
 C)Sqrt (5)-1)/2
 D)Sqr(5)/2
   
Q. 8 _________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. 9 __________contains data assisting day to
day activities of the organisation
 A)Control database
 B)Operational database
 C)Strategic database
 D)Sequential database
   
Q. 10The ________ 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)
   
Click here to get Database Management Systems (BT0066 ) New Question


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