sql测试.doc

1. What does SQL stand for? Structured Query Language Strong Question Language Structured Question Language ? ? ?2. Which SQL statement is used to extract data from a database? GET SELECT EXTRACT OPEN ?3. Which SQL statement is used to update data in a database? SAVE AS SAVE MODIFY UPDATE 4. Which SQL statement is used to delete data from a database? DELETE REMOVE COLLAPSE ? ? ?5. Which SQL statement is used to insert new data in a database? INSERT NEW ADD RECORD INSERT INTO ADD NEW ?6. With SQL, how do you select a column named FirstName from a table named Persons? SELECT Persons.FirstName SELECT FirstName FROM Persons EXTRACT FirstName FROM Persons ? ? ?7. With SQL, how do you select all the columns from a table named Persons? SELECT [all] FROM Persons SELECT *.Persons SELECT * FROM Persons SELECT 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=Peter SELECT [all] FROM Persons WHERE FirstName LIKE Peter SELECT * FROM Persons WHERE FirstNamePeter 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=%a% SELECT * FROM Persons WHERE FirstName LIKE %a SELECT * FROM Persons WHERE FirstName LIKE a% 10. 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 ? ? ? ? 11. With SQL, how do you select all the records from a table named Persons where the FirstName is Peter and the LastName is Jackson? SELECT * FROM Persons WHERE FirstName=Peter AND LastName=Jackson SELECT * FROM Persons WHERE FirstNamePeter AND LastNameJackson SELECT Fi