Login/Logout System

Topics: SQL, Relational model, Table Pages: 3 (508 words) Published: August 22, 2013
SQL QUIZ| Points: 11 out of 20|
1. What does SQL stand for?
You answered:
Structured Query Language
 Correct Answer!

2. Which SQL statement is used to extract data from a database? You answered:
GET
 Wrong Answer!

3. Which SQL statement is used to update data in a database? You answered:
UPDATE
 Correct Answer!

4. Which SQL statement is used to delete data from a database? You answered:
DELETE
 Correct Answer!

5. Which SQL statement is used to insert new data in a database? You answered:
INSERT INTO
 Correct Answer!

6. With SQL, how do you select a column named "FirstName" from a table named "Persons"? You answered:
SELECT FirstName FROM Persons
 Correct Answer!

7. With SQL, how do you select all the columns from a table named "Persons"? You answered:
SELECT * FROM Persons
 Correct Answer!

8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"? You answered:
SELECT * FROM Persons WHERE FirstName='Peter'
 Correct Answer!

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"? You answered:
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
 Correct Answer!

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 You answered:
False
 Wrong Answer!

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"? You answered:
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'  Correct Answer!

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"? You answered:
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'  Correct Answer!

13. Which SQL...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Login Logout System Research Paper
  • Essay about Login/Logout System
  • Project Design
  • Login Logout Essay
  • Login system chaper 1 Essay
  • login Essay
  • Essay about Voting System
  • Login Essay

Become a StudyMode Member

Sign Up - It's Free