Online Exam On Database,sql,sql

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='a'"

Commands passed to the MySQL daemon are written in.

Your choice from Perl, PHP, Java or some other languages

the Structured Query Language

English

Swedish

Which SQL keyword is used to sort the result-set?

SORT

ORDER BY

ORDER

SORT BY

What is Column?

A column defines multiple piece of data stored in all rows of the table.

A column defines one piece of data stored in all rows of the table.

A column defines one piece of data stored in one rows of the table.

A column defines multiple piece of data stored in one row of the table.

What SQL clause is used to restrict the rows returned by a query?

AND

WHERE

HAVING

FROM

MySQL comes with as standard with client libraries for:

C only

Java only

Java and C

Perl, PHP and C

Sometimes the expression "select count(*)" will return fewer rows than the expression "select count(value)".

True

False

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT LastName>'Hansen' AND LastName

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

What does the DESC keyword do in the following query? SELECT * FROM MY_TABLE WHERE ID > 0 ORDER BY ID, NAME DESC

It causes the dataset returned by the query to be sorted in descending order

It causes rows with the same ID to be sorted by NAME in ascending order

It causes rows with the same ID to be sorted by NAME in descending order

It causes rows to be sorted by NAME first and then by ID

It causes the result set to include a description of the NAME field

The “Mysql command line tool” formats are bounded by

+-|

+-*

+-/

+-}

Which of the following is used to delete an entire MYSQL database?

mysql_drop_database

mysql_drop_entiredb

mysql_drop_db

mysql_drop_dbase

Which SQL statement is used to update data in a database?

MODIFY

UPDATE

SAVE AS

SAVE

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

LIKE %qpt

LIKE *ton

LIKE ton$

LIKE ^.*ton$

With SQL, how can you return the number of records in the "Persons" table?

SELECT COLUMNS() FROM Persons

SELECT COUNT(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT() FROM Persons

The program called mysql is

There isn't a program just called mysql

A wrapper through which Java clients must connect to the databases

A client program that lets you send SQL commands to the database engine

The database engine

A program that starts up and shuts down the database engine

Which SQL statement is used to delete data from a database?

COLLAPSE

DELETE

MODIFY

REMOVE

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName'Peter'

The “Mysql command line tool” format the results in which of the following format:

Rectangle

Square

Sphere

None of these

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

INSERT INTO Persons (LastName) VALUES ('Olsen')

INSERT ('Olsen') INTO Persons (LastName)

INSERT INTO Persons ('Olsen') INTO LastName

How much storage space does DATETIME require?

4 bytes

2 bytes

8 bytes

1 byte

What will happen at the end of the following sequence of SQL commands? BEGIN TRANSACTION DELETE FROM MYTABLE WHERE ID=1 DELETE FROM OTHERTABLE ROLLBACK TRANSACTION

The contents of OTHERTABLE will be deleted

The contents of both OTHERTABLE and MYTABLE will be deleted

The contents of OTHERTABLE will be deleted, as will be all the contents of MYTAB whoID is 1

The database will remain unchanged to all users except the one that executes these queries.

The database will remain unchanged

Which command is used for showing current date and time in Mysql command line tool?

select now()

SELECT now();

SELECT now()

None of these

Enum values are stored according to their index numbers

True

False

MySQL supports the complete SQL99 standard

false

true

Which of the following ways below are the correct way to get the current date?

SELECT CURTIME();

SELECT CURDATE();

SELECT CURRENT_TIME();

All of above

Which of these commands will delete a table called XXX if you have appropriate authority:

DROP TABLE XXX

DROP XXX WHERE confirm = "YES"

DELETE XXX WHERE confirm = "YES"

DROP XXX

Which statement is used to access an existing Database?

Use

use database.name

USE databasename;

none of these

MySQL is

A Programming language

A technique for writing reliable programs

A Relational Database Management System

Which SQL statement is used to return only different values?

SELECT DISTINCT

SELECT UNIQUE

SELECT DIFFERENT

SELECT DIFF

The main MySQL program that does all the data handling is called?

mysql.exe

mysql

mysqld

httpd

Note:

Click the 'Submit Test' button given in the bottom of this page to Submit your answers.
Test will be submitted automatically if the time expired.
Don't refresh the page.

A to Z Exams

Database - Sql - Sql Test

Test Instructions :

1. The Test is 1hr duration.

2. The Test Paper consists of 30 questions. The maximum marks are 30.

3. All the questions are multiple choice question type with three options for each question.

4. Out of the three options given for each question, only one option is the correct answer.

5. Each question is allotted 1 mark for each correct response.

6. 0.25 will be deducted for incorrect response of each question.

Time Left : 00 : 30 : 00