Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 5

Q1. What do you mean by keyword in MySQL?

Q2. Identify the keyword from the following query.

Select * from book;

Q3. All statements in MySQL are terminated by __________.

Q4. We can create ____________ (database/tables)inside ___________(database/tables).

Q5. SQL is a case sensitive language(T/F)

Q6. _________ statement is used to show all the existing databases in server.

Q7. Which statement is used to show all existing table in database.

Q8. Write statement to open a database named "student".

Q9. Name the command used to create database.

Q10. Write statement to create database named "book"

 SOLUTION

Q1. What do you mean by keyword in MySQL?
Ans. Keyword refers to a word which has special meaning in MySQL.

Q2. Identy the keyword from the following query.
Select * from book;
Ans. Keywords are : select and from

Q3. All statements in MySQL is terminated by __________.
Ans. Semicolon(;)

Q4. We can create ____________ (database/tables)inside ___________(database/tables).

Ans. tables, database

Q5. SQL is a case sensitive language(T/F)

Ans. False

Q6. _________ statement is used to show all the existing databases in server.

Ans. Show databases;

Q7. Which statement is used to show all existing table in database.

Ans. Show tables;

Q8. Write statement to open a database named "student".

Ans. use student;

Q9. Name the command used to create database.

Ans. Create database

Q10. Write statement to create database named "book"

Ans. create database book;