12th Informatics Practices SQL

-------is an organised collection of data

• Database

• System

• Internet

• Computer

________is a collection of programs that manage the database structure and controls access to the data stored in the database.

• Database

• Database management system

• File system control

• File control

_____ return the absolute value of a number.

• ABS ()

• ACOS()

• ASIN()

• ATAN()

______ returns a number rounded to a certain number of decimal places.

• POW()

• ROUND()

• MOD()

• SIGN ()

It returns the square root of a number

• SQRT()

• MOD ()

• POW()

• SIGN()

______returns the current date and time

• CURDATE()

• CURTIME()

• DATE()

• NOW()

_______Returns the average value after calculating from values in numeric form.

• COUNT()

• FIRST()

• LAST()

• AVG ()

SQL______statement is used to insert single and multiple row in table.

• INSERT

• SELECT

• UPDATE

• DELETE

________statement is used to query and retrieve data from a table in the database.

• INSERT

• UPDATE

• DELETE

• SELECT

SQL_____ clause is used to arrange identical data into groups.

• GROUP BY

• ORDER BY

• HAVING

• SELECT