mysql quiz

MYSQL MCQ Questions and Answers | MYSQL Interview Questions

Computer Programming Quiz IT Jobs

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 B – Inserting, Deleting and Updating data

Q2. Storing same data in many places is called.

A Iteration
B Concurrency
C Redundancy
D Enumeration

Option C – Redundancy

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?

A Query
B DML
C Relational
D DDL

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

Leave a Reply

Your email address will not be published. Required fields are marked *