网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You have created an Oracle 10g database named SALES, which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option?()

  • A、 The index can be changed from NOLOGGING to LOGGING
  • B、 The index cannot be recovered even in the ARCHIVELOG mode.
  • C、 The index can only be created if the base table is created with the NOLOGGING option.
  • D、 The index can be recovered if you perform a backup after the CREATE INDEX statement.

参考答案

更多 “You have created an Oracle 10g database named SALES, which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option?()A、 The index can be changed from NOLOGGING to LOGGINGB、 The index cannot be recovered even in the ARCHIVELOG mode.C、 The index can only be created if the base table is created with the NOLOGGING option.D、 The index can be recovered if you perform a backup after the CREATE INDEX statement.” 相关考题
考题 You have recently completely creating a new application for Certkiller .com.This new application has to load an instance of the Inventory class from a large file named Inventory.dat.You need to ensure that the application executes the loading process in as little time as possible.What should you do?()A.B.C.D.

考题 You are using windows installer to deploy an application to 750 Windows 2000 Professional computers on your network. The network includes organizational unit (OU) named sales. A Group Policy object (GPO) is created for the Sales OU. You want to deploy that application in such a way that the shortcuts of that application should be created on the used desktop as well as in start-menu. When a user first click on the shortcut or try to open any file whose extension is associated with that application, then that application should automatically install on the computer. What should you do to accomplish this task?()A、Using GPO, publish that application at user levelB、Using GPO, assign that application at the user levelC、Using GPO, publish that application at computer levelD、Using GPO, assign that application at the computer level.

考题 You are using windows installer to deploy an application to 750 Windows 2000 Professional computers on your network. The network includes organizational unit (OU) named sales. A Group Policy object (GPO) is created for the Sales OU. The software deployment of the application is successful. Now, you want to install that application in the customized form. What should you do? ()A、Repackage and re-deploy the application’s .msi file to the Sales OUB、Re-deploy the application’s .mst file to the Sales OU.C、Re-deploy the application by using the Group Policy object (GPO for the Sales OU)D、Restart Windows Installer service on the ten computers.

考题 You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers,configuring Windows Server 2008 Terminal services and network application services, and configuring aweb services infrastructure. There is a server that runs Windows Server 2008. The Terminal Services server role is installed on theserver. You have a new application deployed on the server. The application creates files that have anextension of .xyz. You have to make sure that users are able to launch the remote application from theircomputers by double-clicking a file that has the .xyz extension. What action should you perform?()A、The Remote Desktop Connection Client on the users’ computers should be configured to point to theserver.B、Configure the application as a published application You should use a Remote Desktop Program file.C、Configure the application as a published application by using a Microsoft Windows Installer packagefile.D、Configure the application as a published application by using a Terminal Server Web Access Web site.

考题 You are the administrator for ExamSheet.net's network.  You are using Windows Installer to deploy an application to 750 Windows 2000 Professional computers on your network. The network includes an organizational unit (OU) named Sales. A Group Policy object (GPO) is created for the Sales OU.  The software deployment of the application is unsuccessful. During the deployment, some users in the Sales OU report that the installation is aborting with random errors midway through the installation process. The remaining users in the Sales OU report that the software is installing, but is giving them general protection fault errors. You want to successfully deploy the software What should you do? ()A、Repackage and redeploy the application’s .msi file to the Sales OU.B、Repackage and redeploy the application’s .mst file to the Sales OU.C、Redeploy the application by using the Group Policy object (GPO) for the Sales OU.D、Restart Windows Installer on all computers in the Sales OU. Then redeploy the application’s .zap file to the Sales OU.

考题 Your company has an Active Directory forest. The company has three locations. Each location   has an organizational unit and a child organizational unit named Sales.   The Sales organizational unit contains all users and computers of the sales department. The  company plans to deploy a Microsoft Office 2007 application on all computers within the three  Sales organizational units.     You need to ensure that the Office 2007 application is installed only on the computers in the  Sales organizational units.     What should you do()A、Create a Group Policy Object (GPO) named SalesAPP GPO. Configure the GPO to assign the application to the cB、Create a Group Policy Object (GPO) named SalesAPP GPO. Configure the GPO to assign the application to the usC、Create a Group Policy Object (GPO) named SalesAPP GPO. Configure the GPO to publish the application to the uD、Create a Group Policy Object (GPO) named SalesAPP GPO. Configure the GPO to assign the application to the co

考题 You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.

考题 In your datawarehousing application, you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins, resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query?()A、hash clustersB、index clustersC、partitioned tablesD、index­organized table (IOT)

考题 Your company has an Active Directory forest. The forest includes organizational units corresponding to the following four locations.  London      Chicago      New York     Madrid  Each location has a child organizational unit named Sales. The Sales organizational unit contains all the users and computers from the sales department.  The offices in London, Chicago, and New York are connected by T1 connections. The office in Madrid is connected by a 256-Kbps ISDN connection.  You need to install an application on all the computers in the sales department.  Which two actions should you perform()A、Disable the slow link detection setting in the Group Policy Object (GPO).B、Configure the slow link detection threshold setting to 1,544 Kbps (T1) in the Group Policy Object GPO).C、Create a Group Policy Object (GPO) named Officelnstall that assigns the application to users. Link the GPO to each Sales organizational unit.D、Create a Group Policy Object (GPO) named Officelnstall that assigns the application to the computers.Link the GPO to each Sales organizational unit.

考题 You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration.  Which Resource Governor component should you configure?()  A、The workload group which is used by default B、The workload group which is used by the finance application C、The classifier function which identifies the finance application D、The workload group which is used by the manufacturing application 

考题 Your company has an Active Directory forest. Each branch office has an organizational unit and a  child organizational unit named Sales.     The Sales organizational unit contains all users and computers of the sales department.     You need to install a Microsoft Office 2007 application only on the computers in the Sales  organizational unit.   You create a GPO named SalesApp GPO.     What should you do next()A、Configure the GPO to assign the application to the computer account. Link the SalesAPP GPO to the domain.B、Configure the GPO to assign the application to the user account. Link the SalesAPP GPO to the Sales organizationC、Configure the GPO to publish the application to the user account. Link the SalesAPP GPO to the Sales organizationD、Configure the GPO to assign the application to the computer account. Link the SalesAPP GPO to the Sales organiz

考题 You are using windows installer to deploy an application to 750 Windows 2000 Professional computers on your network. The network includes organizational unit (OU) named sales. A Group Policy object (GPO) is created for the Sales OU. The application is successfully installed on the 740 out of 750 computers. The ten computers are unable to install the application what should you do to install that application on all the computers in the sales OU.What should you do?()A、Repackage and re-deploy the application's .msi file to the Sales OUB、Repackage and re-deploy the application's .mst file to the Sales OUC、Re-deploy the application by using the Group Policy object (GPO for the Sales OU)D、Restart Windows Installer service on the ten computers.

考题 You have a single Active Directory directory service domain. All users are located in an organizational unit (OU) named ContosoUsers. All client computer accounts are located in an OU named ContosoComputers. You need to deploy a new application to all users. The application shortcut must be available the next time the users log on. What are two possible ways to achieve this goal?()A、 Create a Group Policy object (GPO) to publish the application. Link the GPO to the ContosoComputers OU.B、 Create a Group Policy object (GPO) to assign the application. Link the GPO to the ContosoComputers OU.C、 Create a Group Policy object (GPO) to publish the application. Link the GPO to the ContosoUsers OU. D、 Create a Group Policy object (GPO) to assign the application. Link the GPO to the ContosoUsers OU.

考题 You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003. A server named TestKing2 functions as an application server. Users in the TestKing marketing department use an application on TestKing2 to analyze data. The application produces a high volume of disk activity. You give access to 15 new users for the application on TestKing2. Users in the TestKing marketing department report unacceptable delays when they use the application during periods of peak activity. You use System Monitor to analyze the performance of TestKing2. You need to ensure that TestKing2 can support the new users. Which counter should you monitor?()A、The % Disk Time counter for the PhysicalDisk performance objectB、The Current Disk Queue Length counter for the PhysicalDisk performance objectC、The Free Megabytes counter for the LogicalDisk performance objectD、The Disk Transfers/sec counter for the LogicalDisk performance object

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1, and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you.  So what action should you perform to achieve this goal?()  A、All the SQL Server logins of the application developers have to be added to a fixed server role. B、All the database users of the application developers have to be added to a fixed database role C、All SQL Server logins of the application developers should be given the appropriate server-level permissions. D、All database users of the application developers should be given the appropriate database-level permissions. 

考题 Your company has an Active Directory forest. The forest includes organizational units  corresponding to the following four locations:     - London  - Chicago  - New York  - Madrid   Each location has a child organizational unit named Sales. The Sales organizational unit contains  all the users and computers from the sales department.     The offices in London, Chicago, and New York are connected by T1 connections. The office in  Madrid is connected by a 256-Kbps ISDN connection.     You need to install an application on all the computers in the sales department.     Which two actions should you perform()A、Disable the slow link detection setting in the Group Policy Object (GPO).B、Configure the slow link detection threshold setting to 1,544 Kbps (T1) in the Group Policy Object (GPO).C、Create a Group Policy Object (GPO) named OfficeInstall that assigns the application to users. Link the GPO to eacD、Create a Group Policy Object (GPO) named OfficeInstall that assigns the application to the computers. Link the GP

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized, and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor, and the new OLE DB driver will be utilized when the application database is queried. According the company requirements, the connections between the SQL Server database and the application database is prohibited, except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal?()A、To achieve the goal, a Linked Server connection should be configured to the application database.B、To achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.C、To achieve the goal, a Remote Server connection to the application database should be configured.D、To achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.

考题 You are using windows installer to deploy an application to 750 Windows 2000 Professional computers on your network. The network includes organizational unit (OU) named sales. A Group Policy object (GPO) is created for the Sales OU. The software deployment of the application is unsuccessful. During the deployment, some users in the Sales OU report that the installation is aborting with random errors midway through the installation process. The remaining users in the Sales OU report that the software is installing, but is giving them general protection fault errors. What should you do?()A、Repackage and re-deploy the application's .msi file to the Sales OUB、Repackage and re-deploy the application's .mst file to the Sales OUC、Re-deploy the application by using the Group Policy object (GPO for the Sales OU)D、Restart Windows Installer on all computers in the Sales OU. Then re-deploy the application's .zap file to the sales OU. 

考题 Your network consists of a single Active Directory domain. All domain controllers run Windows Server 2008 R2. All client computers run Windows 7. All user accounts are stored in an organizational unit (OU) named Staff. All client computer accounts are stored in an OU named Clients.  You plan to deploy a new application. You need to ensure that the application deployment meets the following requirements: èUsers must access the application from an icon on the Start menu. èThe application must be available to remote users when they are offline. What should you do?()A、Publish the application to users in the Staff OU.B、Publish the application to users in the Clients OU.C、Assign the application to computers in the Staff OU.D、Assign the application to computers in the Clients OU.

考题 单选题You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A The trace fileB The fixed viewsC The data dictionary viewsD The operating system log fieldsE The dynamic performance views.

考题 单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration.  Which Resource Governor component should you configure?()A The workload group which is used by default B The workload group which is used by the finance application C The classifier function which identifies the finance application D The workload group which is used by the manufacturing application