Temporal Databases – Real-time Systems MCQs

20 min
Score: 0
Attempted: 0/20
Subscribe

1. What is a temporal database?
(A) A database used exclusively for disk management
(B) A database used only for batch processing
(C) A database that ignores timestamps
(D) A database that stores data related to time, tracking history and validity of information

2. Which of the following is a key feature of temporal databases?
(A) Ability to store historical, current, and future data values
(B) Only stores current values
(C) Only batch updates
(D) Ignores transaction timing

3. Temporal databases are mainly used in:
(A) Real-time systems, banking, and scientific applications
(B) Desktop word processing exclusively
(C) Multimedia streaming only
(D) Batch file storage

4. Which type of time is commonly managed in temporal databases?
(A) CPU idle time only
(B) Valid time and transaction time
(C) Disk access time exclusively
(D) Batch process time only

5. Valid time in a temporal database refers to:
(A) Batch process completion
(B) The time when CPU is idle
(C) Disk scheduling time only
(D) The time period during which a fact is true in the real world

6. Transaction time refers to:
(A) Batch processing time
(B) The time when CPU is idle
(C) Disk access time only
(D) The time when a fact is stored in the database

7. Which type of query is specific to temporal databases?
(A) CPU utilization queries exclusively
(B) Disk read queries only
(C) Temporal queries, which involve time intervals
(D) Batch file queries

8. Which temporal database model stores both valid and transaction times?
(A) Bitemporal database
(B) Standard relational database exclusively
(C) Flat-file database only
(D) Object database

9. Temporal databases help in:
(A) Reducing memory automatically
(B) CPU idle optimization only
(C) Disk batch processing exclusively
(D) Auditing, historical analysis, and real-time decision-making

10. Which type of constraint is important in temporal databases?
(A) Memory allocation
(B) Disk integrity only
(C) CPU timing exclusively
(D) Temporal integrity constraints

11. Temporal databases can handle:
(A) CPU idle cycles
(B) Only current data
(C) Static batch files exclusively
(D) Evolving data and historical corrections

12. Which SQL extension is used for temporal data management?
(A) Standard SQL exclusively
(B) TSQL2
(C) Batch SQL only
(D) DiskSQL

13. Temporal databases differ from conventional databases by:
(A) Only batch storing data
(B) Tracking time and history of data
(C) Ignoring timestamps
(D) Disk scheduling

14. Future temporal data allows:
(A) CPU idle monitoring
(B) Only past events
(C) Only current snapshots
(D) Storing planned or scheduled events

15. Temporal joins in a database refer to:
(A) Batch file joins
(B) CPU scheduling exclusively
(C) Disk merging only
(D) Combining data based on overlapping time intervals

16. A temporal key in a database is:
(A) Disk address key exclusively
(B) CPU cycle key only
(C) A primary key combined with time interval information
(D) Batch process key

17. Temporal normalization ensures:
(A) Minimization of redundancy while preserving time-dependent data
(B) CPU optimization only
(C) Disk block optimization exclusively
(D) Batch file efficiency

18. Which type of index improves temporal query performance?
(A) Batch process index
(B) CPU cycle index only
(C) Disk block index exclusively
(D) Time-based index

19. Temporal databases support:
(A) Batch-only processing
(B) Only current data exclusively
(C) Retrospective, current, and prospective analysis
(D) Disk scheduling

20. The main advantage of temporal databases in real-time systems is:
(A) Ability to track historical, current, and future states for timely decision-making
(B) Reduces CPU idle automatically
(C) Batch file transfer exclusively
(D) Memory optimization only