Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggregated trace file is created for all the sessions that are running the SRV1 service. 4. The trace files may be aggregated by using the trcess utility. 5. The trace files be aggregated by using the tkprof utility. Identify the correct outcome and the step to aggregate by using tkprof utility?（）..

第1题

[单选题] A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

A、 backup database all B、 backup compressed database C、 backup as compressed backupset database D、 backup as compressed backup database plus archivelog all E、 backup as compressed backupset database plus compress archivelog all

点击查看答案

第2题

[多选题] 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 container B、BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container C、BACKUP DATABASE while connected to the PDB1 container D、BACKUP DATABASE while connected to the boot container E、BACKUP PLUGGABLE database PDB1 while connected to PDB2

点击查看答案

第3题

[单选题] You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）

A、 by using the RMAN utility B、 by using the export/import utility C、 by using the ALTER DATABASE command D、 by enabling the change tracking feature

点击查看答案

第4题

[单选题] Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）

A、RECOVER LOGFILE BLOCK GROUP 2； B、ALTER DATABASE DROP LOGFILE GROUP 2； C、ALTER DATABASE CLEAR LOGFILE GROUP 2； D、ALTER DATABASE RECOVER LOGFILE GROUP 2； E、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；

点击查看答案

第5题

[单选题] 用T2000DM工具备份的MO存放的目录可以任意选择，而用网管界面上的“数据库备份”备份后的MO只能存放在（）

A、/T2000/server/database/dbbackup B、/T2000/server/database/MO C、/T2000/server/script D、/T2000/server/database

点击查看答案

第6题

[单选题] You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files B、dropping a user in your database C、enabling or disabling redo log archiving D、dropping a tablespace in your database E、re-creating the control files， after you lost all the control files in your database

点击查看答案

第7题

[] The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（） The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）

A、A. You obtain the results retrieved from the public synonym HR created by the database administrator. B、B. You obtain the results retrieved from the HR table that belongs to your schema. C、C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym. D、D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product. E、E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

点击查看答案

第8题

[单选题] Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?（）

A、The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR) B、The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) C、The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE D、The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed

点击查看答案

第9题

[] You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（） You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）

A、A.the time when the last flashback operation in your database was performed B、B.the time when the first flashback operation in your database was performed C、C.a list of flashback operations performed in your database using SCN and time D、D.the approximate time and the lowest system change number （SCN） to which you can flash back your database

点击查看答案

第10题

[] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（） You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、A. You must have change tracking enabled in your database B、B. Your database must be running in NOARCHIVELOG mode C、C. To back up a tablespace, it must be in backup mode D、D. To back up a tablespace, it must first be taken offline

点击查看答案

请使用微信扫码支付