MySQL Quiz | MySQL Multiple Choice Questions and Answers

Questions
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

Answer: Redundancy
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

Answer: 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

Answer: 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

Answer: Data Mining
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

Answer: ALTER TABLE
13 In an RDBMS relationship between tables are created by using
A Alternate Keys
B Foreign Keys
C Candidate Keys
D Composite Keys

Answer: Foreign 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

Answer: Data 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

Answer: 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
junior administrative assistant jaa test series