Structured Query Language
Query Types
Q.

Given an employees table as follows: 

emp_id   emp_name 

1               Rajneesh 

2               Mukesh

what value will be return by below query ?

Select count(*) from employees;
A.  

4

 B.  

3

 C.  

2

 D.  

1

 E.  

0
Similar Questions
1.

Which of the following is not a valid SQL type?
A.  

FLOAT

 B.  

NUMERIC

 C.  

NUMERIC

 D.  

CHARACTER
2.

Which SQL statement is used to create a table in a database?
A.  

CREATE TAB

 B.  

CREATE DATABASE TABLE

 C.  

CREATE DB TABLE

 D.  

CREATE TABLE
3.

MySQL runs on which operating systems?
A.  

Linux and Mac OS-X only

 B.  

Unix, Linux, Windows and others

 C.  

Unix and Linux only

 D.  

Linux and Windows only
4.

To remove duplicate rows from the result set of a SELECT use the following keyword
A.  

NO DUPLICATE

 B.  

UNIQUE

 C.  

DISTINCT

 D.  

DISTINCTROW

 E.  

None of the above
5.

To use MySQL on your computer, you'll need?
A.  

FTP and Telnet

 B.  

A Browser

 C.  

Some sort of client program to access the databases

 D.  

Perl, PHP or Java
6.

Which SQL statement is used to insert a new data in a database?
A.  

UPDATE

 B.  

INSERT INTO

 C.  

INSERT NEW

 D.  

ADD
7.

A NULL value is treated as a blank or 0.
A.  

True

 B.  

False

 C.  

Depends on situation

 D.  

None of the above
8.

In a LIKE clause, you can could ask for any value ending in "god" by writing
A.  

LIKE %god

 B.  

LIKE _god

 C.  

LIKE ='_god'

 D.  

LIKE %^god
9.

MySQL is
A.  

A Programming language

 B.  

A Platform

 C.  

A technique for writing reliable programs

 D.  

A Relational Database Management System
10.

The result of a SELECT statement can contain duplicate rows.
A.  

False

 B.  

True

 C.  

None of the above
STRUCTURED QUERY LANGUAGE TOPICS