This Quiz contains totally 30 Questions each carry 1 point for you.
- What is a Database?
A collection of unrelated data
A collection of interrelated data
A collection of software data
A collection of hardware data
Correct!
Wrong!
2. What is the primary function of a Database Management System (DBMS)?
To manage hardware resources
To manage software resources
To manage data and provide an interface for interaction
To manage network resources
Correct!
Wrong!
3. What type of DBMS is MySQL?
Relational DBMS
Hierarchical DBMS
Network DBMS
Object-oriented DBMS
Correct!
Wrong!
4. Which of the following is NOT a component of a DBMS?
Database engine
Query processor
Data storage
Network interface
Correct!
Wrong!
5. Which of the following is an advantage of using a DBMS?
Reduced data redundancy
Reduced data consistency
Increased data complexity
All of the above
Correct!
Wrong!
6. In the context of DBMS, what is data modeling?
The process of creating a data model for the data to be stored in a database
The process of moving data from one database to another
The process of removing data from a database
The process of updating data in a database
Correct!
Wrong!
7. What is the Entity-Relationship (ER) model primarily used for?
Data migration
Data modeling
Data deleting
Data updating
Correct!
Wrong!
8. In an ER diagram, what does a rectangle represent?
Relationship
Attribute
Entity
Constraint
Correct!
Wrong!
9. What is the primary goal of normalization in DBMS?
To reduce data redundancy and improve data integrity
To increase data redundancy and improve data security
To increase data complexity and reduce data consistency
None of the above
Correct!
Wrong!
10. Which normal form is concerned with removing transitive dependencies?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
Correct!
Wrong!
11. Which of these is NOT a type of DBMS?
Relational DBMS
Network DBMS
Sequential DBMS
Hierarchical DBMS
Correct!
Wrong!
12. Which component of a DBMS is responsible for the actual storing, retrieving, and updating of data?
DDL compiler
Query optimizer
Database engine
Data dictionary
Correct!
Wrong!
13. Which of the following is NOT an advantage of a DBMS?
Data isolation
Data inconsistency
Data security
Data integrity
Correct!
Wrong!
14. What does a diamond shape represent in an ER diagram?
Entity
Attribute
Relationship
Constraint
Correct!
Wrong!
15. What does 1NF demand in terms of the structure of the database?
No duplicate columns in a table
No multi-valued attributes
Both A and B
None of the above
Correct!
Wrong!
16. What does a derived attribute represent in an ER model?
An attribute that can be calculated from other attributes
An attribute that is referenced from another table
An attribute that is unique for each record in a table
An attribute that is optional in a record
Correct!
Wrong!
17. In a relational DBMS, what is a tuple?
A column in a table
A database schema
A row in a table
A relationship between tables
Correct!
Wrong!
18. In a hierarchical DBMS, data is organized into a __________.
Tree-like structure
Network structure
Table structure
Graph structure
Correct!
Wrong!
19. What is the purpose of the Data Manipulation Language (DML) component of a DBMS?
To define the database schema
To manipulate data in a database
To control access to the database
To create physical database storage structures
Correct!
Wrong!
20. What is a transitive dependency in a relational database?
When a non-key attribute depends on another non-key attribute
When a key attribute depends on a non-key attribute
When a non-key attribute depends on a key attribute
When a key attribute depends on another key attribute
Correct!
Wrong!
21.What is the function of the schema in a DBMS?
It is used to define data
It is used to retrieve data
It is used to delete data
It is used to store data
Correct!
Wrong!
22. In the context of DBMS, what is a transaction?
A single operation of data retrieval
A single operation of data deletion
A logical unit of work consisting of one or more related operations
A physical unit of work consisting of several unrelated operations
Correct!
Wrong!
23. Which type of DBMS uses classes, objects, inheritance etc. in its design?
Relational DBMS
Network DBMS
Hierarchical DBMS
Object-Oriented DBMS
Correct!
Wrong!
24. Which level of abstraction describes how the data is stored and processed in a DBMS?
Physical level
Logical level
View level
Schema level
Correct!
Wrong!
25. What does the '1' and 'N' symbolize in a one-to-many relationship in a DBMS?
One attribute to many tables
One entity to many entities
One record to many records
One database to many databases
Correct!
Wrong!
26. What is a composite attribute in an ER model?
An attribute that can be divided into other simple attributes
An attribute that is derived from other attributes
An attribute that forms the primary key
An attribute that can have multiple values
Correct!
Wrong!
27. In terms of DBMS, what does 'ACID' stand for?
Atomicity, Consistency, Isolation, Durability
Authenticity, Concurrency, Isolation, Durability
Atomicity, Consistency, Identification, Durability
Access, Consistency, Isolation, Durability
Correct!
Wrong!
28. Which normal form says that a table should have no repeating groups or arrays?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
Correct!
Wrong!
29. What is a 'view' in DBMS?
A table that contains all the data in a database
A virtual table based on the result-set of an SQL statement
A separate database linked to the main database
A method for inputting new data into the database
Correct!
Wrong!
30. What is a weak entity in an ER model?
An entity that cannot exist without another entity
An entity that can exist independently of other entities
An entity that has only one attribute
An entity that has no relationships with other entities
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
DBMS – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...