SQL Test

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled. If loading fails, click here to try again

There are 12 questions to complete in this free SQL test. The test does not have a time limit but it should take no more than 6 minutes to complete.

Summary of SQL Test
This quiz includes questions related to tables, queries, wildcards, joins, null values, attributes and functions. Start Congratulations - you have completed SQL Test. You scored %%SCORE%% out of %%TOTAL%%. Your performance has been rated as %%RATING%%

Why not take one of the following 40 minute timed SQL tests for $9.99 developed by qualified and highly experienced experts in their field. These tests are used by employers and recruiters to evaluate the job readiness of candidates. Compare yourself to others who have taken the test. At the end of the test you can print out your results and show them to a prospective employer.>>
ASP.NET with SQL Server Test
Knowledge of SQL Server 2008 Skills Test and certification
MS SQL Server 2005 Test and certification
SQL Test and certification
SQL Test and certification (Hands-on programming skills)
MySQL 5.0 Test
Your answers are highlighted below.

Question 1

What does SQL stands for?

	Sequential Query Language
	Structured Query Language
	Simple Query Language
	Secured Query Language

Question 2

We have a table "person" in SQL with an attribute "name" and it has duplicate names. How we will select the different names?

	SELECT DIFFERENT name FROM person
	SELECT DISTINCT name FROM person
	SELECT DISTINCT(name) FROM person
	SELECT * FROM person

Question 3

We have a table "student" in SQL with an attribute "name". Which of the following queries should be used when selecting the name of the students whose name starts with Chris?

	SELECT * FROM student WHERE name=chris
	SELECT name FROM student WHERE name like ‘chris’
	SELECT name FROM student WHERE name like ‘%chris%’
	SELECT name FROM student WHERE name like ‘chris%’

Question 4

We have a table "vehicles" in SQL with an attribute "model". Which of the following queries should be used when selecting the models "XLI" OR "VTI" from the vehicles?

	SELECT model FROM vehicles WHERE model='XLI' OR model='VTI'
	SELECT model FROM vehicles WHERE model LIKE '%XLI' OR model LIKE '%VTI'
	SELECT model FROM vehicles WHERE model LIKE '%XLI%' OR model LIKE '%VTI%'
	SELECT model FROM vehicles WHERE model LIKE 'XLI%' OR model LIKE 'VTI%'

Question 5

Please select the appropriate answer from the following

	The TOP Clause is used for selecting the top ten records from the table
	The TOP Clause is used for selecting high accessing records from the table
	The TOP clause is used to specify the number of records to return
	There is no such clause in SQL

Question 6

This question is about Wildcards in SQL. Which of the following WildCards can be used in SQL?

	% Wildcard
	_ Wildcard
	[^charlist] Wildcard
	All of the above are correct

Question 7

Which of the following is true about SQL INNER JOIN?

	The INNER JOIN keyword return rows when there is at least one match in both tables
	The INNER JOIN keyword return rows when there is at least one match in the left table
	The INNER JOIN keyword return rows when there is at least one match in the right table
	All of the above are not true about SQL INNER JOIN

Question 8

Which of the following is true about SQL FULL JOIN?

	SQL FULL JOIN returns rows when there is a match in one of the tables
	SQL FULL JOIN returns all rows from the right table, even if there are no matches in the left table
	SQL FULL JOIN returns all rows from the left table, even if there are no matches in the right table
	SQL FULL JOIN returns all rows when there is a match in both tables

Question 9

Which of the following queries is correct for selecting the NULL values from table "person" having attribute "name"?

	SELECT name FROM person WHERE name=""
	SELECT name FROM person WHERE name=NULL
	SELECT name FROM person WHERE name IS NULL
	SELECT name FROM person WHERE name HAS NULL

Question 10

We have a table "store" having attribute "storename". We have to convert all the store names to uppercase while selecting. Which of the following SQL queries is true?

	SELECT UCASE(storename) FROM store
	SELECT UPPERCASE(storename) FROM store
	SELECT UPPERC(storename) FROM store
	There is no such function supported by SQL

Question 11

We have a table "places" having attribute "placename". We have to select the first seven characters of the place name. Which of the following SQL queries is true?

	SELECT IN(placename,1,7) as SmallCity FROM Persons
	SELECT BETWEEN(placename,1,7) as SmallCity FROM Persons
	SELECT MID(placename,1,7) as SmallCity FROM Persons
	We will handle it at the programming level

Question 12

Which of the following is true about the ROUND() function?

	The ROUND() function is used to round off the selected numbers to zero decimal place
	The ROUND() function is used to round a numeric field to the number of decimals specified
	The ROUND() function is used to round a float field to the number of decimals specified
	There is no such function in SQL

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 12 questions to complete.

List

Return Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
11	12	End

Return

SQL Interview Preparation Tests (Recommended)
Are you going for an interview that requires knowledge of SQL?
Want to compare your skills to other SQL developers?
Why not take one of the following 40 minute timed SQL tests for $9.99. They were developed by qualified and highly experienced experts in their field and are used by employers and recruiters to evaluate the job readiness of candidates. At the end of the test you can print out your results and show them to a prospective employer. >>
ASP.NET with SQL Server Test
Knowledge of SQL Server 2008 Skills Test and certification
MS SQL Server 2005 Test and certification
SQL Test and certification
SQL Skills Test and certification (Hands-on programming skills)
MySQL 5.0 Test

Comments on this entry are closed.

SQL Test

SQL Test

Categories

SAT Test Papers

SQL Test

SQL Test

Categories

SAT Test Papers

Tags