The bigfile tablespace have only one data file.
The segment space management is automatic.
The extent management is dictionary managed.
The database can have only one bigfile tablespace.
The bigfile tablespace can be converted to a smallfile tablespace.
第1题:
You want the size of the tablespace to increase when it is full. Which option would you use?()
第2题:
You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose?()
第3题:
A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
第4题:
You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace()
第5题:
Which two statements about bigfile tablespaces are true? ()
第6题:
Which two statements are true regarding undo tablespaces()
第7题:
Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)
第8题:
Which two statements correctly describe the relation between a data file and the logical databasestructures()
第9题:
Which statements are true about logical structures of the Oracle database()
第10题:
Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered. Which two statements are trueregarding the MRKT tablespace()