Consider the Registration relation shown in the exhibit. Which of the following SQL statements
would return all tuples that have course codes beginning with the letter M?
Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in
the exhibit:
Which of the following relational algebraic expressions would result in the given table?
Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples
for Student_ID 1003 must be performed. It is necessary to change one of the activities from
swimming to tennis. The Student_ID and Activity attributes make up the primary key for the
Recreation relation. All related information must be altered, as well. Which SQL statement or
statements would best accomplish this?
Which term describes the management of simultaneous transactions to prevent conflicts?
Which characteristic is an advantage of a database management system?
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!