1D0-541 CIW Exam Questions and Free Practice Test

Question 19

In which situation would the DBMS use a serial schedule to execute the transactions?

A. Concurrent transactions read data from the same data structure.

B. Concurrent transactions write data to different data structures.

C. Concurrent transactions read or write the same data structure.

D. Concurrent transactions read or write from different data structures.

Correct Answer:C
1D0-541 dumps exhibit

Question 20

Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?
1D0-541 dumps exhibit

A. Union

B. Intersection

C. Natural join

D. Cartesian product

Correct Answer:C

START 1D0-541 EXAM