ADBMS MCQs
1) Which approach that the E-R models must organizing information? (1)
A. **layered
B. stepped
C. direct
D. indirect
2) For a relation R, we are given that
the domains of all attributes of R are indivisible. With this information, we
can say the relation R is in ___________ (1)
A. **1 NF
B. 2 NF
C. 3 NF
D. BCNF
3) On which data a
relational DBMS cannot perform elementary operations? (1)
A. simple
B. **complex
C. short
D. large
4) An is a set of entities of the same type that share the same properties, or attributes. (1)
A.
**Entity set
B. Attribute set
C. Relation set
D.
Entity model
5) Entity is a (1)
A.
working model
B. **Thing in real world
C. Object of relation
D. Model of relation
6) Which data type is a user defined
data type with elements that are not atomic rather they are divisible? (1)
A. system
B. class
C. **structured
D. semi-structured
7) Which mechanism is used for making
naming and reachability. (2)
A. class
persistent
B. value
persistent
C. data
persistent
D. **object persistent
8) If a transaction is not able to
execute all operations successfully, which method is used to undo all
transaction? (2)
A. **Rollback
B. commit
C. atomicity
D. consistency
9) _________________________ is the
method of managing concurrent operations on the database without getting any
obstruction with one another. (2)
A. obstruction
B. Generalization
C. **Concurrency control
D. Protocol
10) The
descriptive property possessed by each entity
set is (2)
A.
Entity
B. Relation
C. **Attribute
D.
Model
11) The attribute name could be structured as an attribute consisting of first
name, middle initial, and last name This type of attribute is called
_________________ (2)
A. Simple attribute
B. Derived attribute
C.
Multivalued attribute
D.
**Composite attribute
12) The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
______________ (2)
A.
**Derived attribute
B. Multivalued attribute
C. Composite attribute
D.
Simple attribute
13) Which of the following can be a multivalued attribute? (3)
A.
Name
B. **Phone_number
C. Date_of_birth
D.
Enrollment no
14) The process of designating sub groupings within the entity set is called
a_____________. (3)
A.
Aggregation
B. Finalization
C. **Specialization
D.
Generalization
15) The similarities between the entity sets are used in which type of grouping
_____________. (3)
A.
Aggregation
B. Finalization
C. Specialization
D.
**Generalization
16) In Specialization, Higher level entity sets are designated by the term
____________. (3)
A.
**Super class
B. Sub class
C. Parent class
D.
Child Class
17) Which of the following is not a constraint in generalization? (3)
A.
Condition-defined
B. **System defined
C. User defined
D.
Disjoint
18) ORDBMS
is the data model in which data is stored in form of _____________. (3)
A. tree
B. **objects
C. class
D. entity
19) If each
higher-level entity belongs to the lower level entity, then what kind of
generalization is it? (4)
A.
Partial
B. Maximum
C. **Total
D.
Minimum
20) Which of the following is an ordered collection of elements of the same
type? (4)
A.
**List
B. Tuple
C. Bag
D.
Set
nice
ReplyDelete