2020/12/5 Midterm Exam 05/12/2020: Attempt review

Dashboard / My courses / ‫ ﻛﻠﯿﺔ اﻟﻤﻠﻚ اﻟﺤﺴﯿﻦ ﻟﻌﻠﻮم اﻟﺤﻮﺳﺒـﺔ‬/ ‫ ﻋﻠﻢ اﻟﺤﺎﺳﻮب‬/ 2020 - 1 / Database Systems - All / General / Midterm Exam 05/12/2020

Started on Saturday, 5 December 2020, 3:00 PM

State Finished
Completed on Saturday, 5 December 2020, 3:58 PM
Time taken 58 mins 39 secs
Grade 21.50 out of 30.00 (72%)

Question 1 Logical data independence is described as:

Complete

Mark 1.00 out of

1.00

Select one:
a. The capacity to change the internal schema without having to change the conceptual schema

b. The capacity to change the internal data model without having to change the implementation data model

c. None

d. The capacity to change the conceptual schema without having to change external schemas or application program

The correct answer is: The capacity to change the conceptual schema without having to change external schemas or application
program

Question 2 Which of the following database users is as an actor behind the scene type of user:
Complete

Mark 1.00 out of

1.00

Select one:
a. End user

b. Database administrator

c. DBMS designer

d. Database designer

The correct answer is: DBMS designer

Question 3  It is difficult to use DBMS in complex genome applications because of:
Complete

Mark 1.00 out of

1.00

Select one:
a. Limited budget

b. Limited storage capacity

c. No multiple-user access to data

d. Modeling limitations

The correct answer is: Modeling limitations

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 1/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question 4  Which of the following diagrams is wrong

Complete

Mark 1.00 out of

1.00

Select one:
a. Figure (b)

b. Figure (a)

c. Figure (c)

d. None

The correct answer is: Figure (c)

Question 5  A Conceptual schema for the database uses a

Complete

Mark 1.00 out of

1.00

Select one:
a. Implementation data model

b. Physical data model

c. High-level conceptual data model

d. Representation data model

The correct answer is: High-level conceptual data model

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 2/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question 6 Consider the following ER diagram and answer the following questions:
Complete

Mark 1.00 out of

1.00

The equivalent (min, max) notation for this relationship is (Starting from the S side):

Select one:
a. (0,N) and (1,1)

b.  (1,1) and (0,N)

c. (1,N) and (0,1)

d. (0,1) and (1, N)

The correct answer is: (0,1) and (1, N)

Question 7  -------------is designed, built, and populated with data for a specific purpose.
Complete

Mark 0.00 out of

1.00

Select one:
a. Oracle

b. Database

c. DBMS

d. Database and DBMS

The correct answer is: Database

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 3/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question 8 Consider the following ER diagram to answer the following question:

Complete

Mark 0.00 out of

0.50

When mapping the above ER diagram into relational model, then the Degree of Entity A is:

Answer: 3

The correct answer is: 4

Question 9 Consider the following ER diagram to answer the following question:

Complete

Mark 0.50 out of

0.50

When mapping the above ER diagram into relational model, then the number of Foreign Keys is:

Answer: 3

The correct answer is: 3

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 4/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question  Consider the following diagram and answer the following question
10 What is the number of relations needed to represent the below ER diagram?
Complete

Mark 1.00 out of

1.00

Answer: 3

The correct answer is: 3

Question Specialization _______ has the constraint that every subclass participates as a subclass in only one class / subclass
11 relationship, resulting in a tree structure.
Complete

Mark 1.00 out of

1.00

Select one:
a. Hierarchy

b. Lattice

c. Union

d. Shared Class

The correct answer is: Hierarchy

Question Consider the following relationship:

12
Complete

Mark 0.00 out of

1.00

Which of the following statement is true?

Select one:
a. Each Dependent belongs to at most one Employee.

b. Each Dependent belongs to exactly one Employee.

c. Each Dependent belongs to at least one Employee.

d. None

The correct answer is: Each Dependent belongs to exactly one Employee.

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 5/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question  Which of the following architecture is the best for online shops applications?
13
Complete

Mark 1.00 out of

1.00

Select one:
a. DB server

b. Two-tier client server architecture

c. Centralized DBMS

d. Three-tier client-server architecture

The correct answer is: Three-tier client-server architecture

Question Consider the following ER diagram to answer the following question:

14
Complete

Mark 0.50 out of

0.50

When mapping the above ER diagram into relational model, then the number of produced columns in relations
is:

Answer: 9

The correct answer is: 9

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 6/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question Consider the following relationship:

15
Complete

Mark 1.00 out of

1.00

The participation constraints of the following ER diagram is:

Select one:
a. Total-to-Total

b. Many-to-One

c. One-to-Many

d. Partial-to-Partial

The correct answer is: Total-to-Total

Question Consider the following ER diagram to answer the following question:

16
Complete

Mark 0.50 out of

0.50

When mapping the above ER diagram into relational model, then the number of produced relations is:

Answer: 3

The correct answer is: 3

Question Assume a person is buying a product online. During the process of paying the bill the connection was
17 interrupted. Which of the following DBMS advantages is useful in this case?
Complete

Mark 1.00 out of

1.00

Select one:
a. Data Integrity

b. Data Isolation

c. Atomicity

d. Concurrency access
https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 7/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

The correct answer is: Atomicity

Question  _________ software ensures that several users trying to update the same data can do in controlled manner.
18
Complete

Mark 1.00 out of

1.00

Select one:
a. view control

b. access control

c. concurrency control

d. redundancy control

The correct answer is: concurrency control

Question   --------------leads to data inconsistency.

19
Complete

Mark 0.00 out of

1.00

Select one:
a. Data integrity

b. Data dictionary

c. Database

d. Data redundancy

The correct answer is: Data redundancy

Question Consider the following diagram and answer the following question
20 What is the correct attribute set for one of the relations that represent the ER model?
Complete

Mark 1.00 out of

1.00

Select one:
a. {w1,w2,p1}

b. {p1,p2,p3,s1}

c. {p1, s1}

d. {w1,w2,s1,p1}

The correct answer is: {p1,p2,p3,s1}

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 8/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question The schema that describes details of data storage and retrieval optimization algorithms is
21
Complete

Mark 1.00 out of

1.00

Select one:
a. External schema

b. Storage schema

c. Conceptual schema

d. Internal schema

The correct answer is: Internal schema

Question Consider the following diagram and answer the following question
22
Complete

Mark 1.00 out of

1.00

Which of the following statement is true?

Select one:
a. Some instances in S are related to an instance in P

b. Every instance in S is related to an instance in P

c. Every instance in S is related to many instances in P

d. Some instances in S are related to many instances instance in P

The correct answer is: Some instances in S are related to an instance in P

Question  Consider the following specialization

23
Complete

Mark 0.00 out of

1.00

if S1 ∪ S2  is always less than to the entity set in superclass C and  S1 ∩ S2  is empty entity set, then the
specialization is

Select one:
a. Partial

b. None

c. Total

d. Overlapping
https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 9/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

The correct answer is: Partial

Question The newer types of database systems, known as NOSQL systems, have one of the following characteristics,
24 which is:
Complete

Mark 1.00 out of

1.00

Select one:
a. Do not require meta-data.

b. Require meta-data

c. Using Data Dictionary

d. Data item names and data values stored into separate structure

The correct answer is: Do not require meta-data.

Question What is the number of attributes that represent the primary key for SP in the following Figure? 
25
Complete

Mark 0.00 out of

1.00

Answer: 4

The correct answer is: 3

Question  Let  H be a class that is defined as H ⊆ (D1 ∩ D2 ∩… ∩ Dn) where D1, …Dn are n superclasses, then H is a
26
Complete

Mark 1.00 out of

1.00

Select one:
a. Shared subclass

b. Union type

c. Disjoint category

d. Generalization type

The correct answer is: Shared subclass

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 10/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question If you have predefined attribute name (X) in super class A, used to specify subclass membership, and there are
27 two subclasses S1 and S2  as represented in below figure
Complete

Mark 0.00 out of

1.00

What are the type of X attribute and value of 

Select one:
a. Multi value attribute and the value of X is allowed to be null

b. Single value attribute and the value of X is not allowed to be null

c. Multi value attribute and the value of X is not allowed to be null

d. Single value attribute and the value of X is  allowed to be null

The correct answer is: Multi value attribute and the value of X is allowed to be null

Question  A weak entity type always has a ______ participation constraint with respect to its identifying relationships.
28
Complete

Mark 1.00 out of

1.00

Select one:
a. Partial

b. Disjoint

c. Overlap

d. Total

The correct answer is: Total

Question To change the constraints the ________ scheme needs to be changed.

29
Complete

Mark 1.00 out of

1.00

Select one:
a. Logical

b. Conceptual

c. Physical

d. Low-level

The correct answer is: Conceptual

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 11/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question  Consider the following EER diagram. Assume that the number of employee of type Professors is X, the number
30 of PhD-Students is Y, and the number of From-Industry is Z.
Complete

Mark 0.00 out of

1.00

Let X=5, Y=7, and Z=3. Based on the constraints, what is the expected maximum number of entities in Project
entity:

Answer: 7

The correct answer is: 15

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 12/14
2020/12/5 Midterm Exam 05/12/2020: Attempt review

Question Choose the correct ER diagram that corresponds to the following specification. Each Building has an BID
31 (unique) and BName (unique). Each Room has a RID (unique), Rname and Capacity. Each Building has at least one
Complete room, and each room belong exactly to one building.
Mark 1.00 out of
1.00

Select one:
a. Figure D

b. Figure C

c. Figure A

d. Figure B

The correct answer is: Figure A

Question Let X be a specialization from a superclass C. A is an attribute of C and used to specify subclass membership. if A
32 is single valued and  is allowed to be null, then X is
Complete

Mark 0.00 out of

1.00
Select one:
a. Overlap

b. Partial

c.
 Complete

d. Disjoin

The correct answer is: Partial

ANNOUNCEMENTS https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 13/14

2020/12/5 Midterm Exam 05/12/2020: Attempt review
◄ ANNOUNCEMENTS Jump to...

https://elearning.psut.edu.jo/mod/quiz/review.php?attempt=114071&cmid=55925 14/14