You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_dataDATAFILE SI

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

You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_dataDATAFILE SI

Post by answerhappygod »

You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_dataDATAFILE SIZE 100M -SEGMENT SPACE MANAGEMENT AUTO;Which two statements are true about the SALES_DATA tablespace? (Choose two)

A. The database automatically determines the extent-sizing policy for the tablespace.
B. The segments are automatically shrunk when the contents are removed from them.
C. The allocation of extents within the tablespace is managed through the dictionary tables.
D. The space utilization description of the data blocks in segments is recorded in bitmap blocks. E. The space utilization description of the data blocks in segments is managed through free lists.
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