INDIA
Home	Books	Videos	Test Skills	Buy Now	Company	Other Links	Contact Us

Featured Video

Featured Book

Test Module :

To know about what level you should start from, here’s an online test that lets you determine your current SQL awareness levels. After we receive the Test answers from you, we will recommend you suitable books and videos to prime up your knowledge.
Question : 1	Which SQL clause helps you to limit the number of records you see in a query from a single table?
Answer :	FROM
	WHERE
	IF
	SELECT

Question : 2	Which wildcard usage will help you find all last names starting with R?
Answer :	WHERE LastName = 'R%'
	WHERE LastName = '%R'
	WHERE LastName LIKE 'R%'
	WHERE LastName LIKE '%R'

Question : 3	You want to find all first names that start with the letters A-M in your Customer table. Which SQL code would you use?
Answer :	SELECT * FROM Customer WHERE Firstname <= 'm%'
	SELECT * FROM Customer WHERE Firstname = 'a-m%'
	SELECT * FROM Customer WHERE Firstname like 'a-m%'
	SELECT * FROM Customer WHERE Firstname = '[a-m]% '
	SELECT * FROM Customer WHERE Firstname like '[a-m]%'

Question : 4	You want to find all scores for contestants who scored in the range of 20-30 points. Which SQL code would you use?
Answer :	SELECT * FROM contestant WHERE score BETWEEN 20 OR 30
	SELECT * FROM contestant WHERE score BETWEEN 20 AND 30
	SELECT * FROM contestant WHERE score IS BETWEEN 20 AND 30
	SELECT * FROM contestant WHERE score MIDDLE RANGE (20,30)

Question : 5	You want to find all first names that have the letter A as the second letter and do not end with the letter Y. Which SQL code would you use ?
Answer :	SELECT * FROM Employee WHERE Firstname like '_A% ' AND Firstname NOT LIKE 'Y%'
	SELECT * FROM Employee WHERE Firstname like '_A% ' AND Firstname NOT LIKE '%Y'
	SELECT * FROM Employee WHERE Firstname like 'A_% ' AND Firstname NOT LIKE 'Y%'

Question : 6	You work for a commercial certificate authority (CA) to track safe internet business. You have a table named ApprovedWebSites. Some are ftp:// sites and some are http:// sites. You want to find all approved .org sites listed in the URLName field of the ApprovedWebSites table. All URL names will have the :// with at least one character before them. All sites will have at least one character after the :// and before the .org at the end. What code will give you all .org records?
Answer :	SELECT * FROM ApprovedWebSites WHERE URLName like '%://%[.org]'
	SELECT * FROM ApprovedWebSites WHERE URLName like '_%org'
	SELECT * FROM ApprovedWebSites WHERE URLName like '%://%.org'
	SELECT * FROM ApprovedWebSites WHERE URLName like '_%://_%.org'

Question : 7	Which record will not return with the following WHERE clause? WHERE LastName like ‘T%’
Answer :	Thomas
	Atwater
	Tompter.
	TeeTee

Question : 8	Look at the following SQL statement: SELECT * FROM Employee LEFT OUTER JOIN Location ON Location.LocationID = Employee.LocationID What will be displayed in the result set?
Answer :	All records where both table match.
	All records in Employee including matches from Location.
	All records from Location including matches from Employee.
	The superset of both tables.

Question : 9	Which SQL keyword goes first when you want to make a new database?
Answer :	NEW
	CREATE
	UPDATE
	INSERT

Question : 10	BCP is a command-line utility that does what?
Answer :	It runs SQL scripts.
	It installs SQL Server.
	It imports data from any type of file.
	It imports data from a text file.

Enter Your Email:
Which city are you from ?
Any remarks ?

Home | Site Map | Privacy Policy | Disclaimer | Contact Us

Copyright © 2011 Joes2Pros.com. All rights reserved.
Website Designed and Marketed by Blue Digital