单选题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?()A1B2 and 4C2 and 5D3 and 4E3 and 5
单选题
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
参考解析
解析:
暂无解析
相关考题:
The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()A. statistics recommendationsB. SQL profile recommendationsC. index-related recommendationsD. restructuring of SQL recommendations
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
It can be inferred that eBay ______.( )[A] has a prototype service[B] has similar ads service like Google[C] is featured by its auction listings[D] offers a searchable database of free listings
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
In your database,the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first?() A、 authentication by password fileB、 authentication by using certificates over SSLC、 authentication by using the Oracle Internet DirectoryD、 authentication by using the local OS of the database server
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 modeB、 Yes, if the database is in NOARCHIVELOG modeC、 No, the backup is not usable in any wayD、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
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 allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
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.
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.
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 SRV1C、 Configure the printers on SRV1 to use Line Printer Remote printingD、 Install the File Server role on SRV1 and activate the services for the NFS Role Service option.
单选题You are validating the configuration of your SRX Series device and see the output shown below. What does this indicate?()A The SRX Series device has been configured correctly, the Junos Pulse Access Control Service is reachable on the network, and the SRX Series device is waiting to receive the initial connection from the Junos Pulse Access Control Service.B The SRX Series device has confirmed that the Junos Pulse Access Control Service is configured and is reachable on the network, the SRX Series device is waiting to receive the connection from the Junos Pulse Access Control Service, and all that remains to be accomplished is to configure the SRX Series device.C The SRX Series device is configured correctly and connected to the Junos Pulse Access Control Service. All that remains to be done to complete the configuration is to configure the SRX Series device on the Junos Pulse Access Control Service.D Both the Junos Pulse Access Control Service and the SRX Series device are configured correctly and communicating with each other.
单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()A statistics recommendationsB SQL profile recommendationsC index-related recommendationsD restructuring of SQL recommendations
单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()Astatistics recommendationsBSQL profile recommendationsCindex-related recommendationsDrestructuring of SQL recommendations
单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()AWhen you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.BWhen a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.CWhen a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.DWhen you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
单选题You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command: LSNRCTLSTATUS listener1 Which information will NOT be displayed when you issue the above command?()A whether the password is set in the listener or a file or notB the number of client connections the service handler has refusedC the information will be displayed whether the instance can accept connections or notD the protocol addresses on which the listener is configured to listen
单选题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
单选题The listener uses dynamic information about the database and instance it has received through service registration before using information statically configured. Some services such as heterogeneous services and external procedures require the use of information statically configured within listener.ora. In order to support this, which tool could be used to configure the listener statically?()AOracle Net ManagerBListener Control UtilityCOracle Net Control UtilityDOracle Net Configuration Assistant
多选题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?()AInstall the Internet Printing role service on SRV1.BInstall the Line Printer Daemon (LPD) Services role service on SRV1.CConfigure the printers on SRV1 to use Line Printer Remote printing.DInstall the File Services server role on SRV1 and activate the Services for Network File System role service.
单选题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 exisiting server named SRV2 in the main office. You need to ensure SRV1 reflects the change immediately. What should you do?()A Restart the DNS Server service on DC1B Run the dnscmd command by using the /zonerefresh option on DC1C Run the dnscmd command by using the /zonerefresh option on SRV1D Set the refresh interval to 10minutes on the Start Of Authority (SOA) record.
单选题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?()ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file, just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery