Query
About
meet the crew
Portfolio
have a look
Courses
what we do
Careers
step forward
Gallery
our Album
SQL Quiz
Back
1. What does SQL stand for?
Structure Query Language
Server Query Language
Strong Question Language
Structure Question Language
2. Which SQL statement is used to extract data from a database?
EXTRACT
GET
OPEN
SELECT
3. Which SQL statement is used to update data in a database?
UPDATE
SAVE AS
MODIFY
SAVE
4. Which SQL statement is used to delete data from a database?
REMOVE
DELETE
DROP
TRUNCATE
5. Which SQL statement is used to insert new data in a database?
ADD RECORD
ADD INTO
INSERT
ADD NEW
6. With SQL, how do you select a column named "FirstName" from a table named "Persons"?
EXTRACT FirstName FROM Persons
SELECT FirstName FROM Persons
SELECT Persons.FirstName
MODIFY Persons.FirstName
7. With SQL, how do you select all the columns from a table named "Persons"?
SELECT [all] FROM Persons
SELECT All Persons
SELECT *.Persons
SELECT * FROM Persons
8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT * FROM Persons WHERE FirstName LIKE 'Peter'
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName='Peter'
9. 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 LIKE 'a%'
SELECT * FROM Persons WHERE FirstName='a'"
10. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen'
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
11. Which SQL statement is used to return only different values?
SELECT UNIQUE
SELECT INDENTITY
SELECT DIFFERENT
SELECT DISTINCT
12.
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<'Pettersen' FROM Persons
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT * FROM Persons WHERE LastName
13. Which SQL keyword is used to sort the result-set?
SORT BY
ORDER
ORDER BY
SORT
14. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
True
False
15.
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
DELETE FROM Persons WHERE FirstName = 'Peter'
DELETE ROW FirstName='Peter' FROM Persons
DELETE FirstName='Peter' FROM Persons
DROP Persons WHERE FirstName 'Peter'
Contact Us :
401, Nandanvan Apartment,Bhavaniwad, Haripura, surat - 395 003
Phone: 0261-2608986 Mobile : +91- 94299-87892
Email:
miit@helpsurat.com
Home
|
About us
|
Portfolio
|
Courses
|
Careers
|
FAQS
|
Query
|
Contact Us
2010 © Copyrights. All Rights Reserved.
www.helpsurat.com