MySQL Database Multiple choice Questions and Answers-MySQL Administration

61.	When relocating an individual table, the table to be relocated should be ______________
a.	MyISAM
b.	InnoDB
c.	TRANSACTION
d.	ENGINE

Discuss

Answer: (a).MyISAM

62.	What is the special database that always exists after setting up MySQL on a computer?
a.	sampdb
b.	mysql
c.	information_schema
d.	readme_db

Discuss

Answer: (c).information_schema

63.	What is InnoDB in the following MySQL code? `CREATE TABLE student ( name CHAR(30), student_id INT, PRIMARY KEY (student_id) ) ENGINE = InnoDB;`
a.	database name
b.	table name
c.	reference engine
d.	storage engine

Discuss

Answer: (d).storage engine

64.	What is the table name in the following SQL code? `INSERT INTO student VALUES('Kyle','M',NULL);`
a.	student
b.	VALUES
c.	Kyle
d.	M

Discuss

Answer: (a).student

65.	In which file are the statements entered in ‘mysql’ saved?
a.	.mysql_queries
b.	.queries
c.	.mysql_history
d.	.history

Discuss

Answer: (c)..mysql_history

66.	Mysql cannot be used to execute script files.
a.	True
b.	False
c.	May be True or False
d.	Can't say

Discuss

Answer: (b).False

67.	Which command is used to make a script file ‘run_me.sh’ executable?
a.	chmod +e run_me.sh
b.	chmod +a run_me.sh
c.	chmod +y run_me.sh
d.	chmod +x run_me.sh

Discuss

Answer: (d).chmod +x run_me.sh

68.	The superuser account of the grant tables in the mysql database is called ______________
a.	super
b.	prime
c.	root
d.	leaf

Discuss

Answer: (c).root

69.	Which script initializes the data directory during installation?
a.	mysql_install_db
b.	mysql_install_dbm
c.	mysql_init_db
d.	mysql_init_dbm

Discuss

Answer: (a).mysql_install_db

70.	Anonymous accounts have user name ______________
a.	root
b.	blank
c.	super
d.	prime

Discuss

Answer: (b).blank