单选题Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?（）AALTER DATABASE Sales MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)BALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)CEXEC sys.sp_configure 'fill factor (%)', '60'DUPDATE STATISTICS Sales.Sales History(Products) WITH FULLSCAN, NORECOMPUTE
单选题
Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?（）
A
ALTER DATABASE Sales MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)
B
ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)
C
EXEC sys.sp_configure 'fill factor (%)', '60'
D
UPDATE STATISTICS Sales.Sales History(Products) WITH FULLSCAN, NORECOMPUTE
参考解析
解析：
暂无解析
相关考题：
You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?A．Increase the maximum file size of Sales_Data to 1,500MB.B．Use the DBCC SHRINKDATABASE statement.C．Set automatic file growth to 10 percent.D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.
Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use?（）A.ALTERDATABASESalesMODIFYFILE(NAME=Sales dat3,SIZE=10GB)B.ALTERINDEXALLONSales.Sales HistoryREBUILDWITH(FILLFACTOR=60)C.EXECsys.sp_configure‘fillfactor(%)‘,‘60‘D.UPDATESTATISTICSSales.Sales History(Products)WITHFULLSCAN,NORECOMPUTE
You work as the Exchange administrator at Company.com.The Company.com network contains an Exchange Server 2010 Organization.You are responsible for managing the Exchange network for Company.com.the Company.com network contains two mailbox servers named - ex01 and -ex02 as well as a mailbox database named -ex03.-ex01 and -ex02 are members of a database availability group named tkdag and contain a copy of -ex03.during the course of the week you receive an instruction from the cio to remove -ex03 from -ex01.What should you do？（）A、Your best option would be to right-click the database copy from the Exchange Management Console （EMC）.Thereafter you should select Remove.B、your best option would be to run clean-mailboxdatabase -identity -ex03 from the exchange management shell.C、Your best option would be to right-click TKDAG from the Exchange Management Console （EMC）.Then the Manage Database Availability Group Membership should be selected thereafter -ex01 should be removed from the list and manage clicked.D、your best option would be to run remove-mailboxdatabase -identity -ex03/-ex01 from the exchange management shell.
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（） A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）A、The command must be issued in MOUNT state.B、The command succeeds only if the data file is offline.C、The command must be issued when the database is in the archivelog mode.D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
Your company has an Active Directory domain that has an organizational unit named Sales. The Sales organizational unit contains two global security groups named sales managers and sales executives. You need to apply desktop restrictions to the sales executives group. You must not apply these desktop restrictions to the sales managers group. You create a GPO named DesktopLockdown and link it to the Sales organizational unit. What should you do next（）A、Configure the Deny Apply Group Policy permission for the sales managers on the DesktopLockdown GPO.B、Configure the Deny Apply Group Policy permission for the sales executives on the DesktopLockdown GPO.C、Configure the Deny Apply Group Policy permission for Authenticated Users on the DesktopLockdown GPO.D、Configure the Allow Apply Group Policy permission for Authenticated Users on the DesktopLockdown GPO.
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
Your network contains an Active Directory domain named contoso.com. You plan to deploy a child domain named sales.contoso.com. The domain controllers in sales.contoso.com will be DNS servers for sales.contoso.com. You need to ensure that users in contoso.com can connect to servers in sales.contoso.com by using fully qualified domain names （FQDNs）. What should you do（）A、Create a DNS forwarder.B、Create a DNS delegation.C、Configure root hint servers.D、Configure an alternate DNS server on all client 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 user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.
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 rganizational 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 computer account. Link the SalesAPP GPO to the domain.B、Create a Group Policy Object （GPO） named SalesAPP GPO. Configure the GPO to assign the application to the user account. Link the SalesAPP GPO to the Sales organizational unit in each location.C、Create a Group Policy Object （GPO） named SalesAPP GPO. Configure the GPO to publish the application to the user account. Link the SalesAPP GPO to the Sales organizational unit in each location.D、Create a Group Policy Object （GPO） named SalesAPP GPO. Configure the GPO to assign the application to the computer account. Link the SalesAPP GPO to the Sales organizational unit in each location.
You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory， but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources. What should you do？（）A、Design a report for Susan that includes two data regions. One data region is used for summary sales data. The other data region is used for the detailed sales data for each sales representative. Then， design a report for Joe that displays the detailed sales data.B、Design two reports for Susan. One report includes the territory information， and one report includes the detailed sales data. Then， design a report for Joe that displays the detailed sales data for his territories.C、Design a report for Susan that includes the territory information. Then， design a report for Joe that includes detailed sales data for his territories. Finally， configure Susans report so that it includes the data in Joes report.D、Design a parameterized report for Susan that includes all territory information. Then， design a linked report for Joe that links to Susans report.
You work as the exchange administrator at company.com.the company.com network contains an exchange server 2010 organization.you are responsible for managing the exchange network for company.com.the company.com network contains two mailbox servers named -ex01 and -ex02 as well as a mailbox database named -ex03.-ex01 and -ex02 are members of a database availability group named tkdag and contain a copy of -ex03.during the course of the week you receive an instruction from the cio to remove the -ex03 mailbox database from -ex01.what should you do？（）A、your best option would be to use the exchange management console （emc） and then select the remove option on a right-click of the -ex03 database copy on -ex01.B、your best option would be to run clean-mail box database -identity -ex03 on the exchange management shell.C、your best option would be to use the exchange management console （emc） and then select the manage database availability group membership on a right-click on tkdag then you can remove -ex01 from the list.D、your best option would be to run remove-mail box database -identity -ex03/-ex01 from the exchange management shell.
Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?（）A、ALTER DATABASE Sales MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)B、ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)C、EXEC sys.sp_configure 'fill factor (%)', '60'D、UPDATE STATISTICS Sales.Sales History(Products) WITH FULLSCAN, NORECOMPUTE
单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）AOne tablespace has only one datafileBMany tablespaces can share one datafileCOne tablespace can have many datafilesDOne datafile can contain many tablespaces
单选题You are responsible for importing data into SQL Server 2005 databases.Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons.You need to import the files into the sales database. What should you do？（）ACreate a custom format file， specifying a semicolon as the row terminator.BUse the bcp command， specifying a semicolon as the field terminator.CUse the bcp command with the default arguments.DUse the BULK INSERT statement with the default arguments.
单选题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（）ACreate a Group Policy Object （GPO） named SalesAPP GPO. Configure the GPO to assign the application to the cBCreate a Group Policy Object （GPO） named SalesAPP GPO. Configure the GPO to assign the application to the usCCreate a Group Policy Object （GPO） named SalesAPP GPO. Configure the GPO to publish the application to the uDCreate a Group Policy Object （GPO） named SalesAPP GPO. Configure the GPO to assign the application to the co
单选题You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）A Rebuild the index.B Coalesce the index.C Drop and re-create the index in the new tablespace.D Relocate the index using the ALTER INDEX...MOVE statement.
单选题You work in a company which is named Wiikigo Corp. The company 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 Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? （）AServiceGreatUser should be added to the appropriate fixed database roles. BYou should assign the appropriate object-level permissions to ServiceGreatUser CYou should assign the appropriate server-level permissions to ServiceGreatLogin DYou should assign the appropriate database-level permissions to ServiceGreatUser
单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）AUser processBServer processCSystem Monitor (SMON)DProcess Monitor (PMON)ECheckpoint process (CKPT)
单选题Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）A The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
单选题Your network contains a Windows Server Update Services (WSUS) server.You have an organizational unit (OU) named Sales. The Sales OU contains all of the computer objects for the sales department. You enable client-side targeting for the Sales OU and set the target group name to Sales-Computers.You restart a sales computer.You discover that the computer is not added to the Sales-Computer computer group in WSUS.You need to ensure that all sales computers are added to the Sales-Computers group. Which options should you configure?（）AAutomatic ApprovalsBComputersCPersonalizationDProducts and Classifications
单选题You are the administrator of your company's network. You want to configure a Security Policy for the Windows 2000 Professional Computers that are in the sales department. On one of the computers, you use Security Templates to configure the Security Policy based on the desired security settings. You then export those settings to an .inf file that will be used on all of the Computers in the sales department. You want to configure each Computer to have a customized Security Policy. What steps should you follow in order to achieve your goal?（）AUse Secedit.exe to import the security settings from the .inf file to the computers in the sales department.BUse a text editor to change the default security settings to the desired security settings. Then export those settings to the Computers in the sales department.CCreate an organizational unit （OU） named Sales. Add the users in the sales department to the Sales OU. Then apply the security template to the users in the Sales OU.DCreate an organizational unit （OU） named Sales. Add the computers in the sales department to the Sales OU. Then apply the security template to computers in the Sales OU.
单选题Your Windows 2000 Professional computer contains a single hard disk configured as a single partition. You want to move a folder named Sales under a folder named Corp on your computer. You want the files in the Sales folder to remain compressed after moving the folder. You want the files in the Corp folder to remain uncompressed. You want to ensure that the files are recoverable in case of any disk problems. You also want to move the files with the least amount of administrative effort. What should you do？（）ACopy the Sales folder to the Corp folder. Do nothing further.BBackup the Sales folder. Move the Sales folder to the Corp folder.CCompress the Corp folder. Then copy the Sales folder to the Corp folder.DMove the Sales folder to a second computer. Then move the Sales folder to the Corp folder.
单选题You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）AThe command must be issued in MOUNT state.BThe command succeeds only if the data file is offline.CThe command must be issued when the database is in the archivelog mode.DThe command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
单选题You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）AUpdate the view to use an outer join between the Customers and Sales tables.BCreate a clustered index on the v CustomerSales view.CCreate two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.DCreate a stored procedure for the business analysts that uses the v CustomerSales view.