BCA 4th semester Database Management System (DBMS) 2023 year 2020 BATCH MCQ WITH ANSWERSHEET

5179

BCA 4th semester

Database Management System 2023 year

2020 BATCH

MCQ WITH ANSWERSHEET

 

  1. 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here