You work as a Database Administrator for Bell Ceramics Inc. An employee of the company has fired a query,
including a DML statement, such as INSERT, against a table named Sales. You notice that the DML statement
has not executed. What will you do to resolve the issue? Each correct answer represents a complete solution.
Choose two.

A.
Clean up all the uncommitted transactions on the Sales table.

B.
Add more space to the tablespace and increase theusers quota on the tablespace.

C.
Provide redundant network paths from the client computer to the server along with additional listener
connections on the Oracle server and redundant network cards on the Oracle server.

D.
Provide an appropriate privilege or create views on the Sales table, and grant privileges on the view.

Explanation:
Answer D and BIf an Oracle database fails due to any DML statements issued in a database, then the type of failure is
categorized under statement failures.
To overcome the statement failures, appropriate privileges on the table and views should be provided. The
issue can also be resolved by
adding more space to the tablespace or by increasing the users’ quota on the tablespace. Answer A is
incorrect. Cleaning up all the uncommitted transactions in the Sales table will not resolve the issue if an Oracle
database
faces inconsistencies due to statement failures.
Answer C is incorrect. The redundant network paths from the client computer to the server along with
additional listener connections
on the Oracle server and the redundant network cards on the Oracle server will resolve the issue only if the
Oracle database fails due to
network inconsistencies.