Page 75 - 2611_SmartGPT Pro V(5.0) C-8

4. Think and answer.
a. Define the SELECT command.
______________________________________________________________________________

______________________________________________________________________________

______________________________________________________________________________

b. What do you understand by operators?
______________________________________________________________________________

______________________________________________________________________________

______________________________________________________________________________
c. List any two constraints used in MySQL.

______________________________________________________________________________

______________________________________________________________________________

______________________________________________________________________________

d. Differentiate between primary key and foreign key.

______________________________________________________________________________

______________________________________________________________________________

______________________________________________________________________________

e. Explain the use of Where clause in SQL.
______________________________________________________________________________

______________________________________________________________________________

______________________________________________________________________________

21 st #Critical Thinking
5. Competency-based/Application-based questions. Century
Skills #Technology Literacy
a. Madhurima is working on her organisation’s database. She set a key on a column and now that
column does not accept duplicate or null values. Which type of key has she applied?
b. Janvi made a table with states and capitals using SQL. She wants to display the capital

of a particular state. Which SQL clause should she use to set this condition?

MySQL: My First Database 73