IS314_Quiz3

What SQL command is used to retrieve data from a database?

• GET

• RETRIEVE

• SELECT

• FETCH

How do you filter records in SQL using a specific condition?

• Utilize the JOIN clause to filter records.

• Apply the GROUP BY clause for filtering.

• Use the SELECT statement to filter records.

• Use the WHERE clause to filter records based on a specific condition.

Which SQL operator is used to combine multiple conditions that must all be true?

• NOT

• OR

• AND

• XOR

What operator would you use to combine conditions where at least one must be true?

• XOR

• OR

• NOT

• AND

What is the SQL command to create a new database?

• CREATE DATABASE database_name;

• ADD DATABASE database_name;

• INIT DATABASE database_name;

• NEW DATABASE database_name;

How do you define a new table in SQL?

• SELECT * FROM table_name;

• INSERT INTO table_name (column1, column2);

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

• ALTER TABLE table_name ADD column1 datatype;

What is the purpose of the NOT NULL constraint in a table?

• To prevent NULL values in a column.

• To automatically delete rows with NULL values.

• To enforce a default value for a column.

• To allow NULL values in a column.

How do you insert a new record into a table in SQL?

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

• DELETE FROM table_name WHERE condition;

• UPDATE table_name SET column1 = value1 WHERE condition;

• SELECT * FROM table_name WHERE condition;

What SQL command is used to modify existing records in a table?

• DELETE

• SELECT

• INSERT

• UPDATE

How can you delete records from a table in SQL?

• Use the DELETE statement: DELETE FROM table_name WHERE condition;

• To delete records, use the INSERT statement: INSERT INTO table_name VALUES (...);

• Remove records by using the SELECT statement: SELECT * FROM table_name;

• Use the UPDATE statement: UPDATE table_name SET column_name = value;