Question
CREATE TABLE employee (
emp_name CHAR(30),
emp_id INT
);a.
1
b.
2
c.
3
d.
30
Posted under MySQL Database
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. The number of attributes in the following SQL table is ______________
Similar Questions
Discover Related MCQs
Q. To see the table structure which command is issued?
View solution
Q. Which character is illegal in naming an unquoted identifier in SQL?
View solution
Q. Which statement is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?
View solution
Q. The default case sensitivity of the database and table names depends on ___________
View solution
Q. To how many of the following does the prepared-statement API apply to?
CREATE TABLE, DELETE, DO, INSERT
View solution
Q. The binary protocol does not support all statements.
View solution
Q. The binary protocol is more difficult to use.
View solution
Q. The maximum collations a character set can have is ______________
View solution
Q. A synonym for CHARACTER SET is ______________
View solution
Q. The statement used to select a default database is ______________
View solution
Q. The statement that makes changes to the global attributes of the database is ______________
View solution
Q. The statement used to remove indexes on tables is ______________
View solution
Q. The statement used to change the table name is __________
View solution
Q. What is the general term for information about databases and the objects in MySQL?
View solution
Q. Perl scripts are text files.
View solution
Q. The shebang line is ______________
View solution
Q. The Perl DBI is ______________
View solution
Q. The default path to perl in Unix is ______________
View solution
Q. Which is the join in which all the rows from the right table appear in the output irrespective of the content of the other table?
View solution
Q. What is the facility that allows nesting one select statement into another?
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!
