1Z0-082 practice question 15 of 25
You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE ‘/u01/app/oracle/sales01.dbf SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace? (Choose two.)
Full set: 142 questionsThe CREATE TABLESPACE statement does not include the BLOCKSIZE clause, so the tablespace will use the database's default block size, defined by the DBBLOCKSIZE parameter. The clause SEGMENT SPACE MANAGEMENT AUTO specifies that the tablespace will use Automatic Segment Space Management (ASSM). A tablespace that uses ASSM must be a locally managed tablespace. Since Oracle Database 10g, locally managed tablespaces are the default, and this clause confirms this configuration.
A. A smallfile tablespace's total size is the sum of its datafiles and can exceed a bigfile tablespace's size.
B. SEGMENT SPACE MANAGEMENT AUTO uses bitmaps to manage free space, not freelists, which are used in manual segment space management.
C. The SIZE 5G clause applies only to the initial datafile. Subsequent datafiles added to this tablespace can have different sizes.
1. Oracle Database SQL Language Reference
19c. "CREATE TABLESPACE". The documentation states that omitting the BLOCKSIZE clause causes the tablespace to use the standard database block size.
2. Oracle Database Concepts
19c. Chapter 13
"Logical Storage Structures"
Section "Locally Managed Tablespaces". It explains that SEGMENT SPACE MANAGEMENT AUTO is a property of locally managed tablespaces.
3. Oracle Database Administrator's Guide
19c. Chapter 13
"Managing Tablespaces"
Section "Creating Tablespaces". This section confirms that locally managed is the default and describes the behavior of the BLOCKSIZE clause.
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
