A student is analyzing Concurrency Control. Which statement about deadlock is correct?

A. a query chooses a full table scan B. two or more transactions wait for each other so none can proceed C. a transaction commits successfully after reading D. a database creates an index automatically