SQL and Operators Quiz

Grace is working on a project and needs to retrieve data from a database. What does the SQL SELECT statement do?

• Retrieves data from a database

• Creates a new database

• Updates data in a database

• Deletes data from a database

How can Grace calculate her monthly expenses using SQL?

• Grace can calculate her monthly expenses in SQL using logical operators like AND, OR, NOT.

• Grace can calculate her monthly expenses in SQL using operators like +, -, *, /, %.

• Calculating monthly expenses in SQL can only be done using functions like SUM, AVG, COUNT.

• Grace can calculate her monthly expenses in SQL by defining custom functions for each operation.

What are some common comparison operators used in a database management system?

• =, <>, >, <, >=, <=, BETWEEN, LIKE, IN, IS NULL, IS NOT NULL

• ><

• IS NOT EMPTY

• =<

• BETWEEN AND

Explain the difference between AND and OR logical operators in SQL using a real-world scenario.

• The AND logical operator requires all conditions to be true, while the OR logical operator requires at least one condition to be true.

• The AND logical operator requires at least one condition to be true, while the OR logical operator requires all conditions to be true.

• AND and OR logical operators have no difference in SQL.

• AND and OR logical operators are interchangeable and can be used in the same way.

What is the purpose of DML queries in SQL?

• DML queries in SQL are only used for reading data from a database

• DML queries in SQL are primarily used for designing user interfaces

• DML queries in SQL are used for creating new databases

• The purpose of DML queries in SQL is to manipulate data in a database.

What is an example of creating a new table in a database?

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

• UPDATE TABLE table_name (column1 datatype, column2 datatype, ...);

• ALTER TABLE table_name ADD column_name datatype;

• CREATE TABLE table_name (column1 datatype, column2 datatype, ...);

When would a data analyst use the SQL SELECT statement?

• When they want to insert data into a database table.

• When they want to update data in a database table.

• When they want to retrieve data from a database table.

• When they want to delete data from a database table.

What is the result of adding 10 apples and 5 baskets of 2 oranges each?

• 25

• 12

• 15

• 20

What are some commonly used logical operators in database management systems?

• XOR

• AND, OR, NOT

• IN

• NAND

How do you insert a new record into a student database using SQL?

• UPDATE student_table SET name = 'Kai', age = 20, ...

• INSERT student_table (name, age, ...) VALUES ('Benjamin', 22, ...)

• ADD INTO student_table (name, age, ...) VALUES ('Zoe', 21, ...)

• INSERT INTO student_table (name, age, ...) VALUES ('Kai', 23, ...)