单选题You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）A –sk

第1题：

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

第2题：

A system is being booted into maintenance mode due to root password recovery.  After accessing the root volume group and starting a shell without mounting the file systems， what is the next step？（）  

• A、Delete root’s password from the /etc/security/passwd file.
• B、Use the diag recovery tool option to reset root’s password.
• C、Execute the ’passwd’ command and assign a new passwd to root UId
• D、Mount the / and /usr filesystems on alternative mount points to edit the password file.

第3题：

如何启动ntp服务（）

• A、/etc/init.d/ntpd start
• B、ntpstart
• C、/etc/init.d/ntpd stop
• D、/etc/init.d/ntpd status

第4题：

如何启动ntp服务（）。

• A、/etc/init.d/ntpdstart
• B、ntpstart
• C、/etc/init.d/ntpdstop
• D、/etc/init.d/ntpdstatus

第5题：

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

第6题：

You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）

• A、–skip-networking, to prohibit access from remote locations
• B、–reset-grant-tables, to start the server with only the mysql database accessible
• C、–read-only,to set all data to read-only except for super users
• D、–old-passwords, to start Mysql to use the old password format while running without the grant tables

第7题：

You are the administrator of an Active Directory domain named A user reports that he forgot his password and cannot log on to the domain. You discover that yesterday morning the user reset his password and successfully logged on to the domain. You need to enable the user to log on to the domain. What should you do? （）(Choose two)

• A、Use Active Directory Users and Computers to move the account to the default organizational unit (OU) named Users. Instruct the user to restart his computer.
• B、Use Active Directory Users and Computers to open the account properties for the user's user account. Clear the Account is locked out check box, and select the User must change password at next logon check box.
• C、Use Active Directory Users and Computers to reset the user's password. Give the user the new password.
• D、Use Computer Management to reset the password for the local Administrator account.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A system is being booted into maintenance mode due to root password recovery.After accessing the root volume group and starting a shell without mounting the file systems, what is the next step?（）

• A、Delete root's password from the /etc/security/passwd file
• B、Use the diag recovery tool option to reset root's password
• C、Execute the ‘passwd’ command and assign a new passwd to root UID
• D、Mount the / and /usr filesystems on alternative mount points to edit the password file

第14题：

You are the administrator of 30 Windows XP Professional computers. The computers are not members of a domain. Users of the Windows XP Professional computers encrypt files on the local computers. A user named Stephen reports that he cannot remember his current password. However, he does remember his previous password. Before he changed to his current password, Stephen created a password reset disk. You want to ensure that Stephen can log on to his Windows XP Professional computer again, and that he can open the encrypted files. What should you do?（） 

• A、Reset Stephen's password and instruct Stephen to log on with the new password.
• B、Reset Stephen's password and then use the password reset disk.
• C、Instruct Stephen to log on with his previous password. 
• D、Instruct Stephen to use the password reset disk to set a new password on his account.
• E、Use the Forgotten Password Wizard to create a new password reset disk for Stephen.
• F、Use this disk to set a new password on Stephen's account.

第15题：

如何启动xinted服务（）。

• A、/etc/init.d/cron start
• B、/etc/init.d/httpd start
• C、/etc/init.d/xinted start
• D、service xinted start

第16题：

What are three actions performed by the mysql_secure_installation tool?（）

• A、It prompts you to set the root user account password
• B、It checks whether file permissions are appropriate within datadir
• C、It asks to remove the test database, which is generated at installation time
• D、It can delete any anonymous accounts
• E、It verifies that all users are configuration with the longer password hash

第17题：

You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Which statement is true about this scenario?（）

• A、The RPM installation script sets a default password of password for new installations
• B、The local root user must log in with a blank password initially: mysql –u root –p
• C、New security measures mean that the mysql_secure_installation script must be run first on all new installations
• D、The mysql_install_bd post-installation script used – random-password

第18题：

You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）

• A、STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
• B、STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE
• C、STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
• D、STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE

第19题：

第20题：

第21题：

第22题：

第23题：