Exam 98-364 topic 1 question 147 discussion

Actual exam question from Microsoft's 98-364

Question #: 147
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: BD 🗳️

by rogeriosolano at June 28, 2022, 10:49 p.m.

Comments

Submit Cancel

rogeriosolano

2 years, 11 months ago

Selected Answer: BD

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.

upvoted 1 times

...