This Quiz contains totally 40 Questions each carry 1 point for you.
1.What is a Relational Model in DBMS?
A data model where data is stored in tables
A data model where data is stored in graphs
A data model where data is stored in trees
None of the above
Correct!
Wrong!
2.What does DBMS Relational Algebra mainly deal with?
Equations
Functions
Operations on relations
Derivatives
Correct!
Wrong!
3.The Relational Calculus in DBMS is _____________.
Procedural
Non-procedural
Both procedural and non-procedural
None of the above
Correct!
Wrong!
4.What is the primary difference between a View and a Table in DBMS?
Views are updatable, but Tables are not
Tables are physical, but Views are virtual
There is no difference between them
Both a and b
Correct!
Wrong!
5.What is a Super Key in DBMS?
A key that can uniquely identify any row in the table
A key that can uniquely identify multiple rows in the table
A key that can be duplicated within the table
None of the above
Correct!
Wrong!
6.What is the main function of a Foreign Key in DBMS?
To prevent data duplication
To enforce data integrity
To speed up data retrieval
All of the above
Correct!
Wrong!
7.Which of these is not a type of DBMS Key?
Candidate Key
Super Key
Ghost Key
Composite Key
Correct!
Wrong!
8.Domain constraints in DBMS are used to:
Ensure uniqueness of data
Ensure data integrity
Limit the kind of values that can be stored in a column
Increase the speed of data retrieval
Correct!
Wrong!
9.Mapping constraints in DBMS are used to:
Define the relationship between tables
Define the relationship between data models
Define the relationship between keys
None of the above
Correct!
Wrong!
10.What does cardinality mean in DBMS?
It is the number of rows in a table
It is the number of columns in a table
It defines the maximum number of times an instance in one entity can relate to instances in another entity
It defines the number of keys in a table
Correct!
Wrong!
11.A trivial functional dependency is one where:
The dependency between attributes is complex
The dependent attribute is a subset of the determinant set
The determinant and the dependent are the same
None of the above
Correct!
Wrong!
12.Which type of dependency in DBMS involves a condition where changing a non-key column, might lead to changes in a column which is not a primary key?
Trivial functional dependency
Non-trivial functional dependency
Multivalued dependency
Transitive dependency
Correct!
Wrong!
13.The first normal form (1NF) in DBMS requires that:
Each table cell should contain a unique value
Each table cell should contain a single value
Each table cell should contain multiple values
None of the above
Correct!
Wrong!
14.What is the main purpose of the second normal form (2NF)?
To remove partial dependencies
To remove transitive dependencies
To remove multivalued dependencies
None of the above
Correct!
Wrong!
15.What is the key requirement for a database to be in Third Normal Form (3NF)?
It should be in 2NF and no transitive dependencies
It should be in 1NF and no partial dependencies
It should be in 2NF and no multivalued dependencies
None of the above
Correct!
Wrong!
16.Boyce–Codd Normal Form (BCNF) is a stricter version of which normal form?
First Normal Form
Second Normal Form
Third Normal Form
Fourth Normal Form
Correct!
Wrong!
17.Denormalization in DBMS is primarily used to:
Reduce redundancy
Improve database organization
Improve performance
Maintain data integrity
Correct!
Wrong!
18.Which of the following statements is true about normalization and denormalization in DBMS?
Normalization increases redundancy while denormalization reduces it
Denormalization increases redundancy while normalization reduces it
Both increase redundancy
Both reduce redundancy
Correct!
Wrong!
19.In the process of decomposition in DBMS:
A relation is split into two or more relations
Two or more relations are combined into one
A relation is duplicated
None of the above
Correct!
Wrong!
20.Which of these is not a type of Data Model in DBMS?
Hierarchical Model
Network Model
Solar Model
Relational Model
Correct!
Wrong!
21.The primary function of an Alternate Key in DBMS is:
To be used when the primary key is not available
To act as a backup to the primary key
To be used in place of the primary key when the primary key fails
To provide an alternative way to retrieve data
Correct!
Wrong!
22.A Composite Key in DBMS is:
A key that is composed of two or more columns
A key that is composed of three or more columns
A key that is composed of four or more columns
None of the above
Correct!
Wrong!
23.Non-trivial functional dependency refers to a situation where:
The dependent attribute is a subset of the determinant set
The dependent attribute is not a subset of the determinant set
The determinant and the dependent are the same
None of the above
Correct!
Wrong!
24.Which type of dependency in DBMS involves a condition where a set of attributes depends on multiple sets of attributes, each of which is not a proper subset of other sets?
Trivial functional dependency
Non-trivial functional dependency
Multivalued dependency
Transitive dependency
Correct!
Wrong!
25.The main purpose of the Third Normal Form (3NF) is to:
Remove all types of transitive dependencies
Remove all types of partial dependencies
Remove all types of functional dependencies
None of the above
Correct!
Wrong!
26.In Boyce-Codd Normal Form (BCNF), a relation is in BCNF if:
It is in 1NF
It is in 2NF
For every one of its dependencies X → Y, X is a superkey
It is in 3NF
Correct!
Wrong!
27.What is the key benefit of denormalization in DBMS?
It increases the data redundancy
It improves the performance of read-intensive applications
It reduces the complexity of the database
It enhances data consistency
Correct!
Wrong!
28.What is the process of Decomposition in DBMS?
It is the process of joining two or more tables
It is the process of dividing a table into smaller tables
It is the process of updating a table
It is the process of deleting a table
Correct!
Wrong!
29.A Candidate Key can be defined as:
A key that can be a primary key
A key that cannot be a primary key
A key that is a foreign key
A key that is a composite key
Correct!
Wrong!
30.What does the term "Cardinality" mean in the context of DBMS?
It refers to the uniqueness of data values in a column
It refers to the number of rows in a table
It refers to the number of tables in a database
It refers to the number of columns in a table
Correct!
Wrong!
31.What is the main purpose of a Foreign Key in DBMS?
To maintain data integrity and enable a link between two tables
To enhance the performance of data retrieval
To ensure the uniqueness of data values
To store multiple values in a single field
Correct!
Wrong!
32.Domain constraints in DBMS are used to:
Limit the type of values that can be stored in a field
Increase the speed of data retrieval
Maintain data consistency
Ensure the security of the data
Correct!
Wrong!
33.Which of the following is not a type of functional dependency in DBMS?
Trivial functional dependency
Non-trivial functional dependency
Multivalued dependency
Circular dependency
Correct!
Wrong!
34.In the context of DBMS, what is Normalization?
The process of organizing data to minimize redundancy and anomalies
The process of creating backups of data
The process of encrypting data for security
The process of deleting unnecessary data
Correct!
Wrong!
35.Which of the following is not a type of key in DBMS?
Primary key
Candidate key
Subordinate key
Foreign key
Correct!
Wrong!
36.Which of the following is not a type of Normal Form in DBMS?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Zeroth Normal Form (0NF)
Correct!
Wrong!
37.A relational model of data is based on:
The concept of tables
The concept of hierarchical structure
The concept of a network structure
The concept of objects and their relationships
Correct!
Wrong!
38.In the context of DBMS, a 'view' can best be described as:
A physical structure holding the actual data
A virtual table based on the result-set of an SQL statement
A way to visualize the data in a database
A graphical representation of a database
Correct!
Wrong!
39.A Super Key is a:
Subset of a primary key
Set of attributes that uniquely identify a tuple
Set of attributes that identify a tuple but contain extraneous attributes
Key that can be used to identify any entity in a database
Correct!
Wrong!
40.Mapping constraints in DBMS are used to:
Limit the type of values that can be stored in a field
Determine the relationship between tables
Maintain data consistency
Ensure the security of the data
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
DBMS Relational Algebra and Calculus Basics – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...