Crowdly

Add to Chrome

Universities
moodle.telt.unsw.edu.au
INFS1603-Intro to Business Databases - T1/2026

INFS1603-Intro to Business Databases - T1/2026

Looking for INFS1603-Intro to Business Databases - T1/2026 test answers and solutions? Browse our comprehensive collection of verified answers for INFS1603-Intro to Business Databases - T1/2026 at moodle.telt.unsw.edu.au.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

W05-FW04-07. Which of the following SQL statements is not valid?

SELECT cost, retail, TO_CHAR(retail-cost, '$999.99') profit FROM books;

SELECT TO_CHAR(orderdate, '99/9999') FROM orders;

100%

SELECT INITCAP(firstname), UPPER(lastname) FROM customers;

all of the above

View this question

W05-FW04-08. Which of the following SQL statements displays a customer’s name in all uppercase characters?

SELECT UPPER('firstname', 'lastname') FROM customers;

SELECT UPPER(firstname, lastname) FROM customers;

none of the above

100%

SELECT UPPER(lastname, ',' firstname) FROM customers;

View this question

W05-FW04-06. Which of the following displays the order date for order 1000 as 03/31?

SELECT TO_CHAR(orderdate, 'MONTH/YY') FROM orders WHERE order# = 1000;

SELECT TO_CHAR(orderdate, 'Mth/DD') FROM orders WHERE order# = 1000;

SELECT TO_CHAR(orderdate, 'MM/DD') FROM orders WHERE order# = 1000;

100%

none of the above

View this question

Want instant access to all verified answers on moodle.telt.unsw.edu.au?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Add to Chrome