Download PDF
Free download in PDF MySQL Multiple Choice Questions and Answers for competitive exams. These short objective type questions with answers are very important for Board exams as well as competitive exams. These short solved questions or quizzes are provided by Gkseries.
(1)
DCL is used to _______?
[A]
Manage the changes made by DML statements
[B]
Inserting, Deleting and Updating data
[C]
Control access to data stored in a database
[D]
None of the above
Answer: Inserting, Deleting and Updating data
(2)
TCL is used for _______?
[A]
Manage the changes made by DML statements
[B]
Defining database schema
[C]
Control access to data stored in a database
[D]
None of the above
Answer: Manage the changes made by DML statements
(3)
Storing same data in many places is called.
[A]
Iteration
[B]
Concurrency
[C]
Redundancy
[D]
Enumeration
(4)
What is Granularity?
[A]
The size of data items
[B]
The size of database
[C]
The size of record
[D]
The size of file
Answer: The size of database
(5)
Which level of Abstraction describes what data are stored in the Database?
[A]
Physical Level
[B]
View Level
[C]
Abstraction Level
[D]
Logical Level
(6)
The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.
[A]
Dirty Read Problem
[B]
Temporary Modify Problem
[C]
Temporary Select Problem
[D]
None of the above
Answer: Dirty Read Problem
(7)
Data Warehouse provides
[A]
Transaction Responsiveness
[B]
Demand and Supply Responsiveness
[C]
Storage, Functionality Responsiveness to queries
[D]
None of these
Answer: Storage, Functionality Responsiveness to queries
(8)
Which of the following is true?
[A]
A relation in BCNF is always in 3NF.
[B]
A relation in 3NF is always in BCNF.
[C]
BCNF and 3NF are same.
[D]
A relation in BCNF is not in 3NF
Answer: A relation in BCNF is always in 3NF.
(9)
Referential integrity is directly related to
[A]
Relation Key
[B]
Primary Key
[C]
Unique Key
[D]
Foreign Key
(10)
_____ is process of extracting previously non known valid and actionable information from large data to make crucial business and strategic decisions.
[A]
Data Management
[B]
Database
[C]
Data Mining
[D]
Meta Data
(11)
Which of the following statements is NOT true for views in SQL?
[A]
Select statement used in the view definition cannot include ORDER BY clause.
[B]
A view drives its data from the base tables(s)
[C]
A view is updatable if it has been defined from a single relation
[D]
A view contains a copy of the data
Answer: A view contains a copy of the data
(12)
In order to add a new column to an existing table in SQL, we can use the command
[A]
MODIFY TABLE
[B]
EDIT TABLE
[C]
ALTER TABLE
[D]
ALTER COLUMNS
(13)
In an RDBMS relationship between tables are created by using
[A]
Alternate Keys
[B]
Foreign Keys
[C]
Candidate Keys
[D]
Composite Keys
(14)
BCNF Stands for _________.
[A]
Binary Coded Normal Form
[B]
Boyce - Codd Normal Form
[C]
Bit Code Normal Form
[D]
Boyce Codd Natural Form
Answer: Boyce - Codd Normal Form
(15)
The student marks should not be greater than 100. This is
[A]
Integrity constraint
[B]
Referential constraint
[C]
Over-defined constraint
[D]
Feasible constraint
Answer: Integrity constraint
(16)
The data type BLOB stands for:
[A]
Binary Large Object
[B]
Big List Object
[C]
Binary List Object
[D]
None of the above
Answer: Binary Large Object
(17)
Type data abstraction which allows conceptual representation of data in database management system is considered as
[A]
Logical design model
[B]
Data model
[C]
Interface model
[D]
User friendly model
(18)
Function which causes retrieval of any kind of data from database is considered as
[A]
Interface or Signature
[B]
User friendly signature
[C]
Conceptual signature
[D]
Logical signature
Answer: User friendly signature
(19)
Drop Table cannot be used to drop a table referenced by a ______________ constraint.
[A]
Primary Key
[B]
Sub Key
[C]
Super Key
[D]
Foreign Key
(20)
Which of the following is used to delete an entire MYSQL database?
[A]
drop entiredb dbname
[B]
drop database dbname
[C]
drop db dbname
[D]
drop dbase dbname
Answer: drop database dbname
Take Mock Tests