
Alsager - A2 - 1.3.2 - Databases
Quiz
•
Computers
•
4th Grade
•
Practice Problem
•
Medium
Richard Steed
Used 3+ times
FREE Resource
Enhance your content in a minute
42 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not a component of a relational database system?
Primary Keys
Normalisation
Referential Integrity
Record locking
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does ACID stand for in the context of transaction processing?
Atomicity, Consistency, Isolation, Durability
Association, Condition, Isolation, Documentation
Atomicity, Consistency, Integration, Durability
Association, Consistency, Isolation, Durability
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of indexing in a database?
To lock records during a transaction
To manage database redundancy
To improve the speed of data retrieval
To establish referential integrity
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a method of ensuring that data remains consistent after transactions?
Normalisation
Indexing
Entity relationship modelling
ACID properties
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main focus of normalisation in database design?
Increasing data redundancy
Improving transaction processing
Reducing data redundancy and improving data integrity
Locking records to prevent concurrent access
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is an entity in the context of a relational database?
A) A single file in the database
B) A unique identifier for each record
C) An item of interest about which information is stored
D) The attribute which links two tables together
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does a flat file database consist of?
A) Multiple files with complex relationships
B) A single file based around a single entity and its attributes
C) Two or more linked tables
D) A unique identifier for each record
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
41 questions
ee092101
Quiz
•
4th Grade
39 questions
Term3 - Grade 4 - Revision
Quiz
•
4th Grade
40 questions
Scratch Coding Assessment
Quiz
•
3rd - 6th Grade
47 questions
Ulangkaji ASK T2 Bab 2 Algoritma
Quiz
•
1st - 12th Grade
43 questions
Ôn Táºp Kiểm Tra KHTN 7
Quiz
•
1st Grade - University
40 questions
Microsoft Powerpoint
Quiz
•
4th Grade
40 questions
PENGAYAAN TKJ 1
Quiz
•
1st - 10th Grade
40 questions
UF0321: Aplicaciones Informáticas de Hojas de Cálculo
Quiz
•
1st - 8th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
