网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
修改MySQL用户root的密码的指令是()。
- A、mysqladmin -u root password test
- B、mysql -u root password test
- C、mysql -u root -p test
- D、mysql -u root -password test
参考答案
更多 “修改MySQL用户root的密码的指令是()。A、mysqladmin -u root password testB、mysql -u root password testC、mysql -u root -p testD、mysql -u root -password test” 相关考题
考题
在缺省安装数据库管理系统MySQL后,root用户拥有所有权限且是空口令,为了安全起见,必须为root用户设置口令,以下口令设置方法中,不正确的是()。A.使用MySQL自带的命令mysql admin设置root口令B.使用set password设置口令C.登录数据库,修改数据库mysql下user表的字段内容设置口令D.登录数据库,修改数据库mysql下的访问控制列表内容设置口令
考题
修改MySQL用户root的密码的指令是?()
A.mysqladmin-urootpasswordtestB.mysql-urootpasswordtestC.mysql-uroot-ptestD.mysql-uroot-passwordtest
考题
MySQL is installed on a Linux server and has the following configuration:What is the purpose of changing ownership of datadir to the ‘mysql’ user?()
A.MySQL requires correct file ownership while remaining secureB.MySQL needs to be run as the root user, but file cannot be owned by itC.MySQL cannot be run as the root user
考题
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
考题
You have forgotten the root user account password. You decide to reset the password and execute the following:Shell> /etc/init.d/mysql stopShell> /etc/init.d/mysql start – skip-grant tablesWhich additional argument makes this operation safer?()A.–skip-networking, to prohibit access from remote locationsB.–reset-grant-tables, to start the server with only the mysql database accessibleC.–read-only,to set all data to read-only except for super usersD.–old-passwords, to start Mysql to use the old password format while running without the grant tables
考题
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
考题
数据库中超级账户不能被锁定,其中Oracle的是(),mysql的是(),SQLServer的是()。A.sa,root,sysB.admin,root,saC.sys,root,saD.sys,admin,sa
考题
●在Linux中,可以使用命令(63)来给test文件赋予执行权限。(63)A. [root@root]#chmod -x testB. [root@root]#chmod +x testC. [root@root]#chmod -w testD. [root@root]#chmod +w test
考题
关于MySQL安全,以下做法不正确的是( )。
A.设置sy1用户,并赋予mysql库user表的存取权限
B.尽量避免以root权限运行MySQL
C.删除匿名账号
D.安装完毕后,为root账号设置口令
考题
在缺省安装数据库管理系统MySQL,root用户拥有所有权限且是空口令,为了安全起见,必须为root用户设置口令,以下口令设置方法中,不正确的是( )。
A.使用MySQL自带的命令mysqladmin设置root口令
B.使用setpassword设置口令
C.登录数据库,修改数据库mysql下user表的字段内容设置口令
D.登录数据库,修改数据库mysql下的访问控制列表内容设置口令
考题
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
考题
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
考题
下列关于常见MySQL语句或者命令描述正确的是()。A、执行mysql -u root -p命令可以root身份连接数据库B、SHOW TABLES;可以显示当前数据库下所有表C、SHOW DATABASES;显示所有的数据库信息D、USE test;切换当前数据库到test
考题
数据库中超级账户不能被锁定,其中Oracle的是(),mysql的是(),SQLServer的是()。A、sa,root,sysB、admin,root,saC、sys,root,saD、sys,admin,sa
考题
查看root用户的cron计时器设置的命令是()。A、crontab-u root -lB、crontab -lC、crontab -u root -eD、crontab -u root -r
考题
Oracle、MSSQL、MySQL三种数据库,分别有最高权限用户,以下哪一列是正确的().A、SYS、Root、SAB、Root、SSYSC、Dbsnmp、SRootD、SYS、SRoot
考题
What are three actions performed by the mysql_secure_installation tool?()A、It prompts you to set the root user account passwordB、It checks whether file permissions are appropriate within datadirC、It asks to remove the test database, which is generated at installation timeD、It can delete any anonymous accountsE、It verifies that all users are configuration with the longer password hash
考题
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 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 installationsB、The local root user must log in with a blank password initially: mysql –u root –pC、New security measures mean that the mysql_secure_installation script must be run first on all new installationsD、The mysql_install_bd post-installation script used – random-password
考题
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 locationsB、–reset-grant-tables, to start the server with only the mysql database accessibleC、–read-only,to set all data to read-only except for super usersD、–old-passwords, to start Mysql to use the old password format while running without the grant tables
考题
单选题修改MySQL用户root的密码的指令是?()A
mysqladmin-urootpasswordtestB
mysql-urootpasswordtestC
mysql-uroot-ptestD
mysql-uroot-passwordtest
考题
多选题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.sqlBMysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'C$ mysql – u root – p – h localhost test < /tmp/t1.sqlDMysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1E$ mysqlinport – u root – p – h localhost test /tmp/t1.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?()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
考题
多选题You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?()AShell> mysqladmin –u root –p shutdownBShell> nmc mysql shutdownCMysql> STOP PROCESS mysqldDShell> /etc/init.d/mysql stopEShell> service mysql safe_exitFShell> pkill –u mysql mysqld_safeGShell> net stop mysql
考题
多选题What are three actions performed by the mysql_secure_installation tool?()AIt prompts you to set the root user account passwordBIt checks whether file permissions are appropriate within datadirCIt asks to remove the test database, which is generated at installation timeDIt can delete any anonymous accountsEIt verifies that all users are configuration with the longer password hash
考题
单选题修改MySQL用户root的密码的指令是()。A
mysqladmin -u root password testB
mysql -u root password testC
mysql -u root -p testD
mysql -u root -password test
热门标签
最新试卷