Sql Quiz - MIIT -MIIT - We are Teaching PHP with MySql, provide Live Project training on PHP with MySql,we Teaching ASP.net with Sql Server, provide Live Project training on ASP.net with Sql Server handle by MIIT - Monarch Institute of Information Technology, surat, Gujarat


			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