The HR user receives the following error while inserting data into the sales table:On investigation, you find that the u

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

The HR user receives the following error while inserting data into the sales table:On investigation, you find that the u

Post by answerhappygod »

The HR user receives the following error while inserting data into the sales table:On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.Which two methods would you use to resolve this error? (Choose two.)
The Hr User Rec 1
The Hr User Rec 1 (10.18 KiB) Viewed 156 times
A. Altering the data file associated with the USERS tablespace to extend automatically
B. Adding a data file to the USERS tablespace
C. Changing segment space management for the USERS tablespace to manual
D. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace E. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply