SQL Quiz Results

Table BOOK_INFORMATION

1. Which SQL statement would you use to select all columns from the BOOK_INFORMATION table?
Correct Answer: b) SELECT * FROM BOOK_INFORMATION;
Your Answer: No Answer

2. Which SQL statement would you use to select all books that has a price higher than 20?
Correct Answer: d) SELECT BOOK_ID FROM BOOK_INFORMATION WHERE PRICE > 20;
Your Answer: No Answer

3. Which SQL statement would you use to select all books whose title starts with 'A'?
Correct Answer: c) SELECT BOOK_ID, BOOK_TITLE FROM BOOK_INFORMATION WHERE BOOK_TITLE LIKE 'A%';
Your Answer: No Answer

4. Which SQL statement allows you to sort all books by price, from the highest price to lowest price?
Correct Answer: a) SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION ORDER BY PRICE DESC;
Your Answer: No Answer

5. Which SQL statement allows you to insert the following piece of data into BOOK_INFORMATION?
  BOOK_ID=20
  BOOK_TITLE='1KEYDATA SQL TUTORIAL'
  PRICE=15
Correct Answer: c) INSERT INTO BOOK_INFORMATION VALUES (20,'1KEYDATA SQL TUTORIAL',15);
Your Answer: No Answer

6. Which SQL statement lets you remove the table BOOK_INFORMATION from the database?
Correct Answer: d) DROP TABLE BOOK_INFORMATION;
Your Answer: No Answer

7. Which SQL statement would you use to delete the row for BOOK_ID=15?
Correct Answer: b) DELETE FROM BOOK_INFORMATION WHERE BOOK_ID = 15;
Your Answer: No Answer

8. Which SQL statement will you use to change the price for the BOOK titled 'ELEMENTARY SCHOOL GUIDE' to 20?
Correct Answer: a) UPDATE BOOK_INFORMATION SET PRICE = 20 WHERE BOOK_TITLE = 'ELEMENTARY SCHOOL GUIDE';
Your Answer: No Answer

9. Which SQL statement allows you to find the highest price from the table BOOK_INFORMATION?
Correct Answer: b) SELECT MAX(PRICE) FROM BOOK_INFORMATION;
Your Answer: No Answer

10. Which SQL statement allows you to find all books priced between 15 and 20?
Correct Answer: c) SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION WHERE PRICE BETWEEN 15 AND 20;
Your Answer: No Answer

Questions 11 - 15 uses the following table:

Table SALES

11. Which SQL statement lets you find the sales amount for each store?
Correct Answer: c) SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID;
Your Answer: No Answer

12. Which SQL statement lets you list all stores whose total sales amount is over 5000?
Correct Answer: a) SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID HAVING SUM(SALES_AMOUNT) > 5000;
Your Answer: No Answer

13. Which SQL statement is the correct one to use to find the earliest date STORE_ID 10 had a sales amount greater than 0?
Correct Answer: d) SELECT MIN(SALES_DATE) FROM SALES WHERE STORE_ID = 10 AND SALES_AMOUNT > 0;
Your Answer: No Answer

14. Which SQL statement lets you find the total number of stores in the SALES table?
Correct Answer: b) SELECT COUNT(DISTINCT STORE_ID) FROM SALES;
Your Answer: No Answer

15. Which SQL statement allows you to find the total sales amount for Store ID 25 and the total sales amount for Store ID 45?
Correct Answer: a) SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES WHERE STORE_ID IN (25,45) GROUP BY STORE_ID;
Your Answer: No Answer

Questions 16-25 use the following table:

Table EXAM_RESULTS

16. What is the result of the following SQL statement:
SELECT COUNT(DISTINCT STUDENT_ID) FROM EXAM_RESULTS;
Correct Answer: c) 5
Your Answer: No Answer

17. What SQL statement do we use to find the average exam score for EXAM_ID = 1?
Correct Answer: b) SELECT AVG(EXAM_SCORE) FROM EXAM_RESULTS WHERE EXAM_ID = 1;
Your Answer: No Answer

18. Which SQL statement do we use to find out how many students took each exam?
Correct Answer: c) SELECT EXAM_ID, COUNT(DISTINCT STUDENT_ID) FROM EXAM_RESULTS GROUP BY EXAM_ID;
Your Answer: No Answer

19. What SQL statement do we use to print out the record of all students whose last name starts with 'L'?
Correct Answer: a) SELECT * FROM EXAM_RESULTS WHERE LAST_NAME LIKE 'L%';
Your Answer: No Answer

20. What is the result of the following SQL statement:
SELECT MAX(EXAM_SCORE) FROM EXAM_RESULTS WHERE EXAM_ID = 1 and FIRST_NAME LIKE '%E%';
Correct Answer: d) 78
Your Answer: No Answer

21. What SQL statement do we use to print out the records of all students whose first name or last name ends in 'A'?
Correct Answer: a) SELECT * FROM EXAM_RESULTS WHERE FIRST_NAME LIKE '%A' OR LAST_NAME LIKE '%A';
Your Answer: No Answer

22. What SQL statement do we use to find the name of all students who scored better than 90 on the second exam (EXAM_ID = 2)?
Correct Answer: b) SELECT FIRST_NAME, LAST_NAME FROM EXAM_RESULTS WHERE EXAM_ID = 2 AND Exam_SCORE > 90;
Your Answer: No Answer

23. What SQL statement do we use to find the name of all students who scored better than 180 on all the Exams?
Correct Answer: c) SELECT FIRST_NAME, LAST_NAME, SUM(EXAM_SCORE) FROM EXAM_RESULTS GROUP BY FIRST_NAME, LAST_NAME HAVING SUM(EXAM_SCORE) > 180;
Your Answer: No Answer

24. How many records does the following SQL statement generate?
SELECT * FROM EXAM_RESULTS WHERE LAST_NAME LIKE '%N%' AND EXAM_SCORE > 88;
Correct Answer: b) 3
Your Answer: No Answer

25. How many records does the following SQL statement return?
SELECT * FROM EXAM_RESULTS WHERE STUDENT_ID <= 12 AND EXAM_SCORE > 85;
Correct Answer: c) 3
Your Answer: No Answer