0
0
DBMS Theoryknowledge~10 mins

Data abstraction levels in DBMS Theory - Interactive Code Practice

Choose your learning style9 modes available
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

Complete the code to name the level of data abstraction that shows how data is stored physically.

DBMS Theory
The [1] level describes how data is stored on storage devices.
Drag options to blanks, or click blank then click option'
ALogical
BPhysical
CView
DConceptual
Attempts:
3 left
💡 Hint
Common Mistakes
Confusing physical level with logical or conceptual levels.
2fill in blank
medium

Complete the code to identify the data abstraction level that defines what data is stored and the relationships.

DBMS Theory
The [1] level defines the structure of the entire database for a community of users.
Drag options to blanks, or click blank then click option'
AConceptual
BPhysical
CView
DExternal
Attempts:
3 left
💡 Hint
Common Mistakes
Mixing conceptual level with physical or external levels.
3fill in blank
hard

Fix the error in naming the data abstraction level that shows only part of the database to users.

DBMS Theory
The [1] level provides a tailored view of the database for different users.
Drag options to blanks, or click blank then click option'
AView
BConceptual
CPhysical
DInternal
Attempts:
3 left
💡 Hint
Common Mistakes
Confusing view level with conceptual or physical levels.
4fill in blank
hard

Fill both blanks to complete the sentence about data abstraction levels.

DBMS Theory
The [1] level deals with the overall database structure, while the [2] level deals with user-specific data views.
Drag options to blanks, or click blank then click option'
AConceptual
BPhysical
CView
DInternal
Attempts:
3 left
💡 Hint
Common Mistakes
Swapping conceptual and view levels.
5fill in blank
hard

Fill all three blanks to complete the dictionary comprehension describing data abstraction levels.

DBMS Theory
levels = {{'{'}}[1]: '[2]', '[3]': 'Shows user-specific data views'{{'}}'}}
Drag options to blanks, or click blank then click option'
APhysical
BConceptual
CView
DInternal
Attempts:
3 left
💡 Hint
Common Mistakes
Confusing internal with physical or conceptual levels.