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_M

题目

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?（）

  • A、1
  • B、2 and 4
  • C、2 and 5
  • D、3 and 4
  • E、3 and 5
相似考题

1.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?（）A. 1B. 2 and 4C. 2 and 5D. 3 and 4E. 3 and 5

2.In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database

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 utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature

4. Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

参考答案和解析
正确答案:B
更多“Your database has the SRV1 serv”相关问题

  • 第1题：

    Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

    • A、 Yes， if the database is in ARCHIVELOG mode
    • B、 Yes， if the database is in NOARCHIVELOG mode
    • C、 No， the backup is not usable in any way
    • D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

    正确答案:C

  • 第2题：

    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

    正确答案:C

  • 第3题：

    Your company has a main office and a branch office. The main office has a domain controller named DC1 that hosts a DNS primary zone. The branch office has a DNS server named SRV1 that hosts a DNS secondary zone. All client computers are configured to use their local server for DNS resolution.You change the IP address of an existing server named SRV2 in the main office.You need to ensure that SRV1 reflects the change immediately.What should you do？（）

    • A、Restart the DNS Server service on DC1.
    • B、Run the dnscmd command by using the /zonerefresh option on DC1.
    • C、Run the dnscmd command by using the /zonerefresh option on SRV1.
    • D、Set the refresh interval to 10 minutes on the Start of Authority (SOA) record.

    正确答案:C

  • 第4题：

    单选题
    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
    A

    One tablespace has only one datafile

    B

    Many tablespaces can share one datafile

    C

    One tablespace can have many datafiles

    D

    One datafile can contain many tablespaces


    正确答案： C
    解析： 暂无解析

  • 第5题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    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；


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）
    A

     13：00 on Tuesday.

    B

     15：00 on Tuesday.

    C

     Up until the last available archived redo log on Sunday.

    D

     To any point； all the redo should still be available in the online redo logs.

    E

     The database is not recoverable.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）
    A

     Yes， if the database is in ARCHIVELOG mode

    B

     Yes， if the database is in NOARCHIVELOG mode

    C

     No， the backup is not usable in any way

    D

     Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE


    正确答案： A
    解析： 暂无解析

  • 第9题：

    多选题
    Your company has a server named SRV1 that runs Windows Server 2008 R2. The default Print Services server role is installed on SRV1.The company wants to centralize printing on SRV1 for both UNIX and Windows users.You need to provide support to the UNIX users who print on SRV1.What are two possible ways to achieve this goal？（）
    A

    Install the Internet Printing role service on SRV1.

    B

    Install the Line Printer Daemon (LPD) Services role service on SRV1.

    C

    Configure the printers on SRV1 to use Line Printer Remote printing.

    D

    Install the File Services server role on SRV1 and activate the Services for Network File System role service.


    正确答案： C,B
    解析： 暂无解析

  • 第10题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and performtablespacerecovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


    正确答案： A
    解析： 暂无解析

  • 第11题：

    多选题
    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


    正确答案： G,F
    解析： 暂无解析

  • 第12题：

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

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

    正确答案:D

  • 第13题：

    Your company has a server named SRV1 that runs windows server 2008. The default print server role is installed on SRV1 the company wants to centralize printing on SRV1 for both UNIX and windows users. You need to provide support to the UNIX users who print on SRV1. What are two possible ways to achieve this goal? （）

    • A、Install the internet printing server role on SRV1.
    • B、Install the line printer daemon (LPD) services role service on SRV1.
    • C、Configure the printers on SRV1 to use line printer remote printing.
    • D、Install the file server role on SRV1 and activate the services for the NFS Role service option.

    正确答案:A,B

  • 第14题：

    Your company has a server named SRV1 that runs Windows Server 2008. The default Print Server role is installed on SRV1 The company wants to centralize printing on SRV1 for both UNIX and Windows users. You need to provide support to the UNIX users who print on SRV1. What are two possible ways to achieve this goal？（） 

    • A、 Install the Internet Printing server role on SRV1.
    • B、 Install the Line Printer Daemon （LPD） Services role service on SRV1
    • C、 Configure the printers on SRV1 to use Line Printer Remote printing
    • D、 Install the File Server role on SRV1 and activate the services for the NFS Role Service option.

    正确答案:A,B

  • 第15题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第16题：

    多选题
    Which of these recommendations should be followed before capturing a workload？（）
    A

    Make sure your replay database has the same structure as the capture database， except without data.

    B

    Make sure the replay and capture databases are similar in data content.

    C

    Perform a clean shutdown and restart of the capture database before beginning a workload capture.

    D

    Start the capture database in UNRESTRICTED mode， then start the capture.

    E

    Define inclusion and exclusion filters.


    正确答案： A,B
    解析： 暂无解析

  • 第17题：

    单选题
    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
    A

    flash back the database

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    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?（）
    A

    1

    B

    2 and 4

    C

    2 and 5

    D

    3 and 4

    E

    3 and 5


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）
    A

    the time when the last flashback operation in your database was performed

    B

    the time when the first flashback operation in your database was performed

    C

    a list of flashback operations performed in your database using SCN and time

    D

    the approximate time and the lowest system change number （SCN） to which you can flash back your database


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You work as a database administrator for Certkiller .com. 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 LOFIEL 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；


    正确答案： B
    解析： 暂无解析

相关内容