1 Flashcards
1 (30 cards)
What is the primary purpose of a database?
Organizing and structuring data
What does DBMS stand for?
Database Management System
What is NOT a function of a DBMS?
Designing operating systems
Which of the following is an example of an RDBMS?
Oracle
How is data stored in an RDBMS?
In tables (relations)
What are rows in a table called in an RDBMS?
Tuples
What are columns in a table called in an RDBMS?
Attributes
What is a primary key?
A unique identifier for rows in a table
What type of relationship connects two tables where each row in the first table corresponds to only one row in the second?
One-to-One
What relationship connects one row in a table to multiple rows in another table?
One-to-Many
What is an ER diagram?
A representation of data relationships
Which is NOT a step in converting an ER diagram to tables?
Encrypting all columns
What is a foreign key?
A column that references a primary key in another table
What is the purpose of normalization?
To minimize redundancy and dependency
What is a composite key?
A primary key consisting of multiple columns
Which relationship type allows each record in a table to relate to multiple records in another, and vice versa?
Many-to-Many
What is the main function of data definition in DBMS?
Creating and modifying the structure of data
What is data retrieval?
Fetching stored data for use
Which of these is NOT a type of DBMS?
Linear DBMS
What is concurrency control?
Ensuring multiple users can access data consistently
What does an RDBMS use to uniquely identify a row?
Primary Key
What is a data dictionary?
Metadata about database structure and elements
Which of these is an example of DBMS software?
Oracle
What does ‘tuple’ refer to in a database?
A row in a table
