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
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.