Databases: Pre-Unit Knowledge Check
Authored by chris jackman
Computers
12th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
33 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main purpose of a database?
To store, manipulate, and retrieve data
To manage operating systems
To display multimedia
To design web pages
Answer explanation
The main purpose of a database is to store, manipulate, and retrieve data efficiently. This functionality is essential for managing large amounts of information, making the first choice the correct answer.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a relational database?
A type of database that stores data in non-relational tables
A type of database where data is stored in interconnected tables
A database only used for social networks
A system where data is stored as one long file
Answer explanation
A relational database organizes data in interconnected tables, allowing for efficient data retrieval and management. This distinguishes it from non-relational databases, which do not use this table-based structure.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT an example of a relational database management system (RDBMS)?
Microsoft Access
Oracle Database
SQL Server
Microsoft Excel
Answer explanation
Microsoft Excel is a spreadsheet application, not a relational database management system (RDBMS). In contrast, Microsoft Access, Oracle Database, and SQL Server are all examples of RDBMS that manage data in structured formats.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of normalisation in a database?
To reduce data redundancy and improve data integrity
To increase data redundancy for faster access
To allow multiple users to access the database simultaneously
To enhance the graphical interface of the database
Answer explanation
The purpose of normalization in a database is to reduce data redundancy and improve data integrity. This process organizes data efficiently, ensuring that each piece of information is stored only once, minimizing duplication.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a benefit of using a relational database?
A. Increased data redundancy
B. Easier management of relationships between data sets
C. Limited scalability
D. Data is stored randomly
Answer explanation
B is correct because relational databases are designed to manage relationships between data sets efficiently, allowing for easier data retrieval and organization compared to other database types.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a primary key in a database table?
A. A unique identifier for each record
B. A key used to encrypt data
C. The main menu key in a database system
D. A key that defines foreign relationships
Answer explanation
A primary key is a unique identifier for each record in a database table, ensuring that no two records can have the same key value. This is essential for maintaining data integrity and enabling efficient data retrieval.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In a relational database, what does an "entity" refer to?
A. A row of data
B. A column in a table
C. A real-world object or concept represented by data
D. A type of relationship between data sets
Answer explanation
In a relational database, an 'entity' refers to a real-world object or concept represented by data, making option C the correct choice. Options A and B refer to data structure components, while D describes relationships, not entities.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
