The command can be used to view the contents of a record when it is anticipated that the record will need to be modified. it places a shared lock on the record(s) to be changed and prevents any other user from acquiring a lock on the same record(s).
a) table
b) table
c) update
d) update

The correct answer is B)

Explanation:

The commit command allows us to:

• Consolidate, confirm

• committing refers to the idea of confirming a set of provisional changes permanently.

• A popular use is at the end of a database transaction.

•

The LOCK TABLE command should be used:

• when a lock of the mode specified in the table can be acquired.

• The command will wait for everything you need to get the lock,

• In case you cannot acquire the lock immediately, the NOWAIT option is specified so that the command cancels the transaction.