多选题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
多选题
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 normally
B
The log switch hangs occur for transactions until free space is available in the flash recovery area
C
The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area Oracle
D
The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
参考解析
解析：
暂无解析
相关考题：
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?() A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerB. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 containerC. BACKUP DATABASE while connected to the PDB1 containerD. BACKUP DATABASE while connected to the boot containerE. BACKUP PLUGGABLE database PDB1 while connected to PDB2
While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）A、 It would result in an error because the warning threshold cannot be more than the critical threshold.B、 The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.C、 The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.D、 Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true？（）A、 The new setting would be applied but no alerts would be raised immediately.B、 The new setting would be applied and an alert would be raised immediately.C、 The new setting would be ignored because the tablespace space usage is more than the specified threshold value.D、 The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）A、Coalesce the application tables at a regular interval.B、Export and Import the application tables a regular interval.C、Drop and recreate the application tables at a regular interval.D、Move the application tables to a tablespace with less space usage.E、Distribute the application tables across multiple tablespaces depending on usage.F、Move the application tables to automatic segment space management tablespace.
You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A、the alert.log fileB、the DBA_ALERTS viewC、the Database Control Home pageD、the Database Control performance pageE、the Database Control Maintenance page
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）A、 No warning level or critical level alert will be generated.B、 A warning level alert will never be generated， but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used.C、 A critical level alert will never be generated， but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used.D、 A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace， and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.
单选题While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）AGeneralB High AvailabilityC Space UsageD Diagnostic Summary
单选题Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）AIt returns space usage of only BasicFile LOB chunks.BIt returns space usage of only SecureFile LOB chunks.CIt returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.DIt returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
单选题You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）Athe alert.log fileBthe DBA_ALERTS viewCthe Database Control Home pageDthe Database Control performance pageEthe Database Control Maintenance page
多选题Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）ABACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerBBACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 containerCBACKUP DATABASE while connected to the PDB1 containerDBACKUP DATABASE while connected to the boot containerEBACKUP PLUGGABLE database PDB1 while connected to PDB2
单选题While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows: 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.（）A2，3，5B1，2，4C1，2，4，5D1, 2, 3, 4, 5
多选题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 areaDThe database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager （RMAN）commands after creating the databaseEschedule the database backup using Database Configuration Assistant （DBCA）while creating the database
单选题The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50% and critical threshold to be 53% in Database Control. Which statement is true？（）AThe new setting would be applied but no alerts would be raised immediately.BThe new setting would be applied and an alert would be raised immediately.CThe new setting would be ignored because the tablespace space usage is more than the specified threshold value.DThe new setting would cause an error because the tablespace space usage is more than the specified threshold value.
单选题While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）AIt would result in an error because the warning threshold cannot be more than the critical threshold.BThe warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.CThe critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.DBoth threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
单选题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?（）ADBMS_STATS BDBMS_ALERT CDBMS_SPACE DDBMS_MONITOR EDBMS_SERVER_ALERTFDBMS_SPACE_ADMIN
单选题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？（）Arun a procedure to check the tablespace space usageBdefine the warning threshold for the tablespace at 75% in Database ControlCcreate a trigger to be executed when tablespace space usage reaches 75%Dsubmit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsEdefine the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
单选题Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）A It returns space usage of only BasicFile LOB chunks.B It returns space usage of only SecureFile LOB chunks.C It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.D It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）Aenable index monitoring and query the DBA_OBJECTS viewBenable index monitoring and query the DBA_INDEXES viewCenable index monitoring and query the V$OBJECT_USAGE viewDenable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
多选题You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（）AChange the RMAN archived log deletion policyBUse the RMAN CROSSCHECK command to reclaim the archived log spaceCChange the RMAN retention policy to retain backups for a shorter period of timeDUse OS command to move files from the flash recovery area to some other location