SQL and Database Management Quiz

What does the SQL command DROP do in a database management system?

• Erase all data from a table

• Delete a table from the database

• Remove a specific column from a table

• Add a new database to the system

Which SQL command is used to add a new row of data into an existing table?

• ADD ROW

• INSERT INTO

• CREATE ROW

• APPEND

In SQL, what does the GROUP BY clause generally follow?

• WHERE

• ORDER BY

• AS

• FROM

To create a copy of a complex query that can be accessed as a virtual table, which SQL feature is used?

• REPLICATE

• SAVE QUERY

• REUSE

• VIEWS

Which SQL command is used to create a new table in a database management system like MySQL?

• UPDATE

• MAKE

• CREATE TABLE

• ADD

What type of SQL statement is used to apply a filter condition after the data has been retrieved?

• HAVING

• FILTER BY

• SELECT IF

• CONDITION

In SQL, what is the purpose of the PRIMARY KEY constraint?

• Ensure the column allows NULL values

• Identify a unique row in a table

• Define a default value for a column

• Indicate a foreign relationship between tables

Which SQL statement is used to retrieve data from a database table in MySQL?

• GET

• LOAD

• SELECT

• RECEIVE

When transforming an Entity-Relationship Diagram (ERD) into relational tables, what does a supertype/subtype relationship signify?

• Multiple entities are subordinates to a single entity

• A single entity can be classified into multiple sub-entities

• Each entity belongs to only one subtype

• Subtypes are excluded from the database

What type of relationship is represented in an entity-relationship diagram where an entity in Table A is associated with only one entity in Table B and vice versa?

• One-to-Many

• One-to-One

• Many-to-Many

• None of the above