Question 1
The lowest level of data abstraction is
physical level
logical level
view level
application level
Question 2
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?
This is a physical-level decision.
This is a logical level decision.
This is an application-level decision.
This is a view-level decision.
Question 3
Consider the following scenario:
The Reserve Bank of India (RBI) has issued guidelines declaring that the Rs. 2000 note will no longer be considered legal tender, starting from a specific date. The RBI wants to update its database to reflect this change and ensure that transactions involving the Rs. 2000 note are flagged as invalid.
Which DBMS concept would be most relevant for the RBI to update its database and flag transactions involving the Rs. 2000 note as invalid after the specified date?
CASCADE
Data Definition Language (DDL)
Triggers
Indexing
14 more questions in this paper
Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.
More on the DBMS Quiz 1 16 Jul 2023 paper
The IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 16 Jul 2023, in the May 2023 term: 17 questions for 50 marks in 120 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.
| Feature | DBMS Quiz 1 16 Jul 2023 at a glance |
|---|---|
| Term | May 2023 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 17 |
| Marks | 50 |
| Duration | 120 min |
| MCQ | 8 |
| MSQ | 4 |
| Numerical | 5 |
| Official paper | IIT M FOUNDATION AN2 EXAM QPF2 16 JULY 2023 |
| Negative marking | No negative marking. |
| Updated |