WorksheetsExploring Database Systems
Total questions: 10
Worksheet time: 5mins
What is the primary purpose of a database system?
To provide a user interface for web applications.
To generate random data for testing purposes.
To create complex algorithms for data analysis.
To store, manage, and retrieve data efficiently.
Explain the concept of views in a database.
A view is a virtual table in a database that presents data from one or more tables based on a SELECT query.
A view is a backup of the database that can be restored later.
A view is a type of database index that speeds up queries.
A view is a physical table that stores data permanently.
What are the different types of data models?
CSV
XML
Flat File
Hierarchical, Network, Relational, Object-Oriented, Document, Key-Value, Graph
Describe the architecture of a database system.
Database systems are solely based on cloud technology.
The architecture of a database system includes the database engine, database schema, and database management system (DBMS).
The architecture includes only the user interface and storage devices.
Database systems only consist of hardware components.
What are the key features of relational databases?
Hierarchical structure
Flat files
NoSQL support
Key features of relational databases include tables, relationships, data integrity, normalization, ACID properties, and SQL support.
Define the relational model and its components.
Tables and views only
Attributes and indexes only
The relational model consists of tables (relations), rows (tuples), columns (attributes), and keys (primary and foreign keys).
Rows and columns without keys
What are keys in a relational database?
Keys are only used for indexing data.
Keys are used to store large amounts of data.
Keys are random values assigned to records.
Keys in a relational database are attributes that uniquely identify records, including primary keys and foreign keys.
Explain the basics of relational algebra.
Relational algebra is a formal system for manipulating relations in a database using operations like selection, projection, union, set difference, Cartesian product, and rename.
Relational algebra is used exclusively for data visualization techniques.
Relational algebra is a programming language for web development.
Relational algebra focuses on the physical storage of data in databases.
What are the fundamental components of SQL?
The fundamental components of SQL are DQL, DDL, DML, and DCL.
DQL, DDL, DML, and DFL
DQL, DDL, DML, and DCLT
DQL, DDL, DML, and DTL
What is the difference between embedded SQL and dynamic SQL?
Embedded SQL allows for runtime modifications, while dynamic SQL does not.
Dynamic SQL is static and compiled, while embedded SQL is constructed at runtime.
Embedded SQL is executed at runtime, while dynamic SQL is compiled beforehand.
Embedded SQL is static and compiled, while dynamic SQL is constructed and executed at runtime.
