adplus-dvertising
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