GRADE 9- 4QTR-FINALS

1.       This SQL function is used to return a single value from a group of rows or columns.

• Aggregate      

• Scalar

• Analytic

     Which of the following aggregate functions returns the number of rows based on a given criterion?

• Avg     

• Max                

• Count  

   These are built-in commands in SQL that are used to manipulate values with columns.

• Formulas        

• Expressions    

• Functions

    Which of the following aggregate functions returns the smallest value in a given column?

• Avg     

• Max    

• Min

Which of the following aggregate functions returns the largest value in a given column? 

• Avg

• Max    

• Count

This SQL function deals with string values.

•     String functions

• Security functions

• Mathematical functions

What will be the output of the statement below?

SELECT CONCAT('Dela Cruz, ', 'Juan ', 'C.') AS name

• Dela Cruz, Juan C.

• .  DelaCruz, JuanC.

•    Dela Cruz, Juan C

The CHAR function is categorized under _______.

•    String functions

• Date and Time functions

• Mathematical functions

    What will be the output of the statement below?

SELECT REPLACE('dxtxbxse mxnxgement', 'x', 'a') AS replace

• dxtxbxse mxnxgement

• database management

•   database managamant

  Which is an example of a mathematical function?

• SQRT()

• TRIM()

• LEN()