MySQL Certification Quiz
Instructions For Quiz
Quiz Time limit is 20 minutes
This Mock Test has 40 Questions
Each Question is of 1 marks so total 40 marks
MCQ(Multiple Choice Questions) with only ONE valid answer
Name
Email
*
Get Result on your Email address
Back
Next
1) A systematic collection of data stored in a central location is known as?
*
csv
Database
Flat file
Excel
Back
Next
2) Which type of database management system represents relations using tables?
*
Network DBMS
Hierachical DBMS
Relational DBMS
Object Oriented DBMS
Back
Next
3) MySQL supports multiple database storage engines.
*
YES
NO
Back
Next
4) MySQL workbench decreases the productivity of a MySQL developer compared to other server access tools such as phpMyAdmin?
*
YES
NO
Back
Next
5) The logic model of a database is?
*
concerned with the planning of the entire database development life cycle
concerned with the physical implementation of the database
concerned with developing the database model taking into consideration the physical implementation
concerned with developing the database model without taking into consideration the physical implementation or the DBMS
Back
Next
6) The database development lifecycle is very important to the successful implementation of a database system.
*
YES
NO
Back
Next
7) Normalizations is...
*
a database design technique used to minimize data redundancy and duplication
a database design technique that eliminates relationships from a database
concerned with the physical implementation of the database
a database design technique that encourages storing data in multiple databases
Back
Next
8) What is a composite key?
*
its is a key that is defined as the primary key in another table
it is a key that uniquely identifies a record in a database
its is an optional key and allows null values
it is a primary key that consists of more than one field that uniquely identifies a record
Back
Next
9) Which of the following is not YES regarding ER modeling
*
ER models act as non technical communication tools
ER models increase the database developer's productivity
ER models can be converted into a database
ER models waste the database developer's time
Back
Next
10) a one to many relationship can only contain multiple entries of both primary and foreign keys.
*
YES
NO
Back
Next
11) Which of the following SQL statements will generate an error when executed.
*
CREATE DATABASE students
CREATE DATABASE students;
create database if not exists students
IF NOT EXISTS CREATE DATABASE `STUDENTS`;
Back
Next
12) the command DROP SCHEMA `STUDENTS`; will delete the students database.
*
YES
NO
Back
Next
13) The WHERE clause is mandatory when using the SELECT command
*
YES
NO
Back
Next
14) Which of the following scripts will run successfully
*
SELECT customer name FROM customers;
SELECT FROM `customers` 'customer name';
SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;
SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;
Back
Next
15) The WHERE clause is exactly HAVING clause
*
YES
NO
Back
Next
16) What will be the output of the following query. SELECT * FROM `sales` WHERE amount > 200.
*
the query will display all the sales records with amounts starting from 200 and above
the query will display all the sales records with amounts less than 200
the query will display all the sales records with amounts greater than 200
the query will output sales records with the amount equal to 200
Back
Next
17) The query SELECT * FROM `movies` INSERT INTO `movies_archive` executes without any errors.
*
YES
NO
Back
Next
18) What will be the output of the following query INSERT INTO students (student name) VALUE ('James Lenon');
*
a student record with the name James Lenon will be added into the students table
the above query will generate an error message.
Back
Next
19) What command is used to permanently remove a record from a database table?
*
DROP
REMOVE
DELETE
CUT
Back
Next
20) What improvements can be made to the query UPDATE students SET `contact number` = 0999;
*
The query does not need any improvements
enclose the contact number in single quotes
Back
Next
21) The clause ORDER is used to sort records in either ascending or descending order.
*
YES
NO
Back
Next
22) The ASC and DESC keywords can be used in the same statement
*
YES
NO
Back
Next
23) The GROUP BY command cannot be used with aggregate functions together
*
YES
NO
Back
Next
24) Wildcards are
*
not supported by MySQL
used to perform pattern matches
use characters such as $ to perform pattern matches
use characters such as % to perform single character matching
Back
Next
25) MySQL supports user defined functions
*
YES
NO
Back
Next
26) Which of the following is a valid aggregate function
*
CURDATE()
COUNT
AVERAGE
MAXIMUM
Back
Next
27) What will be the output of the query SELECT MINIMUM (amount) FROM sales;
*
return the lowest sales value
the query will generate an error
Back
Next
28) Null is used as a place holder for optional fields
*
YES
NO
Back
Next
29) What will be the output of the SELECT CASE WHEN NULL = NULL THEN 'YES' ELSE 'NO' END
*
YES
NO
Back
Next
30) MySQL does not support auto generating numbers
*
YES
NO
Back
Next
31) What will be the effect of inserting 500 rows in a table with the following definition. CREATE TABLE `categories` ( `category_id` tinyint(3) AUTO_INCREMENT, `category_name` varchar(150) DEFAULT NULL, `remarks` varchar(500) DEFAULT NULL, PRIMARY KE
*
500 rows will be inserted into the table
half the records will be inserted then an error will be generated
a table with the above definition is not possible
only 100 rows will be inserted
Back
Next
32) Once a table has been created in MySQL, its structure cannot be altered
*
YES
NO
Back
Next
33) The syntax for adding a new column to an existing table is ALTER TABLE `table_name` ADD COLUMN `column_name` `data_type`;
*
YES
NO
Back
Next
34) The employees table has 20 records, what will be the output of the query SELECT gender FROM employees GROUP BY gender;
*
the query will return two rows only... assuming there are no null values
the query will return 20 records
the query will generate an error message
the query will not return any records
Back
Next
35) What will be the effect of the query SELECT TOP (100) FROM customers when executed against MySQL database.
*
The query will return 100 records from the database table sorted in descending order
The query will generate an error
The query will return 100 records from the database table sorted in ascending order
The query will return all records from the database table
Back
Next
36) What will be the output of the query SELECT * FROM `members` LIMIT 1, 2;
*
the query will generate an error
the query will return the first 2 records
the query will return skip the first record then return the following 2 records only
the query will return all records from the members table
Back
Next
37) the query SELECT name, (SELECT study_program FROM programs) study_program FROM students will return the student name and the program that the student is studying.
*
YES
NO
Back
Next
38) Sub queries have better performance compared to JOIN queries
*
YES
NO
Back
Next
39) the UNION command is used to combine resultsets from more than one query into a single result set
*
YES
NO
Back
Next
40) What will be the effect of the query SELECT c.*,e.* FROM clients c INNER JOIN employees e ON c.emp_no = e.emp_no;
*
return all the records from the clients table and only those that match the emp_no from the employees table
return all the records from the employees table and only those that match the emp_no from the clients table
return only records that have matching emp_no values in both tables
The query will generate an error
Submit
Should be Empty: