MYSQL Functions

MYSQL Functions

12th Grade

8 Qs

quiz-placeholder

Similar activities

Bài 3.Giới thiệu Microsoft Access

Bài 3.Giới thiệu Microsoft Access

10th - 12th Grade

10 Qs

Sept 14 quiz

Sept 14 quiz

9th - 12th Grade

10 Qs

Chapter 1: Computer Basics Quiz

Chapter 1: Computer Basics Quiz

9th - 12th Grade

10 Qs

Go Beyond the Sales LAP Quiz

Go Beyond the Sales LAP Quiz

9th - 12th Grade

10 Qs

AP CSP Review 11Q

AP CSP Review 11Q

10th - 12th Grade

11 Qs

 Unit 4 Advanced AP CSP

Unit 4 Advanced AP CSP

9th - 12th Grade

10 Qs

STRING

STRING

11th - 12th Grade

13 Qs

EMAILING 📧 AND CALENDARING 🗓

EMAILING 📧 AND CALENDARING 🗓

10th - 12th Grade

10 Qs

MYSQL Functions

MYSQL Functions

Assessment

Quiz

Computers

12th Grade

Medium

Created by

D S

Used 27+ times

FREE Resource

AI

Enhance your content in a minute

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

8 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a text function?

TRIM()

TRUNCATE()

LEFT()

MID()

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will be printed by the given query?

SELECT LENGTH( " INFORMATICS PRACTICES");

21

22

23

24

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a numeric function?

MOD

SIGN

MID

POW

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is not a date function?

Month

Year

Now

Pow

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which of the following functions returns the substring from a given string?

MID

INSTR

SUBSTR

CHAR

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will be returned by the given query?

SELECT INSTR("INDIA", "DI");

2

3

-2

-3

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will be returned by the given query?

SELECT round(153.669, 2);

153.6

153.66

153.67

153.7

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?