Quiz: Transforming Data and Functions
Test your knowledge of the database functions.
Transforming data and functions
1
What is the output of the following code?
SELECT COUNT(Customer) AS TotalIDs
FROM Cust.Customers
A)
The code outputs the number of columns with the TotalIDs
alias.
B)
The code outputs the records in the Cust.Customers
table including NULL with the TotalIDs
alias.
C)
The code outputs the number of records in the Cust.Customers
table excluding NULL
values with the TotalIDs
alias.
D)
The code outputs all the rows in the Cust.Customers
table with the TotalIDs
alias.
Question 1 of 70 attempted
Get hands-on with 1200+ tech skills courses.