CIS 336 DeVry Week 4 Quiz Latest

Downloading is very simple, you can download this Course here:

http://wiseamerican.us/product/cis-336-devry-week-4-quiz-latest/

Or

Contact us at:

SUPPORT@WISEAMERICAN.US

CIS 336 DeVry Week 4 Quiz Latest

CIS336

CIS 336 DeVry Week 4 Quiz Latest

Question 1. Question : (TCO 6) To retrieve all fields from a table, use

  • SELECT ALL.
  • SELECT ANY.
  • SELECT ().
  • SELECT *.

Question 2. Question : (TCO 6) Which operator would be most appropriate to determine books with a retail price in the range of $50 to $100?

  • LIKE
  • IN
  • BETWEEN
  • >

Question 3. Question : (TCO 6) Which code returns the date field HIREDATE in the format: Friday, April 5th, 2015?

  • DATE_FORMAT(HIREDATE, ‘%W, %m %d, %Y’)
  • DATE_FORMAT(HIREDATE, ‘%a, %M %D, %Y’)
  • DATE_FORMAT(HIREDATE, ‘%W, %M %D, %Y’)
  • DATE_FORMAT(HIREDATE, ‘%a, %m %d, %y’)

Question 4. Question : (TCO 6) Given a customer table with fields for firstname and lastname, which of the following will display the customer name as a single field in the format “Jones, Tom” with a heading?

  • SELECT CONCAT(lastname, firstname) as “Name” FROM customer;
  • SELECT CONCAT(firstname, lastname) as “Name” FROM customer;
  • SELECT CONCAT(lastname, ‘, ‘, firstname) as “Name” FROM customer;
  • SELECT CONCAT lastname ‘, ‘ firstname as “Name” FROM customer;

Question 5. Question : (TCO 8) The column to be updated by the UPDATE command is specified in the _____ clause.

  • WHERE
  • MODIFY
  • ALTER
  • SET

Question 6. Question : (TCO 6) Given a table orders with fields for orderid, orderdate, and shipdate, which query will display the ordered for only those orders that have not shipped?

  • SELECT orderid FROM orders WHERE shipdate = orderdate;
  • SELECT orderid FROM orders WHERE shipdate IS NOT NULL;
  • SELECT orderid FROM orders WHERE shipdate IS NULL;
  • SELECT orderid FROM orders;

Question 7. Question : (TCO 6) Which WHERE clause will return data on all employees with a last name beginning with ‘S’?

  • WHERE lastname = ‘S’
  • WHERE lastname = ‘S%’
  • WHERE lastname LIKE ‘S’
  • WHERE lastname LIKE ‘S%’

Question 8. Question : (TCO 6) Given a books table with fields of title, cost, and retail, what if anything is wrong with the following query (assuming all fields exist)?

SELECT * FROM books WHERE cost > 20 ORDER BY retail;

  • You must sort and filter on the same field.
  • You cannot use ORDER BY and WHERE in the same query.
  • The WHERE clause must always be last.
  • Nothing is wrong.

Question 9. Question : (TCO 8) You can delete one or more rows in a table by using the _____ command.

  • UPDATE
  • DROP
  • DELETE
  • ALTER

Question 10. Question : (TCO 6) Given a books table with fields: title, category (such as ‘SPORTS’), cost, retail; what condition will return ‘COMPUTER’ books with a retail price between $50 and $100 ?

  • 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)