NEW
Font size
WorksheetsIntroduction to DBMS Concepts
Total questions: 25
Worksheet time: 19mins
What is a database model?
A database model is a type of software application.
A database model is a framework for organizing and managing data in a database.
A database model is a method for creating user interfaces.
A database model is a programming language for data manipulation.
Name three types of database models.
Hierarchical model
Relational model, Document model, Key-value model
Object-oriented model
Graph model
What does SQL stand for?
Standard Query Language
Simple Query Language
Structured Query Language
Structured Query List
What is the purpose of SQL in a DBMS?
The purpose of SQL in a DBMS is to manage and manipulate relational databases.
To visualize data through graphical interfaces.
To store data in a non-relational format.
To create and design new databases.
Define primary key in a database.
A primary key can contain duplicate values in a table.
A primary key is used to store large amounts of data in a database.
A primary key is a unique identifier for a record in a database table.
A primary key is a type of foreign key in a database.
What is a foreign key?
A foreign key is a type of primary key.
A foreign key is a unique identifier for a single table.
A foreign key is a field that stores images in a database.
A foreign key is a field that links two tables in a relational database.
What does ERD stand for?
Entity-Relationship Diagram
Entity-Reference Diagram
Entity-Relation Diagram
Entity-Resource Diagram
What is the purpose of an ERD?
To generate reports based on database queries.
The purpose of an ERD is to illustrate the relationships and data structure within a database.
To display the user interface of a database application.
To store data in a physical format on disk.
List the main components of an ERD.
Columns, Rows, Keys, Constraints
Diagrams, Models, Schemas, Queries
Tables, Views, Indexes, Triggers
Entities, Attributes, Relationships, Cardinalities
What is the difference between a relational and a non-relational database?
Relational databases are structured and use tables with relationships; non-relational databases are flexible and can store unstructured data.
Relational databases are only for small datasets; non-relational databases are for large datasets.
Relational databases are always faster than non-relational databases.
Relational databases do not support transactions; non-relational databases do.
What is a schema in the context of a database?
A schema is a type of database management system.
A schema is a collection of user data stored in a database.
A schema is a programming language used for database queries.
A schema is a blueprint that outlines the structure and organization of a database.
What is the role of a DBMS?
To create user interfaces for applications.
To store data in a file system format.
To perform complex mathematical calculations.
The role of a DBMS is to manage and facilitate access to databases.
What is a database?
A database is an organized collection of data that can be easily accessed, managed, and updated.
A database is a collection of random files without structure.
A database is a type of software used for graphic design.
A database is a physical storage device for files.
Define DBMS and its purpose.
A DBMS is a cloud service that only stores images.
A DBMS is a programming language for creating applications.
A DBMS is software that manages databases, allowing for efficient data storage, retrieval, and administration.
A DBMS is a type of hardware used for data storage.
What are the different types of databases?
Relational, NoSQL, In-memory, Time-series
Object-oriented
Graph
Flat-file
Explain the concept of data independence.
Data independence refers to the ability to store data in a single location.
Data independence is the process of backing up data to prevent loss.
Data independence means that all data must be stored in a flat file format.
Data independence is the ability to change the schema at one level without affecting other levels in a database system.
What is the relational model?
A data model that organizes data into tables (relations) with defined relationships between them.
A model that uses only hierarchical structures for data storage.
A framework for managing unstructured data without relationships.
A system that organizes data in a single flat file format.
Define primary key and foreign key.
Primary key: a type of data; Foreign key: a synonym for primary key.
Primary key: a field that can be null; Foreign key: a unique identifier within the same table.
Primary key: a reference to a foreign key; Foreign key: a unique identifier for a record.
Primary key: unique identifier for a record; Foreign key: links to a primary key in another table.
Explain the difference between a table and a view.
A table is always temporary, while a view is permanent.
A view stores data physically, while a table is just a query.
A table stores data physically, while a view is a virtual representation of data based on a query.
A table is a type of view that can be modified directly.
Write a basic SQL query to select all records from a table.
SELECT * FROM table_name;
FETCH * FROM table_name;
GET * FROM table_name;
SELECT ALL FROM table_name;
What is the purpose of the WHERE clause in SQL?
To sort records in ascending order.
To join multiple tables together.
To filter records based on specified conditions.
To create new records in the database.
What is a database schema?
A database schema is a type of database software.
A database schema is the organizational blueprint of a database that outlines how data is structured and related.
A database schema is a collection of user accounts.
A database schema is a programming language for databases.
What are the different types of database users?
End users, Database administrators, Application developers
Only database administrators
Only end users
Only application developers
What is the significance of user roles in a database?
User roles define the physical storage of data.
User roles determine the level of access and permissions for different users.
User roles are irrelevant in modern databases.
User roles are only for database administrators.
What is a two-tier architecture in DBMS?
A system where the client and server are on the same machine.
A system that separates the database and application logic into two layers.
A system that uses three different types of servers.
A system that combines data storage and application logic in one layer.
