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.