HARD
HSSC Clerk
IMPORTANT
Earn 100
What are the potential problems when a DBMS executes multiple transactions concurrently?
1. The lost update problem
2 The dirty read problem
3. The unrepeatable read problem
4. The phantom problem
50% studentsanswered this correctly
Important Questions on Database Management System
EASY
HSSC Clerk
IMPORTANT
In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. What is the primary key in it?
EASY
HSSC Clerk
IMPORTANT
For a database relation R(a,b,c,d), where the domains a, b, c, d include only atomic values, only the following functional dependencies and those that can be inferred from them hold:
{ a → c, b → d }
MEDIUM
HSSC Clerk
IMPORTANT
E-R modelling technique is a_____.
EASY
HSSC Clerk
IMPORTANT
Choose the correct statement:
MEDIUM
HSSC Clerk
IMPORTANT
Data independence in DBMS is known as ______.
MEDIUM
HSSC Clerk
IMPORTANT
A data dictionary doesn't provide information about_____.
MEDIUM
HSSC Clerk
IMPORTANT
The database administrator is, in effect, the coordinator between the _____ and the ______.
MEDIUM
HSSC Clerk
IMPORTANT
What does the data dictionary identify?
