SQL by Nexzen coaching

SELECT

INSTR("Informatics","m");

• 4

• 5

• 6

• 7

SELECT

INSTR("Informatics",

"am");

• 0

• 6

• 5

• 7

SELECT LENGTH("DELHI")

• 4

• 5

• 6

• 7

Select mid("Database Query using SQL", 3, 7);

• database

• tabas

• tabase

• tabase u

Select length(Ieft("Database Query using SQL", 7));

• databas

• 7

• database

• databas

SELECT RIGHT("DANA MAJHIA",4)

• JHI

• JHIA

• AJHIA

• MAJHI

Which SQL clause is used to filter the results of a SELECT statement?

• GROUPBY

• WHERE

• OPERATOR

• UNION

In SQL, what is the purpose of the GROUP BY clause?

• To filter rows based on a condition

• To sort the result set in ascending order

• To group rows with the same values into summary rows

• To join multiple tables together

What is the purpose of the SQL WHERE clause?

• To specify the order of rows in the result set

• To filter rows based on a condition

• To group rows with the same values

• To perform mathematical calculations

What does an SQL aggregate function do?

• Selects distinct values from a table

• Performs calculations on a set of values and returns a single result

• Orders the rows of a table based on a specific column

• Joins two or more tables together