JOIN ADRE 2.0 Telegram Group

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
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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

ADRE 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!
Advertisement
Assam Direct Recruitment Test Series