Quiz Space

Database Management Systems · Quiz 1 · 16 Jul 2023 · May 2023 term

Question 2: Suppose a company wants to determine whether the ’price’ …

Question 2

+2 marksOne correct option

Suppose a company wants to determine whether the ’price’ of the commodity will be an attribute in the shopping database or not. Which of the following holds good about this?

  1. A

    This is a physical-level decision.

  2. B

    This is a logical level decision.

  3. C

    This is an application-level decision.

  4. D

    This is a view-level decision.

Show answer

Correct answer

  • B

    This is a logical level decision.

See the whole paperTake it as a mock test

Question 2 of 17 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 16 Jul 2023, in the May 2023 term (IIT M FOUNDATION AN2 EXAM QPF2 16 JULY 2023). It carries 2 marks.

More questions from this paper

  1. Q1The lowest level of data abstraction is
  2. Q3Consider the following scenario:\ The Reserve Bank of India (RBI) has issued guidelines declaring that the Rs. 2000 not…
  3. Q4Consider the schema given below : Emp (<u>eid</u>, ename, age, salary)\ Works (<u>eid</u>, did, pct_time)\ Dept (<u>did…
  4. Q5An instance of the relation students is given below. | sid | name | age | gpa | |---|---|---|---| | 53831 | Madayan | 1…
  5. Q6Consider two relations R and S as shown below. | A | B | C | |---|---|---| | 1 | 2 | 3 | | 2 | 4 | 6 | | 3 | 7 | 3 | | …
  6. Q7Figure question
  7. Q8Figure question
  8. Q9Consider the relation G20(country_name, foreign_minister_name, events, date, venue)\ Questions: Find the name of foreig…
  9. Q10Figure question
  10. Q11Figure question
  11. Q12Consider the student relation given below. Select the correct query/queries to obtain the last name of students whose a…
  12. Q13Consider the two relations R and S. | A | B | C | |---|---|---| | 0 | 9 | 0 | | 2 | 2 | 2 | | 1 | 1 | 1 | | A | B | C |…
  13. Q14Consider the relation student shown in Table 3 | Roll_no | Name | marks | |---|---|---| | 1 | Ram | 50 | | 2 | Rakesh |…
  14. Q15Consider the following table which has four attributes: A, B, C, and D where A is the primary key and C is the foreign …
  15. Q16Figure question
  16. Q17Figure question