多选题You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

多选题
You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()
A

More than one database is to be registered with the listener.

B

The users will connect the database by using the host naming method.

C

The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.

D

The database that is to be registered with the listener is configured in shared server mode.

E

The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.


参考解析

解析: 暂无解析

相关考题:

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?()A. Use Oracle Managed Files (OMF).B. Specify the SEED FILE_NAME_CONVERT clause.C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.D. Specify the DB_FILE_NAMECONVERT initialization parameter.E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A.Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B.Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C.Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D.Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

Which command do you use to generate a report of database incarnations?()  A、 list incarnation of databaseB、 report incarnation of databaseC、 list database incarnationD、 database incarnation listE、 report database incarnation

You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()A、More than one database is to be registered with the listener.B、The users will connect the database by using the host naming method.C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.D、The database that is to be registered with the listener is configured in shared server mode.E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data

You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups?()  A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?()A、Use Oracle Managed Files (OMF).B、Specify the SEED FILE_NAME_CONVERT clause.C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.D、Specify the DB_FILE_NAMECONVERT initialization parameter.E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data.

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A、use the external table populationB、use the Oracle Data Pump export and import utilityC、use the conventional path data load of SQL*Loader utilityD、use the direct path data load of Oracle export and import utility

You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are:  1:Oracle Universal Installer (OUI)  2:Database Configuration Assistant (DBCA)  3:Database Upgrade Assistant (DBUA)  4:Oracle Net Configuration Assistant  Which tools would you use for this installation()A、2B、3C、1 and 2D、3 and 4E、1,2,and 4

You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

You administer a SQL Server 2008 instance. You plan to deploy a third-party database application to the instance. The application uses stored procedures that are developed by using SQL CLR integration. The application must be configured to enable the EXTERNAL_ACCESS code access security setting. You need to ensure that the application is deployed to the instance without loss of functionality. What should you do first?()A、Replace read write non-static fields in the code with static fields.B、Replace read-only static fields in the code with read write static fields. C、Use the peverify.exe PEVerify tool to verify whether the code meets the type-safety requirements.D、Use the regasm.exe assembly registration tool to register the assembly on the server before deployment.

You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend?()A、 Use the bcp utility.B、 Use the dta utility.C、 Use the SQL Server Import and Export Wizard.D、 Attach each SQL Server database to SQL Azure.

Your virtual environment includes Windows Server 2008 R2 Hyper-V servers. You plan to deploy Microsoft Virtual Desktop Infrastructure. You plan to scale both static and dynamic deployments across several servers. You need to design a plan that supports static and dynamic deployments and that allows for capacity growth without outages. What should you include in your plan?()A、Use the Remote Desktop Connection Broker and failover clusteringB、Use the Remote Desktop Gateway and network load balancingC、Use network load balancing and failover clusteringD、Use DNS round-robin and network load balancing

Your network contains a single Active Directory site.   You plan to deploy 1,000 new computers that will run Windows 7 Enterprise. The new computers have Pre-boot Execution Environment (PXE) network adapters.   You need to plan the deployment of the new computers to meet the following requirements:  èSupport 50 simultaneous installations of Windows 7   èMinimize the impact of network operations during the deployment of the new computers   èMinimize the amount of time required to install Windows 7 on the new computers What should you include in your plan?()A、Deploy the Windows Deployment Services (WDS) server role. Configure the IP Helper tables on all  routers.  B、Deploy the Windows Deployment Services (WDS) server role. Configure each WDS server by using native mode.  C、Deploy the Windows Deployment Services (WDS) server role and the Transport Server feature.Configure the Transport Server to use a custom network profile.  D、Deploy the Windows Deployment Services (WDS) server role and the Transport Server feature. Configure the Transport Server to use a static multicast address range.

ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? () A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance.

You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?()A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.

You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()A、STARTB、RELOADC、RESTARTD、REFRESHE、START L1F、RELOAD L1G、RESTART L1H、REFRESH L1

单选题You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups?()A V$SYSSTATB V$SESSSTATC V$RSRC_PLAND V$RSRC_CONSUMER_GROUP

单选题You administer a SQL Server 2008 instance. You plan to deploy a third-party database application to the instance. The application uses stored procedures that are developed by using SQL CLR integration. The application must be configured to enable the EXTERNAL_ACCESS code access security setting. You need to ensure that the application is deployed to the instance without loss of functionality. What should you do first?()AReplace read write non-static fields in the code with static fields.BReplace read-only static fields in the code with read write static fields. CUse the peverify.exe PEVerify tool to verify whether the code meets the type-safety requirements.DUse the regasm.exe assembly registration tool to register the assembly on the server before deployment.

单选题In which situation would you use static database registration for a listener()Awhen multiple databases are to be registered with the listenerBwhen DBAs need to connect remotely to start up the database instanceCwhen users need to connect the database instance using the host naming methodDwhen the database instance that is to be registered with the listener is configured in shared server mode

单选题You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()ASTARTBRELOADCRESTARTDREFRESHESTART L1FRELOAD L1GRESTART L1HREFRESH L1

多选题You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?()AUse Oracle Managed Files (OMF).BSpecify the SEED FILE_NAME_CONVERT clause.CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.DSpecify the DB_FILE_NAMECONVERT initialization parameter.ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

单选题You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()Ato minimize plan regression due to the use of a new optimizer versionBto completely avoid the use of new plans generated by a new optimizer versionCto prevent plan capturing when the SQL statement is executed after the database upgradeDto keep the plan in the plan history so that it can be used when the older version of the optimizer is used

单选题You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are:  1:Oracle Universal Installer (OUI)  2:Database Configuration Assistant (DBCA)  3:Database Upgrade Assistant (DBUA)  4:Oracle Net Configuration Assistant  Which tools would you use for this installation()A2B3C1 and 2D3 and 4E1,2,and 4

单选题Which command do you use to generate a report of database incarnations?()A list incarnation of databaseB report incarnation of databaseC list database incarnationD database incarnation listE report database incarnation