网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）
A
All the extents will be of the same size.
B
Bitmap will be used to record free and allocated extents.
C
Free extents will be managed by the data dictionary tables.
D
The tablespace will be system managed and the users cannot specify the extent size.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）A All the extents will be of the same size.B Bitmap will be used to record free and allocated extents.C Free extents will be managed by the data dictionary tables.D The tablespace will be system managed and the users cannot specify the extent size.” 相关考题
考题
You executed the following commands in a database session:What could have caused the recycle bin to clean up?()
A. There is demand for space from the new table从B. The undo tablespace does not have sufficient free spaceC. The new table name is the same as the table name in the recycle binD. The temporary tablespace that is assigned to you does not have sufficient free space
考题
Evaluate the following command and its output:Which two statements correctly interpret the output?()
A. FREE_SPACE indicates only the space that is currently unallocated.B. ALLOCATED_SPACE indicates only the space currently allocated and in use.C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
考题
Evaluatethefollowingcommandanditsoutput：SQLSELECT*FROMdba_temp_free_space；TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput？（）A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused，andthespacethat isavailableforreuse.E.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse，andthespacethatiscurrentlyunallocated.
考题
The user HR receives the following error while inserting data into the TTK table： ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon investigation， you find that SMD is a small file tablespace. Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.
考题
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？（）A、set PCTFREE and PCTUSED to 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace
考题
Evaluate the following command and its output： SQLSELECT * FROM dba_temp_free_space； TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）A、 FREE_SPACE indicates only the space that is currently unallocated.B、 ALLOCATED_SPACE indicates only the space currently allocated and in use.C、 FREE_SPACE indicates only the space that is currently allocated and available for reuse.D、 ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.E、 FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
考题
Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.
考题
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）A、run a procedure to check the tablespace space usageB、define the warning threshold for the tablespace at 75% in Database ControlC、create a trigger to be executed when tablespace space usage reaches 75%D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
考题
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee： SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database？（）A、The extents in undo tablespace retain data until the next full database backup.B、The extents containing committed data in the undo tablespace are never overwritten.C、The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.D、The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
考题
You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）A、Extents would be managed by the freelists.B、The segment would be managed by bitmaps.C、The segment would be managed by the freelists.D、Free space would be managed by the data dictionary.
考题
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（）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.
考题
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（）A、No more data files can be added to the tablespace.B、Segment space is managed by free lists in the tablespace.C、A user created without being assigned a default tablespace uses this tablespace.D、The tablespace can be dropped with the current setting with segments present in it
考题
Examine the statement： SQL CREATE TABLESPACE user_data 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）A、Oracle Managed Files are used for this instance.B、The USER_DATA tablespace is managed using FET$/UET$ tables.C、The COMPATIBLE initialization parameter must be 9.0.0 or higher.D、Space within segments in the USER_DATA tablespace is managed with freelists.
考题
You executed the following command to create a tablespace called SALES_DATA： CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）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 inbitmapblocks.E、The space utilization description of the data blocks in segments is managed through free lists.MANUAL
考题
You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）A、All the extents will be of the same size.B、Bitmap will be used to record free and allocated extents.C、Free extents will be managed by the data dictionary tables.D、The tablespace will be system managed and the users cannot specify the extent size.
考题
多选题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（）ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it
考题
单选题Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）A
The extents in the undo tablespace retain data until the next full database backup.B
The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.C
The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.D
The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
考题
多选题Examine the statement： SQL CREATE TABLESPACE user_data 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）AOracle Managed Files are used for this instance.BThe USER_DATA tablespace is managed using FET$/UET$ tables.CThe COMPATIBLE initialization parameter must be 9.0.0 or higher.DSpace within segments in the USER_DATA tablespace is managed with freelists.
考题
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）A
DBMS_STATS B
DBMS_ALERT C
DBMS_SPACE D
DBMS_MONITOR E
DBMS_SERVER_ALERTF
DBMS_SPACE_ADMIN
考题
单选题You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）A
Extents would be managed by the freelists.B
The segment would be managed by bitmaps.C
The segment would be managed by the freelists.D
Free space would be managed by the data dictionary.
考题
单选题You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）A
run a procedure to check the tablespace space usageB
define the warning threshold for the tablespace at 75% in Database ControlC
create a trigger to be executed when tablespace space usage reaches 75%D
submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE
define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
考题
多选题You executed the following command to create a tablespace called SALES_DATA： CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）AThe database automatically determines the extent-sizing policy for the tablespace.BThe segments are automatically shrunk when the contents are removed from them.CThe allocation of extents within the tablespace is managed through the dictionary tables.DThe space utilization description of the data blocks in segments is recorded inbitmapblocks.EThe space utilization description of the data blocks in segments is managed through free lists.MANUAL
考题
多选题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（）AThe database automatically determines the extent-sizing policy for the tablespace.BThe segments are automatically shrunk when the contents are removed from them.CThe allocation of extents within the tablespace is managed through the dictionary tables.DThe space utilization description of the data blocks in segments is recorded in bitmap blocks.EThe space utilization description of the data blocks in segments is managed through free lists.
考题
单选题During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）A
DBW0 B
LGWR C
ARCH D
SMON E
PMON
考题
单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）A
use automatic extent allocationB
disable threshold for the tablespaceC
use freelists to manage the free spaceD
use automatic segment space managementE
create the tablespace as a bigfile tablespaceF
use the RESIZE clause while creating the tablespaceG
enable AUTOEXTEND for at least one of the data files in the tablespace
考题
多选题Which two statements about bigfile tablespaces are true？ （）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.
考题
多选题Evaluate the following command and its output： SQLSELECT * FROM dba_temp_free_space； TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
热门标签
最新试卷
