Database Management System Online Test 2 – Randomized MCQs

With each visit of this Database Management System online Quiz / Practice Test, the list of MCQs / Objective Questions presented will be different, offering you a diverse set of practice opportunities. This variability encourages you to practice extensively, refining the accuracy of your answers and your overall grasp of the content. By utilizing this resource, you can hone your skills and become more adept at managing time constraints during actual exams.

Test Instructions
Question type	Randomized MCQs.Changes every time you visit the test
Total Number of Questions	30
Time Limit	20 Minutes
Points	1 Point for each Question

Remaining Time: 0 MINUTES

Test Summary

0 of 30 questions completed

Questions:

Information

You have already completed the test before. Hence you can not start it again.

Test is loading...

Results

0 of 30 questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 points, (0)

Answered
Review

Question 1 of 30

Q-1.Consider the entity relationship which consists of two entity sets, customer and loan, related through a binary relationship set borrower. A directed line(->) from the relationship set borrower to the entity set loan specified that borrower is either a_________ or _______ relationship.

One to one, many to one

many to many, one to many

Many to many, one to one

One to One, Many to Many

Your Answer:Correct

Your Answer:Incorrect

Question 2 of 30

Q-2.An Entity is a________________

Relationship model

Relational Model

Object having same Value

Object in the real world distinguishable from all other objects

Your Answer:Correct

Your Answer:Incorrect

Question 3 of 30

Q-3.Double Rectangle represent_____

Derived attributes

Multi-valued Attributes

Total participation of an entity in a relationship set

Weak entity sets

Your Answer:Correct

Your Answer:Incorrect

Question 4 of 30

Q-4.Which of the following symbol can be used for Assignment operation in the relational algebra expression?

←

Your Answer:Correct

Your Answer:Incorrect

Question 5 of 30

Q-5.An expression {<X1,X2,….Xn > | P(X1,X2,….Xn)} , Where X1,X2,….Xn represent Domain variable. P represents a formula composed of atoms. This expression is of the of the following?

Tuple relational calculus

Relational Algebra

Domain relational calculus

None of the above

Your Answer:Correct

Your Answer:Incorrect

Question 6 of 30

Q-6.Which of the following are the fundamental operations in the Relational Algebra?

Select and Project

Project and Cartesian product

Union and set Difference

All of the Above

Your Answer:Correct

Your Answer:Incorrect

Question 7 of 30

Q-7.Which of the following Statements stands true for Right outer-join?

The left outer join takes all tuples in the left relation that did not match with any tuple in the right relation, pads the tuples with null values for all other attributes from the right relation, and add them to the result of the natural join.
It pads tuples from the right relation that did not match any from the left relation with nulls and adds them to the result of the natural join.
it pads tuples from the left relation that did not match any from the right relation, as well as tuples from the right relation that did not match any from the left relation, and adding them to the result of join
It takes all tuples in the right relation that did not match with any tuple in the right relation, pads the tuples with null values for all other attributes from the right relation, and add them to the result of the natural join.

Only 1

Only 2

1 and 2

only 4

Your Answer:Correct

Your Answer:Incorrect

Question 8 of 30

Q-8.Which one of the following allows us to uniquely identify the entity in the entity set?

Domain

Tuple

Row

Key

Your Answer:Correct

Your Answer:Incorrect

Question 9 of 30

Q-9.Diamond Represents______

Relationship sets

Attributes

Derived attributes

Multi-valued attributes

Your Answer:Correct

Your Answer:Incorrect

Question 10 of 30

Q-10.For a Binary relationship set R between entity sets A and B, the ________ express the number of entities to which another entity can be associated.

Cardinality ratio.

Participation constraints

Limited Ratio

Degree ratio

Your Answer:Correct

Your Answer:Incorrect

Question 11 of 30

Q-11.A Database schema, along with primary key and foreign key dependencies, can be depicted pictorially by _________

Database Diagram

ER Diagram

Schema Diagrams

Relation Schema

Your Answer:Correct

Your Answer:Incorrect

Question 12 of 30

Q-12.The mathematical terms relation and tuples are referred to as?

Table and Domain

Table and Key

Table and Row

Table and Column

Your Answer:Correct

Your Answer:Incorrect

Question 13 of 30

Q-13.An ER diagram can express the overall __________of a database graphically

View Structure

Logical Structure

Model Structure

Architectural structure

Your Answer:Correct

Your Answer:Incorrect

Question 14 of 30

Q-14.The tuple relational calculus is a ___________Query Language.

Procedural

Non-procedural

Object oriented

Dynamic

Your Answer:Correct

Your Answer:Incorrect

Question 15 of 30

Q-15.For a binary relationship set R between entity sets A and B, the Mapping Cardinality is MANY to MANY if

An Entity A is associated with any number (zero or more) of entities in B, An entity in B however, can be associated with at most one entity in A.

An entity in A is associated with at most one entity in B,and an entity in B is associated with at most one entity in A

An Entity A is associated with at most one entities in B,An entity in B however, can be associated with any number zero or more of entities in A

An entity in A is associated with any number zero or more of entities in B, and an entity in B is associated with any number zero or more of entities in A.

Your Answer:Correct

Your Answer:Incorrect

Question 16 of 30

Q-16.The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.

Parent table, Child table

Child table, Parent table

Child table, Referenced table

Both B and C

Your Answer:Correct

Your Answer:Incorrect

Question 17 of 30

Q-17.In a Entity sets Customer and Loan, an Attribute name consisting of first-name ,middle-name, and last-name. An Attribute name is _______

Simple Attribute

Composite Attribute

Single-Valued Attributes

Multi-valued Attributes

Your Answer:Correct

Your Answer:Incorrect

Question 18 of 30

Q-18.__________is a set of entities of same type that share the same properties or attributes.

Attributes set

Relationship Set

Entity Set

Property set

Your Answer:Correct

Your Answer:Incorrect

Question 19 of 30

Q-19.For each attribute in the table, there is set of permitted values, called the _____of that Attribute.

Tuple

Domain

Column

Row

Your Answer:Correct

Your Answer:Incorrect

Question 20 of 30

Q-20.Which of the following operation allows us to find the tuples that are in one relation but are not in another relation?

Set difference

Union

Cartesian product

Set intersection

Your Answer:Correct

Your Answer:Incorrect

Question 21 of 30

Q-21.Which of the following is the Binary Operations?

Set difference, Union, Project

Rename, union, Set difference

Cartesian product, Set difference and project

Cartesian product, union, set difference

Your Answer:Correct

Your Answer:Incorrect

Question 22 of 30

Q-22.The Relationship sets that involve two entity sets in known as___

Unary Relationship set

Binary Relationship set

Ternary Relationship set

None of the above

Your Answer:Correct

Your Answer:Incorrect

Question 23 of 30

Q-23.______ is the restrictions imposed to maintain the data integrity of the database

Mapping Cardinalities

Cardinality ratio

Participation Constraints

All of the Above

Your Answer:Correct

Your Answer:Incorrect

Question 24 of 30

Q-24.An entity is represented by set of ___________

Attributes

Relationship

Model

None of the above

Your Answer:Correct

Your Answer:Incorrect

Question 25 of 30

Q-25.The _______ should be chosen such that its attributes are never, or very rarely changed.

Primary key

Super Key

Candidate Key

Foreign Key

Your Answer:Correct

Your Answer:Incorrect

Question 26 of 30

Q-26.For a binary relationship set R between entity sets A and B,the Mapping Cardinality is MANY to ONE if

An Entity A is associated with any number (zero or more)of entities in B,An entity in B however, can be associated with at most one entity in A.

An entity in A is associated with at most one entity in B,and an entity in B is associated with at most one entity in A

An Entity A is associated with at most one entities in B, An entity in B however, can be associated with any number zero or more of entities in A

An entity in A is associated with any number zero or more of entities in B,and an entity in B is associated with any number zero or more of entities in A.

Your Answer:Correct

Your Answer:Incorrect

Question 27 of 30

Q-27.The select operation selects tuples that satisfy a given predicate. We use the lowercase______ to denote selection

Greek letter rho (ρ)

Greek letter Pi (π)

Greek letter sigma (σ)

Greek letter sigma (ρ)

Your Answer:Correct

Your Answer:Incorrect

Question 28 of 30

Q-28.Which of the following take a collection of values and return a single value as a result?

Join Operation

Generalized Projection

Aggregate Function

All of the above

Your Answer:Correct

Your Answer:Incorrect

Question 29 of 30

Q-29.For a binary relationship set R between entity sets A and B, the Mapping Cardinality is ONE TO ONE if

An Entity A is associated with any number (zero or more)of entities in B, An entity in B however, can be associated with at most one entity in A.

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A

an Entity A is associated with at most one entity in B, An entity in B however, can be associated with any number zero or more of entities in A

. An entity in A is associated with any number zero or more of entities in B, and an entity in B is associated with any number zero or more of entities in A.

Your Answer:Correct

Your Answer:Incorrect

Question 30 of 30

Q-30.Which of the following statements stands true? I.A Relational database consists of collection of AttributesII.A Relational Database consists of collections of TablesIII.A relational Database consists of collections of ColumnsIV.A relational Database consists of collections of Rows

I and II

I and III

II only

IV only

Your Answer:Correct

Your Answer:Incorrect

Practice More Online Tests

Database Management System – Locking Protocol (2PL) Online Test

Database Management System – Transaction,Concurrency Control,Recovery,Serializability Online Test

Database Management System – Normalization (1NF,2NF,3NF,BCNF) Online Test

Database Management System – SQL Online Test

Database Management System – ER Model (Entity Relationship) Online Test

Database Management System – Relational Algebra Online Test

Database Management System – Functional Dependency Online Test

Database Management System – B tree,Indexing,hashing Online Test

Database Management System Online Test 1 – Randomized MCQs

Database Management System Online Test 2 – Randomized MCQs

Database Management System Online Test 2 – Randomized MCQs

Test Summary

Information

Results

Practice More Online Tests

You may be Interested In

Database Management System Online Test 1 – Randomized MCQs

Operating System Online Test 1 – Randomized MCQs

📢 Share This Post: