Database Fundamentals — Question 152

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.)

Answer options

• 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.

Correct answer: B, D

Explanation

Option B is correct because adding space to the tablespace and increasing the user's quota can resolve issues related to insufficient storage for DML operations. Option D is also correct as providing the necessary privileges ensures that the user has the rights to perform the INSERT operation on the Sales table. Options A and C do not directly address the execution problem encountered with the DML statement.