Question
Consider the following statements: 1. The Chief
Minister of Delhi is appointed by the President of India. 2. The Delhi Police and Municipal Corporation of Delhi do not come under the administrative purview of the Delhi Government. Which of the statements given above is/are correct?Solution
• The Chief Minister of National Capital Territory of Delhi is appointed by the Indian President (not by the lt. governor). • Municipal Corporation of Delhi (MCD) is the municipal corporation that governs most of Delhi, India. - The Municipal Corporation of Delhi was replaced by three new bodies, the North Delhi Municipal Corporation, the South Delhi Municipal Corporation and the East Delhi Municipal Corporation in 2012. - They are controlled by the Government of India. • Delhi Police comes under the jurisdiction of the Ministry of Home Affairs (MHA), Government of India.
Shadow paging in recovery eliminates the need for:
Which of the following is a type of database index?
In relational algebra, the operation that combines tuples from two relations using common attribute values is:
What is the maximum number of processes that can be in the Ready state?
A transaction that reads a value then later sees a different value because another transaction updated and committed in between experiences which anomaly?
MVCC (Multi-Version Concurrency Control) ensures:
Which of the following is true about ACID properties in DBMS?
Which normal form removes partial dependency?
Which of the following is not part of the process control block (PCB)?
In an E-R Diagram, entities are typically represented by: