MYSQL - Functions In Mysql Online Test, MYSQL - Functions In Mysql 50 MCQ Question Mock Test

Infomax Computer Academy

Database management system
Introduction to mysql
Managing databases in mysql
Working with tables in mysql
Constraints and relationships in mysql
Querying data in mysql
Sorting data in mysql
Filtering data in mysql
Joining tables in mysql
Grouping data in mysql
Functions in mysql
Import and export in mysql

MYSQL - Functions In Mysql

Questions No: 1/3

Report Bug

What is the purpose of the SQL BINARY operator?

SQL बाइनरी ऑपरेटर का उद्देश्य क्या है?

Converts a string to uppercase

Performs a case-sensitive comparison

Adds two binary numbers

Converts a string to lowercase

Questions No: 2/3

Report Bug

Which SQL statement is used to count the number of rows in a table?

किसी तालिका में पंक्तियों की संख्या गिनने के लिए किस SQL कथन का उपयोग किया जाता है?

TOTAL ROWS

COUNT ROWS

NUMROWS

SELECT COUNT(*)

Questions No: 3/3

Report Bug

Which SQL function is used to return the square root of a numeric value?

किसी संख्यात्मक मान का वर्गमूल लौटाने के लिए किस SQL फ़ंक्शन का उपयोग किया जाता है?

SQR()

SQRT()

ROOT()

POWER()