This Quiz contains totally 25 Questions each carry 1 point for you.
1.What does DBMS stand for?
Data Base Management System
Data Base Manipulation System
Data Base Monitoring System
Data Base Memory System
Correct!
Wrong!
2.Which of the following is a type of DBMS?
Hierarchical
Rational
Pyramid
Grid
Correct!
Wrong!
3.What is the architectural model of DBMS where data is viewed at the highest level of abstraction?
1-tier
2-tier
3-tier
4-tier
Correct!
Wrong!
4.Which schema level in a DBMS represents the logical view of the entire database?
Physical Schema
Logical Schema
View Schema
Conceptual Schema
Correct!
Wrong!
5.In a DBMS, a user's view of the data is known as a(n) ____.
Internal view
External view
Logical view
Physical view
Correct!
Wrong!
6.Data abstraction in DBMS refers to which of the following?
Hiding physical aspects of the database
Enhancing data visibility
Exposing system internals to users
Optimizing storage
Correct!
Wrong!
7.What is an instance in a DBMS?
Collection of data stored in the database at a particular moment
Structural definition of the database
Collection of database queries
Group of users accessing the database
Correct!
Wrong!
8.A schema in DBMS is _____.
The physical representation of the database
The structural definition of the database
The current state of the database
The number of users accessing the database
Correct!
Wrong!
9.Which of the following is NOT a DBMS language?
DDL
DML
TCL
XPL
Correct!
Wrong!
10.The language used for defining database schema in a DBMS is:
Data Definition Language (DDL)
Data Manipulation Language (DML)
Query Language (QL)
Data Control Language (DCL)
Correct!
Wrong!
11.Which of the following languages is used to access or manipulate data in a DBMS?
Data Definition Language (DDL)
Data Manipulation Language (DML)
Query Language (QL)
Data Control Language (DCL)
Correct!
Wrong!
12.DBMS stands for relational database management systems. True or False?
True
False
Correct!
Wrong!
13.What is the main difference between DBMS and RDBMS?
DBMS supports multi-user environment, while RDBMS doesn't
DBMS stands for 'Relational Database Management System', while RDBMS stands for 'Database Management System'
DBMS does not support the relationship between tables, while RDBMS does
DBMS stores data in tables, while RDBMS stores data in objects
Correct!
Wrong!
14.Which of the following is an advantage of using a DBMS?
Data redundancy and inconsistency
Difficult access to data
Data isolation
Data security
Correct!
Wrong!
15.Which of the following is NOT an advantage of using a DBMS?
Data independence
Data consistency
Concurrent access
Data redundancy
Correct!
Wrong!
16.Which type of DBMS architecture would you use for small, single-user applications?
1-tier
2-tier
3-tier
4-tier
Correct!
Wrong!
17.Which level of data abstraction describes how data is stored in a DBMS?
Physical level
Logical level
View level
Abstract level
Correct!
Wrong!
18.Which of the following is NOT a DBMS type?
Relational
Network
Hierarchical
Flat
Correct!
Wrong!
19.Which level of schema in a DBMS provides details of data storage and is hidden from the users?
Physical schema
Logical schema
View schema
Conceptual schema
Correct!
Wrong!
20.In DBMS, a 'view' is:
A snapshot of data at a particular instance
The physical representation of the database
The logical representation of a subset of the database
The structural definition of the database
Correct!
Wrong!
21.What does 'concurrency' in a DBMS mean?
Data is stored in a hierarchical manner
Multiple operations occur at the same time
Data is distributed across different locations
Data is organized in a relational model
Correct!
Wrong!
22.Which of the following is NOT a component of a DBMS?
Database Engine
Query Processor
Data Dictionary
Data Redundancy
Correct!
Wrong!
23.The process of converting a weak entity set into a strong entity set in DBMS is known as:
Normalization
Generalization
Specialization
Aggregation
Correct!
Wrong!
24.Which DBMS language includes commands such as GRANT and REVOKE?
Data Definition Language (DDL)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Data Control Language (DCL)
Correct!
Wrong!
25.Which of the following is NOT a function of a DBMS?
Data storage
Data manipulation
Data redundancy
Data security
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
DBMS Introduction -Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...