多选题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 'sakila2

题目
多选题
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

相似考题

1.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

2. 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

3. In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;A、$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sqlB、Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'C、$ mysql – u root – p – h localhost test ＜ /tmp/t1.sqlD、Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1E、$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

4.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

参考答案和解析
正确答案： E,D
解析： 暂无解析
更多“多选题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 'sakila201”相关问题

  • 第1题：

    SQ L*Loader is a utility that can perform which two tasks？（）

    • A、Load data from a disk， tape， or named pipes.
    • B、Load data into an Oracle database using DML statements.
    • C、Extract， reorganize， and insert data within an Oracle database.
    • D、Load data from external files into tables in an Oracle database.
    • E、Load data into an Oracle database using operating system commands.
    • F、Load data directly from a non-Oracle database to an Oracle database.

    正确答案:A,D

  • 第2题：

    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

    正确答案:C

  • 第3题：

    Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）

    • A、 The block change tracking data will be used only from the next incremental 0 backup.
    • B、 The incremental backup will use change tracking data for accomplishing the backup.
    • C、 The incremental backup will not use change tracking data for accomplishing the backup.
    • D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

    正确答案:A,C

  • 第4题：

    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

    • A、 Restore the lost data file from the backup， and then flash back the database.
    • B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
    • C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
    • D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
    • E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

    正确答案:B,E

  • 第5题：

    You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）

    • A、the CONVERT command of RMAN
    • B、Data Pump Export and Import into the same database
    • C、conventional export and import into the same database
    • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
    • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

    正确答案:A,E

  • 第6题：

    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

    • A、Shut down the database, restore the two data files and then start up the database. 
    • B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
    • C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
    • D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

    正确答案:C

  • 第7题：

    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 are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? （） 

    • A、You should create a cached data collection 
    • B、You should create an on-demand non-cached data collection 
    • C、You should create a scheduled non-cached data collection. 
    • D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.

    正确答案:C

  • 第8题：

    多选题
    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


    正确答案： B,D
    解析： 暂无解析

  • 第9题：

    多选题
    You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）
    A

    the CONVERT command of RMAN

    B

    Data Pump Export and Import into the same database

    C

    conventional export and import into the same database

    D

    the BACKUP DATABASE and RESTORE DATABASE commands of RMAN

    E

    the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN


    正确答案： D,A
    解析： 暂无解析

  • 第10题：

    多选题
    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


    正确答案： A,D
    解析： 暂无解析

  • 第11题：

    单选题
    Which command would you use to determine what database backups are currently available for restore?（）
    A

    list database backup

    B

    report database backup  

    C

    list backup of database

    D

    list summary backup

    E

    report backup of database


    正确答案： B
    解析： 暂无解析

  • 第12题：

    多选题
    You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）
    A

    the CONVERT command of RMAN

    B

    Data Pump Export and Import into the same database

    C

    conventional export and import into the same database

    D

    the BACKUP DATABASE and RESTORE DATABASE commands of RMAN

    E

    the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN


    正确答案： B,E
    解析： 暂无解析

  • 第13题：

    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）

    • A、The backup will consist of used data blocks only.
    • B、The database must be shut down to accomplish the backup.
    • C、The backup can be accomplished without shutting down the database.
    • D、The backup will contain all database files that have never been backed up.

    正确答案:B

  • 第14题：

    In which two scenarios do you use SQL* Loader to load data?（）

    • A、Transform the data while it is being loaded into the database.
    • B、Use transparent parallel processing without having to split the external data first.
    • C、Load data into multiple tables during the same load statement.
    • D、Generate unique sequential key values in specified columns.

    正确答案:A,D

  • 第15题：

    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

    • A、Restore the data file and perform incomplete recovery.
    • B、Restore the data file and perform point-in-time recover.
    • C、Drop the tablespace and lose all data in the tablespace.
    • D、Restore the database and lose all data since the last backup.

    正确答案:C,D

  • 第16题：

    You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

    • A、the CONVERT command of RMAN
    • B、Data Pump Export and Import into the same database
    • C、conventional export and import into the same database
    • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
    • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

    正确答案:A,E

  • 第17题：

    What are three facts about backups with mysqldump?（）

    • A、Can back up a remote database server
    • B、Allow a consistent backup to be taken
    • C、Are always faster to restore than binary backups
    • D、Are able to back up specific items within a database
    • E、Create automatically compressed backups
    • F、Will lock all storage engines for duration of backup

    正确答案:A,B,D

  • 第18题：

    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 DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （） 

    • A、You should use database snapshots 
    • B、You should use database backup and restore 
    • C、You should use database backup and restore along with compression 
    • D、You should use schema-bound views in a read-only database. The database resides on the same instance.

    正确答案:A

  • 第19题：

    多选题
    Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）
    A

    The block change tracking data will be used only from the next incremental 0 backup.

    B

    The incremental backup will use change tracking data for accomplishing the backup.

    C

    The incremental backup will not use change tracking data for accomplishing the backup.

    D

    The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.


    正确答案： D,C
    解析： 暂无解析

  • 第20题：

    多选题
    In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;
    A

    $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql

    B

    Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'

    C

    $ mysql – u root – p – h localhost test ＜ /tmp/t1.sql

    D

    Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1

    E

    $ mysqlinport – u root – p – h localhost test /tmp/t1.sql


    正确答案： D,A
    解析： 暂无解析

  • 第21题：

    多选题
    In which two scenarios do you use SQL* Loader to load data?（）
    A

    Transform the data while it is being loaded into the database.

    B

    Use transparent parallel processing without having to split the external data first.

    C

    Load data into multiple tables during the same load statement.

    D

    Generate unique sequential key values in specified columns.


    正确答案： B,A
    解析： 暂无解析

  • 第22题：

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


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）
    A

    The backup will consist of used data blocks only.

    B

    The database must be shut down to accomplish the backup.

    C

    The backup can be accomplished without shutting down the database.

    D

    The backup will contain all database files that have never been backed up.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    多选题
    What are three facts about backups with mysqldump?（）
    A

    Can back up a remote database server

    B

    Allow a consistent backup to be taken

    C

    Are always faster to restore than binary backups

    D

    Are able to back up specific items within a database

    E

    Create automatically compressed backups

    F

    Will lock all storage engines for duration of backup


    正确答案： F,E
    解析： 暂无解析

相关内容