Choose appropriate answer with respect to the following code snippet. CREATE TABLE student ( name CHAR(30), st

Exercises · Q2

Q. Choose appropriate answer with respect to the following code snippet. CREATE TABLE student (name CHAR(30), student_id INT, gender CHAR(1), PRIMARY KEY (student_id));

a) What will be the degree of student table?

i) 30

ii) 1

iii) 3

iv) 4

b) What does 'name' represent in the above code snippet?

i) a table

ii) a row

iii) a column

iv) a database

c) What is true about the following SQL statement?
SelecT * fROM student;

i) Displays contents of table 'student'

ii) Displays column names and contents of table 'student'

iii) Results in error as improper case has been used

iv) Displays only the column names of table 'student'

d) What will be the output of following query?
INSERT INTO student
VALUES ("Suhana",109,'F'),
VALUES ("Rivaan",102,'M'),
VALUES ("Atharv",103,'M'),
VALUES ("Rishika",105,'F'),
VALUES ("Garvit",104,'M'),
VALUES ("Shaurya",109,'M');

i) Error

ii) No Error

iii) Depends on compiler

iv) Successful completion of the query

e) In the following query how many rows will be deleted?
DELETE student
WHERE student_id=109;

i) 1 row

ii) All the rows where student ID is equal to 109

iii) No row will be deleted

iv) 2 rows

CBSENCERTMCQ· 1mImportance★★★★★

62% · 28/45 Questions

✓ Free question

Concept understanding — Table Creation

Table Creation: The Art of Organising Information

Think of the last time you tried to find a specific contact in your phone. If all your contacts were just listed in one long, unbroken list — no groups, no alphabetical order, no search — you would have to scroll through every single name to find the one you need. That is the problem that table creation solves.

In everyday life, we create tables all the time without thinking about it. A timetable for your classes, a cricket scorecard, a menu with prices — each of these is a table. The instinct to arrange information into rows and columns is natural because it makes comparison and retrieval fast. Table creation, in the context of your studies, is simply the deliberate, systematic act of doing this with data so that it becomes meaningful and usable.

What Exactly Is a Table?

A table is a structured arrangement of data in rows and columns. Each row typically represents one complete record or observation — for example, one student, one month, one product. Each column represents a particular characteristic or variable of that record — for example, name, marks, price, date.

The power of a table lies in its ability to show relationships at a glance. When data is scattered in a paragraph, you have to read and mentally compare. When it is in a table, your eye can move vertically down a column or horizontally across a row, spotting patterns, extremes, and gaps instantly.

Note

In your NCERT textbooks for commerce and humanities subjects — especially in Economics, Statistics, and Business Studies — tables are the primary tool for presenting data before any analysis begins. They are not decorative; they are the foundation on which interpretation is built.

The Core Elements of a Table

Every proper table has a few essential parts. Understanding these will help you both read tables and create your own.

Title: A clear, concise heading that tells the reader what the table contains. It should answer the questions: what, where, and when. For example, "Monthly Sales of ABC Ltd., April–September 2023" is far better than just "Sales Data."
Column Headings (Captions): These label each column and describe the type of data it holds. They must be precise — "Revenue (in ₹ lakh)" is clearer than just "Revenue."
Row Headings (Stubs): These label each row, usually on the leftmost column. They identify what each row represents — for instance, the names of months, products, or regions.
Body of the Table: The actual data cells where numbers or text entries sit. This is the heart of the table.
Source Note: A line below the table stating where the data came from. This is crucial for credibility, especially in exam answers and project work.
Footnotes (if needed): Any clarification about a specific entry — for example, an asterisk explaining that a figure is an estimate.

Why Table Creation Matters for You

In your exams and assignments, you will often be asked to present raw data in tabular form. This is not busywork. The examiner wants to see that you can:

Identify the key variables in a given set of information.
Classify and group data logically.
Present it without ambiguity so that anyone reading can understand it immediately.

A well-created table can turn a confusing jumble of numbers into a clear story. For instance, if you are given the population figures of five states over three census years, a table lets you see at once which state grew fastest, which declined, and how each compares to the others. Without the table, you would have to hold all those numbers in your head.

Important

In Statistics for Economics (NCERT Class 11), the chapter on "Organisation of Data" explicitly teaches you how to construct frequency distribution tables. This is the first step before you ever calculate a mean, median, or mode. If your table is wrong, everything that follows is wrong. Table creation is not optional — it is the gatekeeper of accurate analysis.

Common Mistakes to Avoid

When you create a table for the first time, watch out for these pitfalls:

Missing or vague title. A reader should not have to guess what the table is about.
Inconsistent units. If one column uses rupees and another uses thousands of rupees, the comparison is misleading.
Overcrowding. A table with too many columns becomes hard to read. Sometimes it is better to split data into two simpler tables.
No source or footnotes. In academic work, this is considered incomplete.

A Simple Mental Model

Think of table creation as building a filing cabinet. Each drawer is a column (a variable), and each folder inside is a row (a record). The title tells you what the cabinet contains. The column headings tell you what each drawer holds. The row headings tell you which folder you are looking at. When you open the right drawer and pull the right folder, you find exactly the piece of data you need.

That is the entire purpose of table creation: to make data findable, comparable, and interpretable. It is a skill you will use not just in exams, but in any career that involves handling information — which is almost every career.

Degree counts columns (3 — the PRIMARY KEY line is a constraint); name is a column; SQL keywords are case-insensitive so SelecT * fROM student; runs and prints headers + rows; the INSERT illegally repeats VALUES (and duplicates id 109) so it errors; the DELETE is missing FROM, so it errors and deletes nothing.

✓Final answer

a) (iii) 3 \cdot b) (iii) a column \cdot c) (ii) displays column names and contents \cdot d) (i) Error \cdot e) (iii) No row will be deleted.

Five short MCQs on one CREATE TABLE snippet. The keys: degree = number of columns (3); name is a column; SQL keywords are case-insensitive so the odd-looking SelecT * fROM runs and shows headers + rows; the multi-row INSERT repeats the keyword VALUES so it errors; and the DELETE is missing FROM, so it errors and no row is deleted.

The snippet under discussion:

CREATE TABLE student (
    name CHAR(30),
    student_id INT,
    gender CHAR(1),
    PRIMARY KEY (student_id)
);

a) Degree of the student table

The degree of a relation is its number of attributes (columns). Here there are exactly three: name, student_id, gender — the PRIMARY KEY (student_id) line is a constraint, not a fourth column.

(i) 30 is just the size of CHAR(30); (ii) 1 confuses degree with the single key column; (iv) 4 wrongly counts the constraint line.
Correct: (iii) 3.

b) What does name represent?

name is declared inside CREATE TABLE with a data type (CHAR(30)), which is precisely how a column is defined.

(i) the table is student; (ii) rows only come into existence via INSERT; (iv) a database is created by CREATE DATABASE.
Correct: (iii) a column.

c) SelecT * fROM student;

SQL keywords are case-insensitive, so this strange capitalisation is perfectly legal — option (iii) "error" is out. SELECT * retrieves every column of every row, and the client displays the result as a table with the column names as headers above the contents:

SelecT * fROM student;

name	student_id	gender
...	...	...

So the most precise option is the one that mentions both the column names and the contents — (i) is incomplete, (iv) is the opposite of what happens.

Correct: (ii) Displays column names and contents of table 'student'.

d) The multi-row INSERT

INSERT INTO student
VALUES ("Suhana",109,'F'),
VALUES ("Rivaan",102,'M'),
...

The keyword VALUES may appear only once; the row tuples after it are separated by commas alone. Repeating VALUES before every row is a syntax error, so the statement fails immediately. (Even after fixing the syntax it would still fail: student_id 109 appears twice — "Suhana" and "Shaurya" — violating the primary key with ERROR 1062: Duplicate entry '109'.) The correct multi-row form, for reference:

INSERT INTO student VALUES
('Suhana', 109, 'F'),
('Rivaan', 102, 'M'),
('Atharv', 103, 'M'),
('Rishika', 105, 'F'),
('Garvit', 104, 'M');

(ii)/(iv) claim success, which the syntax rules out; (iii) is a distractor — SQL syntax validity does not "depend on compiler".
Correct: (i) Error.

e) DELETE student WHERE student_id=109;

The statement is missing the keyword FROM — the valid form is DELETE FROM student WHERE .... As written it is a syntax error, the statement never executes, and therefore no row is deleted.

(i)/(iv) assume the query runs; (ii) describes what the corrected query would do — and even then, since student_id is the primary key, at most one row can hold 109.
Correct: (iii) No row will be deleted.

✓Final answer

a) (iii) 3 — degree = number of columns. b) (iii) a column — declared with type CHAR(30) . c) (ii) Displays column names and contents — keywords are case-insensitive; the result shows headers plus rows. d) (i) Error — VALUES must appear only once (and 109 is duplicated anyway). e) (iii) No row will be deleted — FROM is missing, so the statement errors out.

Same / Similar Concept — real previous-year questions on the same or a closely similar concept, not this exact question.

CBSE 2024Set 91/42 marks
$Q. (A) Ms. Veda created a table named Sports in a MySQL database, containing columns Game_id, P_Age and G_name. After creating the table, she realized that the attribute, Category has to be added. Help her to write a command to add the Category column. Thereafter, write the command to insert the following record in the table: Game_id: G42 P_Age: Above 18 G_name: Chess Category: Senior$
(OR)
$(B) Write the SQL commands to perform the following tasks:$
(i) View the list of tables in the database, Exam.
(ii) View the structure of the table, Term1.
›Reveal solutionSolution
Part (a): ALTER TABLE Sports ADD Category VARCHAR(20); to add the column, then INSERT INTO Sports VALUES(...) to add the row. Part (b): SHOW TABLES FROM Exam; lists tables and DESCRIBE Term1; shows a table's structure.

Part (a)

To add a new attribute to an existing table you modify its structure with ALTER TABLE ... ADD, giving the new column a name and a data type. Since Category stores text like 'Senior', a VARCHAR is appropriate.

ALTER TABLE Sports ADD Category VARCHAR(20);

Now the table has four columns: Game_id, P_Age, G_name, Category. Insert the record with INSERT INTO; string values go in single quotes. Naming the columns is good practice but optional if you supply values in table order.

INSERT INTO Sports (Game_id, P_Age, G_name, Category) VALUES ('G42', 'Above 18', 'Chess', 'Senior');

Note P_Age holds text ('Above 18'), so its column must be a character type.

✓Final answer
$Add the column with ALTER TABLE Sports ADD Category VARCHAR(20); and insert with INSERT INTO Sports VALUES ('G42', 'Above 18', 'Chess', 'Senior');$

Part (b)

(i) To see every table inside a particular database, use SHOW TABLES with the FROM clause (or first select the database with USE).

SHOW TABLES FROM Exam;

(ii) To inspect a table's columns, their data types, nullability and keys, use DESCRIBE (short form DESC), which is equivalent to SHOW COLUMNS FROM Term1;.

DESCRIBE Term1;

✓Final answer
$SHOW TABLES FROM Exam; shows all tables of the Exam database; DESCRIBE Term1; (or DESC Term1;) displays the structure of table Term1.$

←Previous questionQ1 — Match the following clauses with their respective functions. | Clause …→Next questionQ3 — Fill in the blanks: a) ______ declares that an index in one table is r…

Q.Choose appropriate answer with respect to the following code snippet. CREATE TABLE student ( name CHAR(30), student_id INT, gender CHAR(1), PRIMARY KEY (student_id) );

🎓Unlock everything free for 14 days

Q.Choose appropriate answer with respect to the following code snippet. CREATE TABLE student (
name CHAR(30),
student_id INT,
gender CHAR(1),
PRIMARY KEY (student_id)
);

Unlock everything free for 14 days