MYSQL MCQ's SET-6
101. The term _______ is used to refer to a row.
A : Attribute
B : Tuple
C : Field
D : Instance
Ans: C
102. The employee salary should not be greater than Rs.2000. This is _______
A : integrity constraint
B : referential constraint
C : over-defined constraint
D : feasible constraint
Ans: C
103. The ______of a database keeps on changing.
A : Instance
B : Schema
C : Structure
D : Primary key
Ans: C
104. In SQL the statement select*from R,S is equivalent to_______.
A : Select * from R natural join S
B : Select * from R cross join S
C : Select * from R union join S
D : Select * from R inner join S
Ans: D
105. Which normal form is considered adequate for relational database
design?
A : 1 NF
B : 2 NF
C : 3 NF
D : BCNF
Ans: A
106. Which of the following fields has width of 8 bytes?
A : Memo
B : Number
C : Date/time
D : Hyperlink
Ans: A
107. Functional Dependencies are the types of constraints that are based
on______
A : Key
B : Key revisited
C : Superset key
D : Tuple
Ans: C
108. In the __________ normal form, a composite attribute is converted to
individual attributes.
A : First
B : Second
C : Third
D : Fourth
Ans: B
109. The natural join is equal to :
A : Cartesian Product
B : Combination of Union and Cartesian product
C : Combination of selection and Cartesian product
D : Combination of projection and Cartesian product
Ans: B
110. Which SQL Query is use to remove a table and all its data from the
database?
A : Create Table
B : Alter Table
C : Drop Table
D : Remove Table
Ans: B
111. A primary key is combined with a foreign key creates______
A : Parent-Child relationship between the tables that connect them
B : Many to many relationship between the tables that connect them.
C : Network model between the tables that connect them.
D : Many to one relationship between the tables that connect them.
Ans: C
112. In the __________ normal form, a composite attribute is converted to
individual attributes
A : First
B : Second
C : Third
D : Fourth
Ans: C
113. The result of the UNION operation between R1 and R2 is a relation that
includes
A : All the tuples of R1
B : All the tuples of R2
C : All the tuples of R1 and R2
D : All the tuples of R1 and R2 which have common columns
Ans: C
114. Amongst the ACID properties of a transaction, the 'Durability' property
requires. that the changes made to the database by a successful transaction
persist
A : Except in case of an operating system crash
B : Except in case of a disk crash
C : Except in case of a power failure
D : Always, even if there is a failure of any kind
Ans: B
115. Does index take space in the disk ?
A : Indexes are never stored on disk
B : It stores memory as and when required
C : Indexes take no space
D : Yes, Indexes are stored on disk
Ans: B
116. A table has fields F1, F2 , F3 , F4, F5 with the following functional
dependencies
Fi —> F3,
F2 —> F4
(FI,F2) —> F5
In terms of normalization, this table is in
A : 1 NF
B : 2 NF
C : 3 NF
D : BCNF
Ans: D
117. _______ allow us to identify uniquely a tuple in the relation.
A : Super key
B : Domain
C : Attribute
D : Schema
Ans: B
118. Which of the following operation is used if we are interested in only
certain columns of a table?
A : PROJECTION
B : SELECTION
C : UNION
D : JOIN
Ans: B
119. Which of the following is not a property of a transaction?
A : Atomicity
B : Consistency
C : Integrity
D : Durability
Ans: D
120. Consider the following
S1: Foreign key allows null values.
S2: Every binary tables is in BCNF
Which of the following is true?
A : Both S1 and S2 are true
B : S1 is true
C : S2 is true
D : Both S1 and S2 are false
Ans: D