P2Pprogrammer 2 programmer

Home > Download > SMU - Question Paper > MCA > MC0067

Database Management System (DBMS and Oracle 9i)


This is the collection of Sikkim Manipal University (SMU) question and answers for Database Management System (DBMS and Oracle 9i). 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 2024, 2023, 2022 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 System (DBMS and Oracle 9i), SMU - Master of Computer Application.

Course Name        MCA (Master of Computer Application)

Subject Code       MC0067 (Database Management System (DBMS and Oracle 9i))

Get Questions        PART - A    PART - B    PART - C

Subject : Database Management System (DBMS and Oracle 9i)

     MC0067 : PART - A    


Q. 1SQL server supports the_________
 A)SMP
 B)NNTP
 C)HTTP
 D)None of the above
   
Q. 2SQL *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. 3An extent is ____ contiguous pages or ____
KB
 A)8, 64
 B)10,640
 C)4, 16
 D)16, 960
   
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. 5Relationship of department with employer is
an example for.________ relationship
 A)one to one
 B)many to one
 C)one to many
 D)many to many
   
Q. 6 __________ is a user interface for Microsoft
back office server management .
 A)Microsoft Management console
 B)Microsoft distributed transaction coordinator
 C)Microsoft system management server
 D)Non of the above
   
Q. 7Select 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. 8The number of attributes in a relation is
called as its ____
 A)Cardinality
 B)Degree
 C)Tuples
 D)Entity
   
Q. 9The captured data has to be classified
based on the nature and intended usage is
____
 A)Data capture
 B)Data classification
 C)Data arranging
 D)Data coding
   
Q. 10The________ is essentially used to
search for patterns in target string
 A)Like Predicate
 B)Null Predicate
 C)In Predicate
 D)Out Predicate
   
Click here to get Database Management System (DBMS and Oracle 9i) (MC0067) New Question


Home > Download > SMU - Question Paper > MCA > MC0067