Question
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
Posted under MySQL Administration MySQL Database
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. What is InnoDB in the following MySQL code?
Similar Questions
Discover Related MCQs
Q. In which file are the statements entered in ‘mysql’ saved?
View solution
Q. Mysql cannot be used to execute script files.
View solution
Q. Which command is used to make a script file ‘run_me.sh’ executable?
View solution
Q. The superuser account of the grant tables in the mysql database is called ______________
View solution
Q. Which script initializes the data directory during installation?
View solution
Q. Anonymous accounts have user name ______________
View solution
Q. For REVOKE statements, the server automatically rereads the grant tables.
View solution
Q. What does the default case sensitivity of database and table names depend on?
View solution
Q. The case sensitive among these is ______________
View solution
Q. The variable used to set table alias names as non case sensitive is ______________
View solution
Q. The clause that can be used to sort string values according to a specific collation is ______________
View solution
Q. The statement used to find out which character sets are available is ______________
View solution
Q. The error log file has a suffix ______________
View solution
Q. The option which finds the startup options supported by the server through mysqld is ______________
View solution
Q. Server startup can also be done by the ______________
View solution
Q. It is required to have an access privilege for a database before selecting it with ‘USE’.
View solution
Q. The keyword used to create a database is __________
View solution
Q. Which file is created by the server to store the database attributes?
View solution
Q. What is the default storage engine?
View solution
Q. The name of the format file for a table named my_tbl is __________
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
