MYSQL MCQ's SET-5
A : Unary Operator
B : Ternary Operator
C : Binary Operator
D : Not an operator
Ans: C
82. When the changes caused by an aborted transaction have been undone, the transaction is said to be_________.
A : Failed
B : committed
C : partially committed
D : rolled back.
Ans: D
83. Data Manipulation Language (DML) is not to______
A : Create information table in the Database
B : Insertion of new information into the Database
C : Deletion of information in the Database
D : Modification of information in the Database
Ans: A
84. Cartesian product in relational algebra is:
A : a Unary operator
B : a Binary operator
C : a Ternary operator
D : not defined
Ans: B
85. To remove a relation from an SQL database, we use the ______ command.
A : Delete
B : Purge
C : Remove
D : Drop table
Ans: D
86. In one-to-many relationship the table on 'many' side is called as:
A : Parent
B : Master
C : Sister
D : Child
Ans: D
87. Which of the following fields has width of 8 bytes?
A : Memo
B : Number
C : Date/time
D : Hyperlink
Ans: C
88. Minimal Super keys are called
A : Schema keys
B : Candidate keys
C : Domain keys
D : Attribute keys
Ans: B
89. Functional Dependencies are the types of constraints that are based on______
A : Key
B : Key revisited
C : Superset key
D : Tuple
Ans: A
90. Which normal form is considered adequate for relational database design?
A : 1 NF
B : 2 NF
C : 3 NF
D : BCNF
Ans: C
91. A file manipulation command that extracts some of the records from a file is called
A : SELECT
B : PROJECT
C : JOIN
D : PRODUCT
Ans: A
92. The RDBMS terminology for a row is________.
A : Tuple.
B : Relation.
C : Attribute.
D : Degree.
Ans: A
93. 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: B
94. 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: C
95. In the __________ normal form, a composite attribute is converted to individual attributes.
A : First
B : Second
C : Third
D : Fourth
Ans: A
96. The term _______ is used to refer to a row.
A : Attribute
B : Tuple
C : Field
D : Instance
Ans: B
97. Which of the following in true regarding Referential Integrity?
A : Every primary-key value must match a primary-key value in an associated table
B : Every primary-key value must match a foreign-key value in an associated table
C : Every foreign-key value must match a primary-key value in an associated table
D : Every foreign-key value must match a foreign-key value in an associated table
Ans: C
98. 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: A
99. Customer withdrawing money from ATM is an example of__________
A : Application programmer
B : Naïve user
C : Specialized user
D : Sophisticated user
Ans: B
100. _______ produces the relation that has attributes of R1 and R2
A : Cartesian product
B : Difference
C : Product
D : Intersection
Ans: A