yuusql

Question 1: What does SQL stand for?

• Strong Question Language
• Structured Query Language
• Structured Question Language

Question 2: Which SQL statement is used to extract data from a database?

• OPEN
• SELECT
• GET
• EXTRACT

Question 3: Which SQL statement is used to update data in a database?

• SAVE AS
• MODIFY
• UPDATE
• SAVE

Question 4: Which SQL statement is used to delete data from a database?

• COLLAPSE
• REMOVE
• DELETE

Question 5: Which SQL statement is used to insert new data in a database?

• ADD NEW
• ADD RECORD
• INSERT INTO
• INSERT NEW

Question 6: With SQL, how do you select a column named "FirstName" from a table named "Persons"?

• EXTRACT FirstName FROM Persons
• SELECT Persons.FirstName
• SELECT FirstName FROM Persons

Question 7: With SQL, how do you select all the columns from a table named "Persons"?

• SELECT * FROM Persons
• SELECT Persons
• SELECT [all] FROM Persons
• SELECT *.Persons

Question 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 * FROM Persons WHERE FirstName='Peter'
• SELECT * FROM Persons WHERE FirstName<>'Peter'
• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
• SELECT [all] FROM Persons WHERE FirstName='Peter'

Question 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 LIKE 'a%'
• SELECT * FROM Persons WHERE FirstName LIKE '%a'
• SELECT * FROM Persons WHERE FirstName='a'
• SELECT * FROM Persons WHERE FirstName='%a%'

Question 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