Question
CREATE TABLE employee (
emp_name CHAR(30),
emp_id INT
);a.
30
b.
1
c.
2
d.
3
Posted under MySQL Basics 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. Which of the following options tells mysql to ask for entering the password?
View solution
Q. The query ‘SELECT NOW()’ shows the current _____________
View solution
Q. Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?
View solution
Q. To see the table structure, which of the following SQL commands is issued?
View solution
Q. SHOW DATABASES lists the databases in the server to which you are connected.
View solution
Q. The command to move the cursor to the beginning of line in MySQL input editor is?
View solution
Q. What does Control-_ do in MySQL input editor?
View solution
Q. On UNIX, statements entered in ‘MySQL’ are saved in which file?
View solution
Q. MySQL can be used to execute script files.
View solution
Q. Suppose run_me.sh is a script file. Which command is used to make it executable?
View solution
Q. To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?
View solution
Q. Which option prints output in table-format when MySQL is run interactively?
View solution
Q. The clause that enables mapping a short command to a long command is __________
View solution
Q. The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.
View solution
Q. In UNIX, the name of the option file is __________
View solution
Q. Which statement upgrades the database directory name encoding?
View solution
Q. The statement that alters an existing event to have the given definition is _____________
View solution
Q. What sets up an association between one or more MyISAM tables and the named key cache?
View solution
Q. Which statement can produce the same output as ‘SHOW COLUMNS’?
View solution
Q. Converting a client/server application to embedded server is difficult.
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!
