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

题目内容 (请给出正确答案)
单选题
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 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.

考题 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.

考题 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.

考题 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)

考题 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 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. 

考题 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.

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

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

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

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

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

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

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

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

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