Fundamentals of SQL for BBA(IT) Students

What is the purpose of SQL?

• To create and design websites.

• The purpose of SQL is to manage and manipulate relational databases.

• To write programming languages.

• To manage hardware components.

Which of the following is a SQL data type?

• BOOLEAN

• CHAR

• FLOAT

• INTEGER

What command is used to retrieve data from a database?

• DELETE

• UPDATE

• SELECT

• INSERT

How do you select all columns from a table named 'students'?

• SELECT * FROM students;

• SELECT ALL FROM students;

• FETCH * FROM students;

• GET * FROM students;

What SQL function is used to count the number of rows in a table?

• SUM()

• AVG()

• COUNT()

• MAX()

Which operator is used to filter records in a SQL query?

• SELECT

• FILTER

• WHERE

• GROUP BY

What is the default sorting order of the ORDER BY clause?

• random

• ascending

• by length

• descending

Which SQL statement is used to update existing records in a table?

• INSERT

• DELETE

• SELECT

• UPDATE

What data type would you use for a field that stores dates?

• string

• date

• boolean

• integer

How do you insert a new record into a table named 'employees'?

• DELETE FROM employees WHERE column1 = value1;

• INSERT INTO employees (column1, column2) VALUES (value1, value2);

• UPDATE employees SET column1 = value1;

• SELECT * FROM employees WHERE column1 = value1;