home   Query   contact
 
    logo  
  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'
 
 
   
 
 
footer