多选题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?（）AMysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell＞ mysql –u root –p sakila sakila2013.sqlCShell＞ mysql import –u root –p sakila sakila2013.sqlDShell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell＞ mysql –u root –p –silent ＜ sakila2013.sql
多选题
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.sql
C
Shell＞ mysql import –u root –p sakila sakila2013.sql
D
Shell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql'
E
Shell＞ mysql –u root –p –silent ＜ sakila2013.sql
参考解析
解析：
暂无解析
相关考题：
You are granted the CREATE VIEW privilege. What does this allow you to do? () A. Create a table view.B. Create a view in any schema.C. Create a view in your schema.D. Create a sequence view in any schema.E. Create a view that is accessible by everyone.F. Create a view only of it is based on tables that you created.
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 appsShell＞ 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 appsWhat 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
What are three facts about backups with mysqldump?() A.Can back up a remote database serverB.Allow a consistent backup to be takenC.Are always faster to restore than binary backupsD.Are able to back up specific items within a databaseE.Create automatically compressed backupsF.Will lock all storage engines for duration of backup
Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sqlWhich 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
下列SQL的数据定义语句组中，哪一组是正确的？A．CREATE SCHEMA...，DROP SCHEMA…，ALTER SCHEMA…B．CREATE TABLE......，DROP TABLE....，ALTER TABLE....C．CREATE VIEW..:，DROP VIEW...，ALTER VIEW…D．CREATE INDEX...，DROP INDEX…，ALTER INDEX…
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 are granted the CREATE VIEW privilege. What does this allow you to do?（）A、Create a table view.B、Create a view in any schema.C、Create a view in your schema.D、Create a sequence view in any schema.E、Create a view that is accessible by everyone.F、Create a view only of it is based on tables that you created.
You are the network administrator for TestKing. You manage a Windows Server 2003 computer named TestKing4 that functions as an application server. TestKing4 will be used for development during the next 30 days. You need to back up all data on TestKing4 every day for the next 30 days. You need to automate the backups of TestKing4 to meet these business requirements. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）A、Create a scheduled backup job as a normal backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.B、Create a scheduled backup job as a daily backup. Set the start date of the job for today, and set the end date for 30 days from today.C、Create a scheduled backup job as a copy backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.D、Create a scheduled backup job as a normal backup. Set the start date of the job for today, and set the end date for 30 days from today.
A p5 595 does not have any device connected to it for backup. What AIX method should be used to backup each of the LPAR environments and have a quick recovery path?（）A、Use savevg and copy to an NFS filesystemB、Create a mksysb on an NFS exported filesystemC、Use tar to copy system over network with a pipeD、Create mksysb on an NFS exported NIM filesystem
A cluster administrator wants to create a snapshot backup of the cluster. Which smit menu can be used to dothis？（）A、Extended ConfigurationB、System Management （C-SPOC）C、Problem Determination ToolsD、Initialization and Standard Configuration
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）A、The data file cannot be recovered.B、The date file can be restored from theSYSTEMauto backup.C、Take thetablespaceoffline，drop，kand re-create it.D、Recovery Manager （RMAN） is used to recover the data file.E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)A、A single SQL statement provided by a userB、An existing SQL Tuning Set (STS)C、A preprocessed Database Replay workloadD、A schema nameE、SQL statement identified in EM as using excessive resources
You perform a backup using the following BACKUP command： RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE； Which statement is true of this command？（） A、 A different procedure is required to restore a database from compressed backupsB、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.C、 Using this command to create backups minimizes the bandwidth consumedD、 Using this command to create backups improves the performance of the backup process
Which of the following cannot be used as input to the SQL Tuning Advisor？（）A、 A single SQL statement provided by a userB、 An existing SQL Tuning Set （STS）C、 A preprocessed Database Replay workloadD、 A schema nameE、 SQL statement identified in EM as using excessive resources
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
What are three facts about backups with mysqldump?（）A、Can back up a remote database serverB、Allow a consistent backup to be takenC、Are always faster to restore than binary backupsD、Are able to back up specific items within a databaseE、Create automatically compressed backupsF、Will lock all storage engines for duration of backup
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.
Your network contains a single Active Directory domain. You need to create an Active Directory Domain Services snapshot. What should you do（）A、Use the Ldp tool.B、Use the NTDSUtil tool.C、Use the Wbadmin tool.D、From Windows Server Backup， perform a full backup.
单选题Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）AAn error is generated.BYou will have two identical tables in the HR schema with different names.CYou create a table called employees in the HR schema based on you EMP table.DYou create an alternative name for the employees table in the HR schema in your own schema.
单选题Your network consists of a single Active Directory domain. You install a new backup program. The backup program requires a service account. You create a service account in the domain. You need to ensure that the service account can back up all member servers and client computers in the domain. You must ensure that the service account cannot be used to restore files and folders. What should you do?（）AAdd the service account to the domain Backup Operators group.BAdd the service account to the Backup Operators group on every server and every client computer.CAssign the Back up files and directories user right by using a Group Policy object (GPO).DAssign the Impersonate a client after authentication user right by using a Group Policy object (GPO).
单选题You perform a backup using the following BACKUP command: RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?（）AA different procedure is required to restore a database from compressed backupsBThe AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.CUsing this command to create backups minimizes the bandwidth consumedDUsing this command to create backups improves the performance of the backup process
单选题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
单选题The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）AThe data file cannot be recovered.BThe date file can be restored from the SYSTEM auto backup.CTake thetablespaceoffline，drop，kand re-create it.DRecovery Manager （RMAN） is used to recover the data file.EThe ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
单选题Your network consists of a single Active Directory domain. The functional level of the forest is Windows Server 2008. You need to create multiple password policies for users in your domain. What should you do（）AFrom the Schema snap-in， create multiple class schema objects.BFrom the ADSI Edit snap-in， create multiple Password Setting objects.CFrom the Security Configuration Wizard， create multiple security policies.DFrom the Group Policy Management snap-in， create multiple Group Policy objects.
单选题Your network consists of a single Active Directory domain. The functional level of the forest is Windows Server 2008 R2. You need to create multiple password policies for users in your domain. What should you do（）AFrom the Active Directory Schema snap-in， create multiple class schema objects.BFrom the ADSI Edit snap-in， create multiple Password Setting objects.CFrom the Security Configuration Wizard， create multiple security policies.DFrom the Group Policy Management snap-in， create multiple Group Policy objects.
单选题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
多选题Which of the following cannot be used as input to the SQL Tuning Advisor？（）AA single SQL statement provided by a userBAn existing SQL Tuning Set （STS）CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources