Aggrea

Question 1

An organized collection of data stored in a computer system

Answer 1

Database

Question 2

What controls a database

Answer 2

Database management system

Question 3

Commonly used for data querying and writing

Answer 3

Structured Query Language (SQL)

Question 4

Raw and unprocessed information

Answer 4

Data

Question 5

A piece of information that can be translated into a form for efficient movement and processing

Answer 5

Data

Question 6

Interchangeable information

Answer 6

Data

Question 7

Database is also called

Answer 7

Structured data

Question 8

A piece of information that can be translated into a form for effecient movement and processing is called

Answer 8

Data

Question 9

Refers to related data in a structured form

Answer 9

Database

Question 10

Functions where the values of multiple rows are grouped as input on certain criteria to form a single result of more significant meaning

Answer 10

SQL Aggregate functions

Question 11

used to summarize data by combining multiple values to form a single result

Answer 11

SQL Aggregate Functions

Question 12

SQL aggregate functions are mostly used with the GROUP BY clase of the

Answer 12

SELECT statement

Question 13

Various aggregate functions

Answer 13

COUNT, SUM, AVG, MIN, MAX

Question 14

Returns the total number of records

Answer 14

Count (*)

Question 15

Create a table in SQL

Answer 15

CREATE TABLE Employee(
Id INT PRIMARY KEY,
Name char (100),
Salary int (100)
);

INSERT INTO Employee (Id, Name, Salary)
VALUES (1, ‘A’, 802), (2, ‘B’, 124);

Question 16

Count no. of employees

Answer 16

SELECT COUNT (*) AS TotalEmployees FROM Employee;

Question 17

Calculate the total salary

Answer 17

SELECT SUM(Salary) AS TotalSalary FROM Employee;

Question 18

Find the average salary

Answer 18

SELECT AVG(Salary) AS AverageSalary FROM Employee;

Question 19

Get the highest salary

Answer 19

SELECT MAX(Salary) AS HighestSalary FROM Employee;

Question 20

Determine the lowest salary

Answer 20

SELECT MIN (Salary) AS LowestSalary FROM Employee;