Which option best describes the use of deadlock in a database system?

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