修改MySQL用户root的密码的指令是()。
第1题:
A.mysqladmin-urootpasswordtest
B.mysql-urootpasswordtest
C.mysql-uroot-ptest
D.mysql-uroot-passwordtest
第2题:
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
第3题:
在缺省安装数据库管理系统MySQL后,root用户拥有所有权限且是空口令,为了安全起见,必须为root用户设置口令,以下口令设置方法中,不正确的是()。
A.使用MySQL自带的命令mysql admin设置root口令
B.使用set password设置口令
C.登录数据库,修改数据库mysql下user表的字段内容设置口令
D.登录数据库,修改数据库mysql下的访问控制列表内容设置口令
第4题:
●在Linux中,可以使用命令(63)来给test文件赋予执行权限。
(63)
A. [root@root]#chmod -x test
B. [root@root]#chmod +x test
C. [root@root]#chmod -w test
D. [root@root]#chmod +w test
第5题:
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.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
第6题:
A.MySQL requires correct file ownership while remaining secure
B.MySQL needs to be run as the root user, but file cannot be owned by it
C.MySQL cannot be run as the root user
第7题:
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 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
第8题:
MySQL中,预设的、拥有最高权限超级用户的用户名为( )
A.test
B.Administrator
C.DA
D.root
第9题:
数据库中超级账户不能被锁定,其中Oracle的是(),mysql的是(),SQLServer的是()。
A.sa,root,sys
B.admin,root,sa
C.sys,root,sa
D.sys,admin,sa
第10题: