Database Design & Transactions
JKSSB Sub-Inspector (Telecommunication) · Database Management Systems · 8 practice questions with answers and explanations: 1 Easy, 3 Medium, 4 Hard.
Sample questions
Sample Easy question 1
What does 'DBMS' stand for?
- Database Management System
- Data Backup Management System
- Digital Base Management Software
- Data Base Monitoring System
Show answer
Answer: A. DBMS stands for Database Management System.
Sample Medium question 2
What does 'concurrency control' in a DBMS help prevent?
- Conflicts and inconsistencies when multiple transactions access data simultaneously
- Physical damage to hard drives
- Password theft only
- Internet outages
Show answer
Answer: A. Concurrency control mechanisms prevent conflicting updates when multiple transactions run at the same time.
Sample Hard question 3
What are 'integrity constraints' in a database used to enforce?
- Rules that ensure the accuracy and consistency of data
- Only the visual formatting of reports
- Only network speed limits
- Only user login times
Show answer
Answer: A. Integrity constraints (like primary keys and foreign keys) enforce rules that keep data accurate and consistent.