I would go as some said about the interviewer would like to hear about your ACID knowledge but in a case where he would absolutely like something:
Running some concurrent queries with NOLOCK or READ UNCOMMITTED isolation level could break the ACID property. (The I one)
From wikipedia:
The isolation property ensures that the concurrent execution of transactions results in a system state that could have been obtained if transactions are executed serially, i.e. one after the other.
Because of page split you might obtain a different result than having those requests done sequentially.
I'm sure there's other answers also but this one that came up my mind.