SQL Functions

SQL Functions

Professional Development

10 Qs

quiz-placeholder

Similar activities

Bermain Gambar

Bermain Gambar

1st Grade - Professional Development

15 Qs

Quality Day 22 Oct 2021

Quality Day 22 Oct 2021

Professional Development

10 Qs

gta san adres

gta san adres

KG - Professional Development

10 Qs

Ice Breaker Challenge- Guess the Tool by Its Logo

Ice Breaker Challenge- Guess the Tool by Its Logo

Professional Development

10 Qs

Office T&T

Office T&T

Professional Development

12 Qs

Digital Tools in Education Pre-Test

Digital Tools in Education Pre-Test

Professional Development

10 Qs

rappers

rappers

7th Grade - Professional Development

6 Qs

Datatypes and Flowcontrol

Datatypes and Flowcontrol

Professional Development

15 Qs

SQL Functions

SQL Functions

Assessment

Quiz

Computers

Professional Development

Practice Problem

Medium

Created by

Suheba Mubashir

Used 17+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The SQL statement to count distinct rows from a column is,

select COUNT DISTINCT columnname AS total_rows from tablename;

select (COUNT DISTINCT columnname) AS total_rows from tablename;

select DISTINCT columnname AS total_rows from tablename;

select COUNT (DISTINCT) AS total_rows from tablename;

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The COUNT() function also counts the NULL values.

True

False

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The SUM() function returns - - -

some random values from the given column

the total number of columns in the database

the total number of tables in the given databases

the total sum of a given numeric column

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a column named "age", containing values 4, 5, 6, the SQL statement "SELECT SUM(age) FROM students;" will return,

3

15

0

1

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The MIN() function returns - - - in the given column.

the largest value

the last value

the total sum value

the smallest value

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The MAX() function returns - - - in the given column.

the largest value

the last value

the total sum value

the smallest value

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The average value of the given numeric column is calculated by using - - - function.

GETAVG()

FINDAVG()

AVG()

AVGVALUE()

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?