Q.1
Which of the following is not a keyword of MYSQL?
  • Select
  • Top
  • Group
  • Insert
Q.2
Which one of the following sorts rows in SQL?
  • SORT BY
  • ALIGN BY
  • GROUP BY
  • ORDER BY
Q.3
Which SQL function is used to find the average value of any column?
  • Mean()
  • Avg()
  • Average()
  • Sum()
Q.4
Which is not an aggregate function?
  • SUM()
  • POW()
  • AVG()
  • COUNT()
Q.5
Which operator is used to match column values against a list of values?
  • between
  • IN
  • Like
  • Is Null
Q.6
Write a query to display first_name and last_name of all employees who have their first_name starting with 'A'.
  • Select first_name from employess where first_name LIKE '%A';
  • Select first_name from employess where first_name LIKE "'A'%";
  • Select first_name from employess where first_name LIKE 'A%';
  • Select first_name from employess where first_name LIKE '%A%';
Q.7
The maximum length of char data type is
  • 65535 bytes
  • 255 bytes
  • 256 bytes
  • 456 bytes
Q.8
In MySQL, which command is used to modify the table values
  • Select
  • Update
  • Modify
  • Alter
Q.9
Which function will be used to remove only the trailing spaces from a string?
  • ltrim()
  • rtrim()
  • trim()
  • all
Q.10
Which is the default order of sort in ORDER BY clause?
  • Ascending
  • Descending
Q.11
The updated MySQL extension with PHP5 is typically referred to as
  • MySQL
  • mysql
  • mysqli
  • mysqly
Q.12
Which method returns the error code generated from the execution of the last MySQL function?
  • errno()
  • errnumber()
  • errorno()
  • errornumber()
Q.13
Which one of the following methods can be used to diagnose and display info about a MySQL connection error?
  • connect_errno()
  • connect_error()
  • mysqli_connect_errno()
  • mysqli_connect_error()
Q.14
The “father” of MySQL is ______.
  • Michael Widenius
  • Stephanie Wall
  • Bill Joy
Q.15
Which of the following is not a feature of MySQL?
  • Password protected
  • Not open source software
  • Runs very fast
  • Supports many data types
Q.16
"CREATE TABLE" statement falls to which category of comand of MYSQL?
  • DML
  • DCL
  • TCL
  • DDL
Q.17
If I want to show all data in a MySQL table, I would use
  • SHOW * FROM table;
  • SELECT * FROM table;
  • SHOW * IN table;
  • SELECT * IN table;
Q.18
A relational database ___________ is a data structure used to store and organize information.
  • View
  • Table
  • Report
  • Stored Procedure
Q.19
Which of the following query is correct to get Current Date from Query?A. SELECT DATE ( NOW() ) as today;B. SELECT DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) as today;
  • A. SELECT DATE ( NOW() ) as today;
  • B. SELECT DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) as today;
  • Both A and B
  • None
Q.20
Which clause is used to “Filters out unwanted data”?
  • FROM
  • SELECT
  • ORDER BY
  • WHERE
0 h : 0 m : 1 s