Skip to content

Ch 9 · Structured Query Language (SQL)

In-text Questions

Exercise 2 of 3
Question 1NCERT PDF page 2
9.2.1 Installing MySQL
MySQL is an open source RDBMS software which can
be easily downloaded from the official website https://
dev.mysql.com/downloads. After installing MySQL,
start MySQL service. The appearance of mysql> prompt
(Figure 9.1) means that MySQL is ready to accept SQL
statements.
Figure 9.1: MySQL Shell
Following are some important points to be kept in
mind while using SQL:
132 Computer Science - Class XII
Answer

State the algorithm or concept, trace the logic step by step, and provide syntactically correct code, SQL or output where requested.

Check: Verify the result for the stated input and mention the relevant constraint or complexity.