Database Design Concepts

19 Questions

What is the purpose of the INSERT statement in SQL?

To insert data into a table

When using DML commands in SQL, what does the COMMIT command do?

Save all the transactions to the database

Which SQL command is used to remove rows from a table?

DELETE

What is the purpose of the DCL command 'Revoke' in SQL?

Remove access privileges from a database user

In SQL, what type of commands can be controlled by TCL commands?

Data Manipulation Language (DML) commands

What is the purpose of the SAVEPOINT command in SQL?

Roll back the transaction to a specific point

'Grant' and 'Revoke' are examples of commands in which category of SQL commands?

'Grant' and 'Revoke' are DCL commands

'SELECT' command in SQL is used for which purpose?

Fetch data from the database

'Rollback' command in SQL is used for what purpose?

'Rollback' is used to undo transactions not saved to the database

What does an entity represent in a database management system?

A real-world object or concept like a person or place

How are attributes typically represented in an ER diagram?

As ovals connected to entities

In an ER diagram, how are relationships between entities depicted?

As diamond shapes

What is the primary function of a primary key in an ER diagram?

To uniquely identify each entity record

How does an ER diagram help in database management?

By visually representing entity sets and their relationships

Which symbol is typically used to represent an attribute in an ER diagram?

Oval connected to an entity

What is the main purpose of an ER diagram in database design?

To visually represent relationships among entities

Which component of an ER Diagram represents a real-world object or concept?

Entity

What does a Primary Key serve as in an ER diagram?

A unique identifier for each record in an entity

In an ER diagram, how are relationships between entities usually depicted?