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.

the correct option is (d) vin label

vin stands for vehicle information number. this is a thin metallic plate attached to the engine of the vehicle and it includes all the important information which are related to the vehicle. it also provides the information whether the vehicle has been stolen or not because the replacement and alternation of vin number creates difference in the exact number printed on the vin and carved on the engine.