Database Design and Development SQL 1

Which SQL clause is used to filter records?

• WHERE

• SELECT

• GROUP BY

• ORDER BY

What does the SQL statement "SELECT * FROM table1 WHERE column1 LIKE '%value%'" do?

• Selects all columns from table1 where column1 exactly matches 'value'

• Selects all columns from table1 where column1 contains 'value'

• Selects all rows from table1 where column1 is greater than 'value'

• Selects all unique rows from table1 where column1 contains 'value'

Which SQL statement is used to remove a table from a database?

• REMOVE TABLE table_name

• DELETE TABLE table_name

• DROP TABLE table_name

• ERASE TABLE table_name

In SQL, what function is used to count the number of rows in a table?

• SUM()

• COUNT()

• TOTAL()

• ADD()

What is the correct SQL statement to create a new table called "Employees"?

• CREATE Employees TABLE;

• CREATE TABLE Employees;

• NEW TABLE Employees;

• INIT TABLE Employees;

Which of the following SQL statements is used to update data in a database?

• MODIFY

• UPDATE

• CHANGE

• ALTER

In SQL, what is a primary key?

• A key that uniquely identifies each row in a table

• A key that can be used to encrypt data

• A key that is used to create relationships between tables

• A key that is used for indexing purposes

What does the SQL statement "SELECT column1, COUNT(*) FROM table1 GROUP BY column1;" do?

• Selects column1 and counts the number of occurrences in table1

• Selects column1 and counts distinct values in table1

• Selects column1 and counts all rows in table1

• Selects column1 and groups by count in table1

Which SQL keyword is used to sort the result-set in ascending order by default?

• SORT BY

• ORDER BY

• ARRANGE BY

• GROUP BY

How can you return all the rows from a table named "Products" where the column "Price" is between 50 and 100?

• SELECT * FROM Products WHERE Price BETWEEN 50 AND 100;

• SELECT * FROM Products WHERE Price IN (50, 100);

• SELECT * FROM Products WHERE Price > 50 AND < 100;

• SELECT * FROM Products WHERE Price = 50 AND 100;