AAll the extents will be of the same size.
BBitmap will be used to record free and allocated extents.
CFree extents will be managed by the data dictionary tables.
DThe tablespace will be system managed and the users cannot specify the extent size.
When you use the Oracle Net Configuration Assistant to specify the naming method, which file is updated?()
单选题查看答案
You specified segment space management as automatic for a tablespace. What effect would this have on space management?()
单选题查看答案
Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?()
单选题查看答案
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?()
单选题查看答案
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()
单选题查看答案
You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user, Scott. Which value will you set for the NLS_SORT parameter?()
单选题查看答案
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()
单选题查看答案
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting?()
单选题查看答案
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()
单选题查看答案