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 the users 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:
If 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.