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？（） enable index monitoring and query the DBA_OBJECTS view。 enable index monitoring and query the DBA_INDEXES view。 enable index monitoring and query the V$OBJECT_USAGE view。 enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view。
丝裂霉素抑菌的作用机制是（） 抑制细胞壁合成。 抑制RNA合成。 抑制蛋白质合成。 抑制DNA复制。
You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（） create baseline metrics for today’s performance。 write the current database metrics to a database table and create a trigger to compare with future database statistics。 write the current database metrics to a flat file and create an operating script to compare with future database statistics。 write the current database metrics to a database table and create a procedure to compare with future database statistics。 write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistic。
Which of the following is one of the key differentiators between the IBM System Storage DS8000 and the XIV system?（） DS8000 supports z/OS; XIV supports both z/OS and Linux on z。 DS8000 uses standard RAID technology; XIV uses distributed RAID。 XIV is a single tiered system; DS8000 supports FC and SSD disk technologies only。 XIV supportsFibre Channel protocol and mixed SATA and FC drives; DS8000 supports parallel grid architecture。
You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（） The tablespace must be locally managed.。 The tablespace must have only one temp file.。 The tablespace must be made nondefault and offline.。 The tablespace can remain as the default but must have no active sort operations.。
You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.
What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）
