
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
40 questions
TIC Tema 5. Producción multimedia
Quiz
•
4th Grade
42 questions
Latihan Soal ASAS Kelas 3 #1
Quiz
•
1st - 5th Grade
40 questions
PAS AIJ XI
Quiz
•
1st Grade - University
40 questions
COMPUTER NETWORKS-YEAR 5
Quiz
•
1st - 5th Grade
38 questions
Komputer, system operacyjny, programy
Quiz
•
4th Grade
40 questions
Đề cương ôn tập học kì 2 - Khối 3
Quiz
•
1st - 5th Grade
45 questions
GCSE Python Legends
Quiz
•
1st - 12th Grade
40 questions
QUIZZ KJD - PERAWATAN, PERMASALAHAN DAN PERBAIKAN PC
Quiz
•
KG - Professional Dev...
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
