Question
Train E leaves Kanpur at a certain time. After 6 hours, a
superfast train leaves the same station and travels in the same direction at the speed of 180 km/h. If the superfast train catches up Train E in 12 hours, then what is the speed of Train E?Solution
Distance travelled by the superfast train in 12 hours = 180 × 12 = 2160 km
Speed of Train E = 2160 / (6 + 12) = 120 km/hr
Which of the following schedules is serializable?
Which of the following is not part of the process control block (PCB)?
Given a relation R(A, B, C, D, E) and functional dependencies {A -> B, BC -> D, D -> E}. Which of the following is a candidate key for R?
MVCC (Multi-Version Concurrency Control) ensures:
Which constraint ensures that no duplicate values exist in a column?
Which constraint ensures that a column contains only unique values, but allows NULL values?
An RDBMS provides mechanisms for data integrity, such as primary keys and foreign keys, which are generally lacking in:
Which normal form eliminates transitive dependency?
Which of the following is true about the primary key in a relational database?
In indexing, which tree is most commonly used for disk-based indexing because it minimizes disk seeks and keeps nodes dense?