1. (TCO 6) To retrieve all fields from a table, use (Points : 3) SELECT ALL. SEL

Question

1. (TCO 6) To retrieve all fields from a table, use (Points : 3)        SELECT ALL.
       SELECT ANY.
       SELECT ().
       SELECT *.

       WHERE retail > 50 AND < 100 AND category = ‘COMPUTER’
       WHERE category = ‘COMPUTER’ AND (retail BETWEEN 100 and 50)
       WHERE category = ‘COMPUTER’ AND retail < 50 AND retail > 100
       WHERE category = ‘COMPUTER’ AND ( retail BETWEEN 50 AND 100)

Question 2. 2. (TCO 6) Which operator would be most appropriate to determine books with a retail price of more than $25? (Points : 3)        LIKE
       IN
       BETWEEN
       >

Explanation / Answer

Solution:

1.

Thus, the correct answer is SELECT *.

Question 2.

Thus, the correct answer is >.

Question 3.

Thus, the correct answer is DATE_FORMAT(HIREDATE, '%W, %M %D, %Y').

Question 4.

Thus, the correct answer is SELECT CONCAT(lastname, firstname) as “Name” FROM customer;

Question 5.

Thus, the correct answer is FROM.

Question 6.

Thus, the correct answer is SELECT orderid FROM orders WHERE shipdate IS NOT NULL;.

Question 7.

Thus, the correct answer is WHERE lastname LIKE ‘Smith%’.

Question 8.

Thus, the correct answer is Nothing is wrong;

Question 9.

Thus, the correct answer is DELETE.

Question 10.

Thus, the correct answer is WHERE category = ‘COMPUTER’ AND ( retail BETWEEN 50 AND 100).

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.