Database Management Systems (CS403)

1. Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

   1. User accessible catalog
   2. Data processing
   3. Authorization service
   4. Recovery service

2. Each course section is assigned a particular faculty member, and each course section corresponds to a particular course. Conceptually, what is the relationship between faculty and course (not course section).

   1. 1:1
   2. 1:M
   3. M:M
   4. Ternary

3. 
   Consider the given relations Student and Instructor as given below. Please note that Fname and Lname also denote the First Name and Last Name respectively.
   Which of the following statements is correct with respect to the two relations given above?

   1. The two relations are not union-compatible since their attribute names differ.
   2. The two relations are union-compatible since they have the same type of tuples.
   3. The set operations such as CARTESIAN PRODUCT and DIVISION can be pplied on these two relations.
   4. To find out the students who are not instructors, it is necessary to perform the operation Student ÷ Instructor.

Select a course code for Objective Questions:

ACC311 ACC501 BIF101 BIF401 BIF501 BIO101 BIO201 BIO202 BIO203 BIO204 BIO301 BIO302 BIO303 BIO401 BIO503 BNK603 BT101 BT201 BT301 BT302 BT401 BT402 BT403 BT404 BT405 BT406 BT501 BT504 BT505 BT604 CHE201 CHE301 CS001 CS101 CS201 CS202 CS204 CS301 CS302 CS304 CS311 CS401 CS402 CS403 CS408 CS501 CS502 CS504 CS506 CS508 CS601 CS602 CS604 CS605 CS607 CS609 CS610 CS614 CS707 CS710 ECO401 ECO402 ECO403 ECO404 EDU302 EDU401 EDU402 EDU501 EDU601 ENG101 ENG201 ENG301 ENG501 FIN611 FIN624 FIN625 ISL201 IT430 MCM101 MCM301 MGMT623 MGT101 MGT211 MGT301 MGT401 MGT402 MGT501 MGT502 MGT503 MGT510 MGT601 MGT603 MKT501 MKT610 MKT630 MTH101 MTH202 MTH302 MTH501 MTH601 MTH634 PAK301 PHY101 PHY301 PSY101 PSY403 PSY502 PSY512 SOC101 SOC301 SOC401 STA301 STA630 STA641 ZOO102 ZOO401 ZOO501 ZOO502 ZOO503 ZOO504 ZOO505 ZOO506 ZOO510 ZOO630

Select a course code for Subjective Questions:

ACC311 CS001 CS101 CS201 CS301 CS607 CS701 CS702 CS703 CS704 CS707 CS708 CS710 CS711 CS718 CS721 CS724 ECO401 ECO403 ENG101 ENG301 MGT703 MTH501 STA301