MYSQL MANIPULATION PART 2

Which SQL statement would you use to select all columns from the BOOK_INFORMATION table?

• SELECT BOOK_ID + PRICE FROM BOOK_INFORMATION;

• SELECT * FROM BOOK_INFORMATION;

• SELECT ALL FROM BOOK_INFORMATION;

• SELECT ALL COLUMNS FROM BOOK_INFORMATION;

Which SQL statement would you use to select all books that has a price higher than 20?

• SELECT BOOK_ID FROM BOOK_INFORMATION HAVING PRICE > 20;

• SELECT BOOK_ID FROM BOOK_INFORMATION ONLY PRICE > 20;

• SELECT BOOK_ID FROM BOOK_INFORMATION WHERE BOOK_ID > 20;

• SELECT BOOK_ID FROM BOOK_INFORMATION WHERE PRICE > 20;

Which SQL statement would you use to select all books whose title starts with 'A'?

• SELECT BOOK_ID, BOOK_TITLE FROM BOOK_INFORMATION WHERE BOOK_TITLE LIKE 'A';

• SELECT BOOK_ID, BOOK_TITLE FROM BOOK_INFORMATION WHERE BOOK_TITLE IN 'A';

• SELECT BOOK_ID, BOOK_TITLE FROM BOOK_INFORMATION WHERE BOOK_TITLE LIKE 'A%';

• SELECT BOOK_ID, BOOK_TITLE FROM BOOK_INFORMATION WHERE BOOK_TITLE LIKE '%A';

Which SQL statement allows you to sort all books by price, from the highest price to lowest price?

• a) SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION ORDER BY PRICE DESC;

• SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION SORT BY PRICE DESC;

• SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION SORT BY PRICE ASC;

• SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION ORDER BY PRICE ASC;

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

• ADD INTO BOOK_INFORMATION WITH (20,'1KEYDATA SQL TUTORIAL',15);

• ) INSERT INTO BOOK_INFORMATION USING (20,'1KEYDATA SQL TUTORIAL',15);

• INSERT INTO BOOK_INFORMATION VALUES (20,'1KEYDATA SQL TUTORIAL',15);

• ADD INTO BOOK_INFORMATION VALUES (20,'1KEYDATA SQL TUTORIAL',15);

Which SQL statement lets you remove the table BOOK_INFORMATION from the database?

• DROP BOOK_INFORMATION;

• DELETE TABLE BOOK_INFORMATION;

• TRUNCATE TABLE BOOK_INFORMATION;

• DROP TABLE BOOK_INFORMATION;

Which SQL statement would you use to delete the row for BOOK_ID=15?

• TRUNCATE TABLE BOOK_INFORMATION WHERE BOOK_ID = 15;

• DELETE FROM BOOK_INFORMATION WHERE BOOK_ID = 15;

• DROP BOOK_INFORMATION WHERE BOOK_ID = 15;

• TRUNCATE BOOK_INFORMATION WHERE BOOK_ID = 15;

Which SQL statement will you use to change the price for the BOOK titled 'ELEMENTARY SCHOOL GUIDE' to 20?

• UPDATE TABLE BOOK_INFORMATION SET PRICE = 20 WHERE BOOK_TITLE = 'ELEMENTARY SCHOOL GUIDE';

• UPDATE TABLE BOOK_INFORMATION SET PRICE = 20 WHERE BOOK_ID = 'ELEMENTARY SCHOOL GUIDE';

• UPDATE BOOK_INFORMATION SET PRICE = 20 WHERE BOOK_TITLE = 'ELEMENTARY SCHOOL GUIDE';

• UPDATE BOOK_INFORMATION CHANGE PRICE = 20 WHERE BOOK_TITLE = 'ELEMENTARY SCHOOL GUIDE';

Which SQL statement allows you to find the highest price from the table BOOK_INFORMATION?

• SELECT BOOK_ID, BOOK_TITLE, MAX(PRICE) FROM BOOK_INFORMATION;

• SELECT MAX(PRICE) FROM BOOK_INFORMATION;

• SELECT MAXIMUM(PRICE) FROM BOOK_INFORMATION;

• SELECT PRICE FROM BOOK_INFORMATION ORDER BY PRICE DESC;

Which SQL statement allows you to find all books priced between 15 and 20?

• SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION HAVING PRICE BETWEEN 15 AND 20;

• SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION HAVING PRICE IS BETWEEN 15 AND 20; 
  

• SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION WHERE PRICE BETWEEN 15 AND 20;

• SELECT BOOK_ID, BOOK_TITLE, PRICE FROM BOOK_INFORMATION WHERE PRICE IS BETWEEN 15 AND 20;