The USERS table has thousands of rows and is accessed very often with an index (ISERID_NDX) on a primary key (USER_ID). Where should USERS and USERID_NDX be stored?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- In which tablespace AWR data is stored
- What is the maximum number of tables that can be stored on a Partitioned Table Space?
- When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
- When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
- A 10 GB index is to be created on the ITEM table. The index should be spread across many tablespaces, decre...
- Which of the following can be reorganized and backed up with minimal impact to other users, whose data may ...
- When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
- User data stored in