MYSQL MCQ Questions and Answers | MYSQL Interview Questions:
his MYSQL Online Test contains around 25 best MYSQL Multiple Choice Questions. You have to select the right answer to every question. MySQL Certification MCQ questions MySQL Quiz and Online mock test will help you enhance your basic knowledge and preparation .MySQL Multiple Choice Questions and Answers for competitive exams. These short objective type questions with answers are very important for Board exams.
Q1.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
Option C Control access to data stored in a database
Q2. Storing same data in many places is called.
Option C – Redundancy
A Iteration
B Concurrency
C Redundancy
D Enumeration
Q3.Which level of Abstraction describes what data are stored in the Database?
A Physical Level
B View Level
C Abstraction Level
D Logical Level
Option D – Logical Level
Q4.Data Warehouse provides
A Transaction Responsiveness
B Demand and Supply Responsiveness
C Storage, Functionality Responsiveness to queries
D None of these
Option C – Storage, Functionality Responsiveness to queries
Q5.Referential integrity is directly related to
A Relation Key
B Primary Key
C Unique Key
D Foreign Key
Option D – Foreign Key
Q6.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
Option C – ALTER TABLE
Q7.The student marks should not be greater than 100. This is
A Integrity constraint
B Referential constraint
C Over-defined constraint
D Feasible constraint
Option A – Integrity constraint
Q8.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
Option B – Data model
Q9.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
Option D – Foreign Key
Q10.The number of attributes in relation is called as its
A Cardinality
B Entity
C Tuples
D Degree
Option D – Degree
Q11.Insert into instructor values (10211, ‘Smith’, ‘Biology’, 66000); What type of statement is this?
Option D – DDL
Q12.To remove a relation from an SQL database, we use the __ command.
A Delete
B Purge
C Remove
D Drop table
Option D – Drop table
Q13.The primary key is selected from the:
A composite keys.
B determinants
C foreign keys
D candidate keys
Option D – candidate keys
Q14.In SQL, __ is an Aggregate function.
A SELECT
B CREATE
C AVG
D MODIFY
Option C – AVG
Q15.MVD is called as
A Many Value Dependency
B More Value Dependency
C Multi Value Dependency
D all of the above
Option C – Multi Value Dependency
Q16.A table that displays data redundancies yields __ anomalies
A Insertion
B Deletion
C Update
D All of the above
Option D – All of the above
Q17.Commit command is used for
A To restore the old values
B To save the current table
C To save the current transaction
D To recover the old table
Option c – To save the current transaction
Q18.Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
A DML(Data Manipulation Langauge)
B DDL(Data Definition Langauge)
C Query
D Relational Schema
Option A – DML(Data Manipulation Langauge)
Q19.A relational database consists of a collection of
A Table
B Fields
C Records
D Keys
Option A – Table
Q20.A attribute in a relation is a foreign key if the _ key from one relation is used as an attribute in that relation
A Candidate
B Primary
C Super
D Sub
Option B – Primary
Q21.Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
A Candidate key
B Sub key
C Super key
D Foreign key
Option c – Super key
Q22.Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
A Left outer join
B Full outer join
C Right outer join
D Half outer join
Option c – Right outer join
Q23.Which among the following have the maximum bytes?
A Varchar
B Char
C Text type
D Both Varchar and Char
Option c – Text type
Q24.Mysql support different character sets, which command is used to display all character sets?
A SHOW CHARACTER SET;
B SHOW;
C CHARACTER SET;
D None of the mentioned
Option A – SHOW CHARACTER SET
Q25.Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?
A Varchar
B Char
C Both Varchar and Char
D None of the mentioned
Option A – Varchar