单选题tony wants to create a duplicate of the video application. He wants to keep a version of the data on the same server as the production application but does not want any new documents or documents modifications to be replicated into his new database onc

第1题：

You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）

• A、Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.
• B、Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.
• C、Modify the format file to specify the same collation as the Dublin database. Import the table again.
• D、Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.

第2题：

tony wants to create a duplicate of the video application. He wants to keep a version of the data on the same server as the production application but does not want any new documents or documents modifications to be replicated into his new database once he creates it. Which one of the following should tony do to create his archive?（）

• A、create a new copy of the database
• B、create a replica of the database
• C、Use the windows explorer to create a copy of the database file.
• D、Create a replica copy of the database and disable replication on the database file.

第3题：

ompany.com has a Micro-Partitioned p5-570 4-way with six application partitions and two VIO servers. Each VIO server has been allocated 0.5 CPU and the application servers have been allocated 0.4 CPUs. The marketing department wants to deploy a new Web server to support the release of a product. The systems architect has recommended that the Web server will require a whole CPU. Which of the following should the technical specialist suggest to provide the most cost-effective deployment？（）

• A、Remove one application server partition and apply its CPU resources to the Web server.
• B、Reassign the CPU from one of the VIO servers and create the new partition.
• C、Add 0.6 CPU to one of the application servers and run the Web service with the application. 
• D、Reassign a total of 0.4 CPUs from the application servers and create a new partition with awhole CPU for new deployment.

第4题：

Marry wants to create a new application on his laptop that does not have any design elements in it. Which one of the following should he do to begin his process?（）

• A、 select file->Database->new and give it a filename of “blank.nsf” 
• B、 select file->Database->new,choose local as the server,and chose the blank template 
• C、 select file->Database->new,choose local as the server,and chose the default.ntf template 
• D、 select file->Database->new,give it a filename of “blank.nsf”,and chose the blank template 

第5题：

Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

• A、mount the new disk group in the ASM instance
• B、restart the ASM instance and the production database instance
• C、register the new disk groups in the production database instance
• D、restart the ASM instance without restarting the production database instance
• E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

第6题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. You want to make sure that the application is operative to any type of database.   What should you do？（）

• A、 Set the database driver name in the connection string of the application， and then the connection object as follows： DbConnection connection = new OdbcConnection（connectionString）；
• B、 Create the connection object as follows： DbProviderFactory factoryDbProviderFactories.GetFactory（databaseProviderName）； DbConnection connection =factory.CreateConnection（）；
• C、 Create the connection object as follows： DbProviderFactory factory = DbProviderFactories.GetFactory（"System.Data.Odbc"）； DbConnection connection = factory.CreateConnection（）；
• D、 Set the database driver name in the connection string of the application， and then the connection object as follows：DbConnection connection = new OleDbConnection（connectionString）；

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

An organization wants to collect an account number from a customer via IVR prompting. Then, using a keystroke macro, they want to pop the account number into the account number field in the agent's CRM desktop application. The keystroke macro will also initiate the CRM desktop application, executing a database lookup from the CRM Database server to retrieve the customer record. Assuming the organization wants the lowest cost solution,  what product does this organization need for this capability?（）

• A、IPCC Express Standard  
• B、IPCC Express Enhanced  
• C、IPCC Express Premium  
• D、IPCC Enterprise  
• E、IP IVR

第14题：

tony would like to make it easier for users of the video application to enter new doc using the “video form”, he’d like users to be able to create new “video” doc form within the view. Which one of the following should tony so to build this interface?（）

• A、create a view action that has the following formula：@command（[create]；”video”）
• B、create a form action that has the following formula：@command（[compose]；”video”）
• C、create a view action that has the following formula：@command（[compose]；”video”）
• D、create a database action that has the following formula：@command（[compose]；”video”）

第15题：

An application is upgraded and it has been determined that the AccessAgent no longer properly responds to the application. It is understood that for a certain amount of time both the current version and the upgraded version of the application will be used by the end-users. The executables for both versions are the same. What should be the next step？（）

• A、Open AccessStudio and change the existing AccessProfile to use only the new signatures for Windows， control IDs， or HTML elements.
• B、Open AccessStudio and create a new AccessProfile for the upgraded version and overwrite the existing AccessProfile on the IMS Server.
• C、Open AccessStudio and edit the existing AccessProfile by using new triggers/actions associated with the new signatures for Windows， control IDs， or HTML elements.
• D、Open AccessStudio and create a new AccessProfile for the upgraded version and upload it to the IMS Server so that two separate AccessProfiles may be used by the AccessAgent.

第16题：

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.

第17题：

A customer stores environmental settings in the deployment descriptors of an application. Whenever they promote the application version from testing to the production environment, they need to open the archive and modify the deployment descriptor. This process is against their security policy.    What approach should you recommend to leverage WebLogic features such that they do not have to modify the application archive for different environments?（）

• A、Keep environmental data in the global settings of domain and the application can read it from the domain where it runs.
• B、Keep environmental data in Deployment Plan XML files. It allows you to change parameters in the deployment descriptor without opening the archive file.
• C、Keep environmental data in the database because it is the most effective way of parametrizing the environment.  
• D、Keep archive in exploded format so the customer does not have to open the archive files.
• E、Eliminate all environmental settings from the application. There should not to be any environmental settings in the application. 

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：