What does ACID stand for?

Atomicity, Consistency, Isolation, Durability

collection of data that describes a section of the real world

Data independence means that...

changes on a physical memory level do not influence the logical level

Which of the sequences correctly represents the 3-tier database structure (from top to bottom)?

View - Logical level - Physical level

A database system is…

a combination term for a database, DBMS and related applications

studbud

Database recap

9 termsStudBud Administration36 plays

For our amazing TH Aschaffenburg

Flashcards9 cardsFPractice quizPHost liveL

Questions 9

Answers

1
Which component describes conceptually the structure of the entire database and the conditions that apply to the data?
Conceptual schema
External schema
Database instance
Internal schema
2
What does ACID stand for?
Accuracy, Clarity, Integrity, Durability
Adaptability, Concurrency, Isolation, Dynamicity
Availability, Consistency, Integrity, Dependability
Atomicity, Consistency, Isolation, Durability
3
A database is a...
collection of data that describes a section of the real world
program that automatically generates real-world data
random collection of unrelated data
collection of data that describes an entire real world
4
Data independence means that...
a database instance may contain different data for different users
changes to the logical structure have no influence on the applications
changes on a physical memory level do not influence the logical level
no data in a database may be directly related
5
Which of the following is a common problem that databases help to solve?
Redundancy and inconsistency
Instant internet access for all users
Automatic software development
Unlimited data storage capacity
6
Which of the following is NOT a way of upholding data integrity?
Redundant storage
Access control mechanisms
Checking the consistency of a database status for all users
Integrity conditions
7
Arrange the following terms in order from more general to narrower:
Knowledge - Data - Information
Data - Information - Knowledge
Data - Knowledge - Information
Information - Data - Knowledge
8
Which of the sequences correctly represents the 3-tier database structure (from top to bottom)?
Logical level - Physical level - View
View - Logical level - Physical level
View - Physical level - Logical level
Logical level - Physical level - View
9
A database system is…
a synonym for the term database management system
a combination term for a database, DBMS and related applications
a collection of related databases
a method of storing data using databases

Database recap Flashcards | StudBud