BCA 4th semester
Database Management System 2023 year
2020 BATCH
MCQ WITH ANSWERSHEET
- Which of the following type of users are the general users who use application program to access the database?
a) Application programmers
b)Sophisticated users
c)Specialized users
d)Naïve users
il) Which of following represents the actual content of a database at a particular point in time?
a) Schema
b) Instance
c) Abstraction
d) Function
ili) Which of the following is an extended ER feature that refers to the process by which entities are combined to form a single meaningful entity?
a) Aggregation
b) Generalization
c) Specialization
d) Composition
iv) defines the maximum number of relationship instances in which an entity can participate.
a) Participation constraints
b) Cardinality constraints
c) Domain constraints
d) Referential integrity constraints
v) Relational Algebra is a/an………………
a) Procedural language
b) Non-procedural language
c) Structured language
d) QBE language
vi) Which of the following is a unary relational operator?
a) union
b) set difference
c) join
d) rename
vii) Which of the following is used for deleting a column from a table?
a) DELETE
b) DROP
c) DEL
d) REMOVE
viii) The parameters of a stored procedures cannot have the mode.
a) IN
b) OUT
c) TRANSIT
d) INOUT
¡x) A database log that is used mainly for security purposes is
a) System log
b) Database log
c) Audit trail
d) Database Audit
x An index is a table that contains two columns:…………..and………..
a) Search key and data
b) Search key and data reference
c) Data reference and data
d) Data reference and pointer