DBMS quiz1

What is the full form of DBMS?

• Dynamic Bandwidth Management System
• Database Management System
• Digital Business Management Software
• Data Backup Management System

Which of the following is not an example of DBMS?

• PostgreSQL
• Microsoft Excel
• Oracle Database
• MySQL

Which of the following is a type of DBMS model?

• Relational

• Network

• Hierarchical

• All of the above

Which model uses a tree structure to represent relationships among data?

• Network model
• Hierarchical model
• Relational model
• Object-oriented model

What SQL statement retrieves data from a database?

• INSERT
• UPDATE
• SELECT
• DELETE

What does normalization in a relational database help with? 

• Normalization eliminates the need for indexing.
• Normalization slows down database performance.
• Normalization helps reduce data redundancy and improve data integrity.
• Normalization increases data duplication.

What is a primary key used for? 

• To uniquely identify records in a database table.
• To create relationships between tables.
• To store large amounts of data.
• To define the structure of a database.

What does SQL stand for? 

• Structured Query Language
• Standard Query Language
• Structured Query List
• Simple Query Language

What is a foreign key in a relational database? 

• A foreign key is a unique identifier for a table.
• A foreign key is a type of index used for faster queries.
• A foreign key is a field that contains only null values.
• A foreign key is a field in a table that links to the primary key of another table.

What is a trigger in a database?

• A trigger is a data storage format for databases.
• A trigger is a type of database index.
• A trigger is a database object that automatically executes a specified action in response to certain events on a table.
• A trigger is a manual command executed by a user.