多选题Identify the three predefined server-generated alerts.（）ADrop UserBTablespace Space UsageCResumable Session SuspendedDRecovery Area Low On Free SpaceESYSTEM Tablespace Size Increment
多选题
Identify the three predefined server-generated alerts.（）
A
Drop User
B
Tablespace Space Usage
C
Resumable Session Suspended
D
Recovery Area Low On Free Space
E
SYSTEM Tablespace Size Increment
参考解析
解析：
暂无解析
相关考题：
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
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to()。 A. identify the segments that you should shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space
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
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
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)A、An entry is created in the alert log file and the database instance continues to function normallyB、The log switch hangs occur for transactions until free space is available in the flash recovery areaC、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaD、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
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.
Identify the three predefined server-generated alerts.（）A、Drop UserB、Tablespace Space UsageC、Resumable Session SuspendedD、Recovery Area Low On Free SpaceE、SYSTEM Tablespace Size Increment
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。A、identify the segments that you should shrinkB、modify the storage parameters for the tablespaceC、automatically shrink the segments with unused spaceD、check the alerts generated for the tablespace that is running low on space
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： 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.
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)A、Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.B、A resumable statement is suspended only if an out of space error occurs.C、When a resumable statement is suspended, the transaction that contains the statement is also suspended.D、A resumable statement can only be suspended and resumed once during the execution of the statement.E、You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session
You receive the following error： ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message？（）A、 The sort area is very small.B、 There is no more space in the Undo tablespace.C、 The flash recovery area is full.D、 The online redo log file is full.
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
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.
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch?（）A、An entry is created in the alert log file and the database instance continues to function normallyB、The log switch hangs occur for transactions until free space is available in the flash recovery areaC、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area OracleD、The database instance statusis implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
多选题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？（）Aset PCTFREE and PCTUSED to 50Bspecify extent allocation as UniformCspecify extent allocation as AutomaticDcreate the tablespace as bigfile tablespaceEcreate the tablespace as smallfile tablespaceFset segment space management to AutomaticGuse the RESIZE clause while creating the tablespace
单选题You receive the following error： ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message？（）A The sort area is very small.B There is no more space in the Undo tablespace.C The flash recovery area is full.D The online redo log file is full.
多选题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
单选题You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）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.
单选题You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。Aidentify the segments that you should shrinkBmodify the storage parameters for the tablespaceCautomatically shrink the segments with unused spaceDcheck the alerts generated for the tablespace that is running low on space
多选题You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)AEven with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.BA resumable statement is suspended only if an out of space error occurs.CWhen a resumable statement is suspended, the transaction that contains the statement is also suspended.DA resumable statement can only be suspended and resumed once during the execution of the statement.EYou can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session
多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch?（）AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area OracleDThe database instance statusis implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
多选题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 want the size of the tablespace to increase when it is full. Which option would you use？（）Ause automatic extent allocationBdisable threshold for the tablespaceCuse freelists to manage the free spaceDuse automatic segment space managementEcreate the tablespace as a bigfile tablespaceFuse the RESIZE clause while creating the tablespaceGenable AUTOEXTEND for at least one of the data files in the tablespace
单选题You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.Aadd data files to the tablespace Bidentify the segments that you should shrink Cmodify the storage parameters for the tablespace Dautomatically shrink the segments with unused space Echeck the alerts generated for the tablespace that is running low on space
多选题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.
多选题Identify the three predefined server-generated alerts. （）ADrop UserBTablespace Space UsageCResumable Session SuspendedDRecovery Area Low On Free SpaceESYSTEM Tablespace Size Increment
多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaDThe database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented