单选题You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell> mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?()AIt exports tables with the most indexes first to assist with import speedsBIt ensures that unique indexes have no conflicts when the data is dumpedCIt orders by primary key to assist in speeding up importing to InnoDB tablesDIt must be specified so index data is dumped correctly when –on-create-info is used

单选题
You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell> mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?()
A

It exports tables with the most indexes first to assist with import speeds

B

It ensures that unique indexes have no conflicts when the data is dumped

C

It orders by primary key to assist in speeding up importing to InnoDB tables

D

It must be specified so index data is dumped correctly when  –on-create-info is used


参考解析

解析: 暂无解析

相关考题:

You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.The destination table is configured as shown in the exhibit.You want to load the data into the table as quickly as possible. What should you do?A.Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.B.Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.C.Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.D.Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.

You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server is configured as shown in the following table.You need to ensure that you can restore the server and all its data in the event of a complete system failure.You perform an Automated System Recovery (ASR) backup.What else should you backup? ()A.volume CB.volume DC.volume ED.the system state

Your network contains a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1 is configured as shown in the following table.A user named User1 belongs to the Helpdesk group and the Support group.You need to configure security to meet the following requirements:·Prevent User1 from changing files and folders in the Apps share.·Allow User1 to open and run applications in the Apps share.What should you do?()A. Onthe Apps share, assign User1 the Read share permission.B. On the Apps folder, deny User1 the Write NTFS permission.C. On the Apps folder, deny User1 the Modify NTFS permission.D. On the Apps folder, assign User1 the Read Execute NTFS permission.

Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?()A、Mysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';B、Shell> mysql –u root –p sakila sakila2013.sqlC、Shell> mysql import –u root –p sakila sakila2013.sqlD、Shell> mysql –u root -p –e 'use sakila; source sakila2013.sql'E、Shell> mysql –u root –p –silent < sakila2013.sql

You have 2 NTP servers in your network - 10.1.1.1 and 10.1.1.2. You want to configurationure a Ciscorouter to use 10.1.1.2 as its NTP server before falling back to 10.1.1.1. Which commands will you use toconfigurationure the router?()A、ntp server 10.1.1.1 ntp server 10.1.1.2B、ntp server 10.1.1.1 ntp server 10.1.1.2 primaryC、ntp server 10.1.1.1 ntp server 10.1.1.2 preferD、ntp server 10.1.1.1 fallback ntp server 10.1.1.2

Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()A、Start the server with the – innodb_recover_options option set to FORCEB、Start the server with the – innodb_force_recovery option set to a non-zero valueC、Start the server as usual, and then execute the REPAIR TABLE commandD、Start the server as usual, and then execute the CHECK TABLE command

You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell> mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?()A、It exports tables with the most indexes first to assist with import speedsB、It ensures that unique indexes have no conflicts when the data is dumpedC、It orders by primary key to assist in speeding up importing to InnoDB tablesD、It must be specified so index data is dumped correctly when –on-create-info is used

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?()A、— quickB、— skip-bufferC、— single-transactionD、— tab

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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.  So what action should you perform to achieve this goal?()A、You should recapture the workload by using the data collector.B、You should enable the XP_MSVER stored procedure on the local server.C、You should enable the XP_MSVER stored procedure on the remote serverD、You should recapture the workload to a trace file by using SQL Profiler.

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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? () A、You should use the Database Engine Tuning Advisor tool B、You should use the Windows System Monitor tool C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio

You work as an IT support specialist. Your job responsibilities include managing server storage. You aredesigning storage for a new application server. The application makes heavy use of temporary storage, andyou want to allocate three 20-GB disk drives to that storage. If excellent read and write performance is ahigh priority,and you also want to use as much available space as possible,which of the following volumetypes should you create?()A、Simple volumeB、Spanned volumeC、Mirrored volumeD、Striped volumeE、RAID-5 volume

You work as an administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed. A server named, ABC-SR13, has a Server Core Installation of Windows Server 2012 R2 installed. You are instructed to convert ABC-SR13’s installation to a Server with GUI installation. You want to use a Windows PowerShell cmdlet that uses Windows Update as a source.  Which of the following actions should you take?()A、You should consider making use of the Install-WindowsFeature Server-Gui-Mgmt-Infra,ServerGui-Shell –Restart cmdlet.B、You should consider making use of the Install- Install-WindowsFeature Server-Gui-MgmtInfra,Server-Gui-Shell –Restart –Source c:/mountdir/windows/winsxs cmdlet.C、You should consider making use of the Install- Uninstall-WindowsFeature Server-Gui-Shell -Remove cmdlet.D、You should consider making use of the Set-ExecutionPolicy cmdlet.

Your network consists of a single Active Directory domain named contoso.com. The functional level of the domain is Windows Server 2003. You have a file server named Server1 that is used to store users’ home folders and profiles. On Server1, you create a folder named D:/data/ and share the folder as UserData. You create a new user account named TemplateUser in Active Directory. You need to ensure that each user account you create by copying TemplateUser is configured to have a unique home folder stored in the UserData share. Which home folder path should you specify? ()A、D:///data/%homedrive%B、D:///data/%username%C、//server1/userdata/%homedrive%D、//server1/userdata/%username%

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.You must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?()  A、You should use the Database Engine Tuning Advisor. B、In Microsoft SQL Server Management Studio, you should create a maintenance plan C、You should use the SQL Server Configuration Manager D、In Microsoft SQL Server Management Studio, you should create a policy

You have a server named Server1 that runs Windows Server 2012 R2. Server1 has the Hyper-V  server role installed. You need to configure storage for a virtual machine to meet the following requirements:  (1)Support up to 3 TB of data on a single hard disk.  (2)Allocate disk space as needed.  (3)Use a portable storage format.  What should you configure?()A、A pass-through diskB、A fixed-size VHDC、A dynamically expanding VHDD、A fixed-size VHDXE、A dynamically expanding VHDX

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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? () A、You should use SQLServer:Buffer ManagerB、You should use SQLServer:Memory Manager C、You should use SQLServer:Databases D、You should use SQLServer:Access Methods

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 n On-Line Analytical Processing (OLAP) database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below, which compression technology should you use?()A、You should use row compression B、You should use page compression C、You should use backup compression D、You should use windows NTFS file system compression

单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()AStart the server with the – innodb_recover_options option set to FORCEBStart the server with the – innodb_force_recovery option set to a non-zero valueCStart the server as usual, and then execute the REPAIR TABLE commandDStart the server as usual, and then execute the CHECK TABLE command

单选题You have 2 NTP servers in your network - 10.1.1.1 and 10.1.1.2. You want to configurationure a Ciscorouter to use 10.1.1.2 as its NTP server before falling back to 10.1.1.1. Which commands will you use toconfigurationure the router?()Antp server 10.1.1.1 ntp server 10.1.1.2Bntp server 10.1.1.1 ntp server 10.1.1.2 primaryCntp server 10.1.1.1 ntp server 10.1.1.2 preferDntp server 10.1.1.1 fallback ntp server 10.1.1.2

单选题Your network consists of a single Active Directory domain named contoso.com. The functional level of the domain is Windows Server 2003. You have a file server named Server1 that is used to store users’ home folders and profiles. On Server1, you create a folder named D:/data/ and share the folder as UserData. You create a new user account named TemplateUser in Active Directory. You need to ensure that each user account you create by copying TemplateUser is configured to have a unique home folder stored in the UserData share. Which home folder path should you specify? ()AD:///data/%homedrive%BD:///data/%username%C//server1/userdata/%homedrive%D//server1/userdata/%username%

单选题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.You must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?()AYou should use the Database Engine Tuning Advisor. BIn Microsoft SQL Server Management Studio, you should create a maintenance plan CYou should use the SQL Server Configuration Manager DIn Microsoft SQL Server Management Studio, you should create a policy

单选题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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.  So what action should you perform to achieve this goal?()AYou should recapture the workload by using the data collector.BYou should enable the XP_MSVER stored procedure on the local server.CYou should enable the XP_MSVER stored procedure on the remote serverDYou should recapture the workload to a trace file by using SQL Profiler.

单选题You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?()A— quickB— skip-bufferC— single-transactionD— tab

单选题You work as an administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed. A server named, ABC-SR13, has a Server Core Installation of Windows Server 2012 R2 installed. You are instructed to convert ABC-SR13’s installation to a Server with GUI installation. You want to use a Windows PowerShell cmdlet that uses Windows Update as a source.  Which of the following actions should you take?()AYou should consider making use of the Install-WindowsFeature Server-Gui-Mgmt-Infra,ServerGui-Shell –Restart cmdlet.BYou should consider making use of the Install- Install-WindowsFeature Server-Gui-MgmtInfra,Server-Gui-Shell –Restart –Source c:/mountdir/windows/winsxs cmdlet.CYou should consider making use of the Install- Uninstall-WindowsFeature Server-Gui-Shell -Remove cmdlet.DYou should consider making use of the Set-ExecutionPolicy cmdlet.

单选题You work as an IT support specialist. Your job responsibilities include managing server storage. You aredesigning storage for a new application server. The application makes heavy use of temporary storage, andyou want to allocate three 20-GB disk drives to that storage. If excellent read and write performance is ahigh priority,and you also want to use as much available space as possible,which of the following volumetypes should you create?()ASimple volumeBSpanned volumeCMirrored volumeDStriped volumeERAID-5 volume

单选题Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? ()AModify the NTFS permissions on the Data folder.BModify the share permissions on the Data share.CAdd the domain administrator to the local Administrator’s group on Server1.DMove the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

单选题You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell> mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?()AIt exports tables with the most indexes first to assist with import speedsBIt ensures that unique indexes have no conflicts when the data is dumpedCIt orders by primary key to assist in speeding up importing to InnoDB tablesDIt must be specified so index data is dumped correctly when –on-create-info is used