Question
CREATE TABLE student
(
name CHAR(30),
roll_num INT,
address CHAR(30),
phone CHAR(12)
);a.
A table
b.
A row
c.
A column
d.
An object
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. What does ‘name’ represent in the following SQL code snippet?
Similar Questions
Discover Related MCQs
Q. Which is the MySQL instance responsible for data processing?
View solution
Q. The MySQL server used in its client/server architecture is _______________
View solution
Q. In MySQL databases, the structure representing the organizational views of the entire databases is ____________
View solution
Q. Which of the following clauses is used to display information that match a given pattern?
View solution
Q. The special database that always exists after setting up MySQL in a computer is __________
View solution
Q. Which operator is used to perform integer divisions in MySQL?
View solution
Q. The NULL value also means ___________
View solution
Q. What does comparing a known value with NULL result into?
View solution
Q. Which clause is used to sort query elements?
View solution
Q. MySQL client runs on the machine containing the databases and servers connect to the client over a network.
View solution
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
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!
