Multiple Choice Questions:
1. MySQL is a
RDBMS
2. USE <database name> command
Opens a database
3. Number of columns in a table is called
Degree
4. A database
Contains tables
5. Number of rows in a table is called
Cardinality
6. ORDER BY clause is used to sort data
In Ascending order
7. A Table can have
Only one Primary key
8. Wild card characters are used
In Like clause
9. DDL is
A part of SQL
10. Like clause is used for
Pattern matching
Lab Exercises from MySQL
Table: Loan_Accounts
AccN Cust_Name Loan_Amoun Instalments Int_Rat Interest_Date
o t e
1 R.K. Gupta 300000 36 12.00 19-07-2009
2 S.P. Sharma 500000 58 10.00 22-03-2008
3 K.P. Jain 300000 36 NULL 08-03-2007
4 M.P. Yadav 800000 60 10.00 06-12-2008
5 S.P. Sinha 200000 36 12.50 03-01-2010
6 P. Sharma 700000 60 12.50 05-06-2008
7 K.S. Dhall 500000 48 NULL 05-03-2008
1. Create the database LOANS
2. Use the database LOANS
3. Create the table Loan_Accounts and insert
tuples in it
4. Display the details of all the loans
5. Display the AccNo, Cust_Name and
Loan_Amount of all the Loans
6. Display the details of all the loans with less
than 40 instalments
7. Display the AccNo and Loan_Amount of all
the loans started before 01-04-2009
8. Display the Int_Rate of all the loans started
after 01-04-2009
9. Display the details of all the loans whose rate
of interest is NULL
10. Display the details of all the loans whose
rate of interest is not NULL
11. Display the amounts of various loans from
the table Loan_accounts. A loan amount
should appear only once
12. Display the number of instalments of
various loans from the table Loan_accounts.
An instalment should appear only once
13. Display the details of all the loans started
after 31-12-2008 for which the number of
instalments are more than 36
14. Display the Cust_Name and Loan_Amount
for all the loans which do not have number of
instalments 36
15. Display the Cust_Name and Loan_Amount
for all the loans for which the loan amount is
less than 500000 or int_rate is more than 12
16. Display the details of all the loans which
started in the year 2009
17. Display the details of all the loans whose
Loan_Amount is in the range 400000 to
500000
18. Display the details of all the loans whose
rate of interest is in the range 11% to 12%
19. Display the Cust_Name and Loan_Amount
for all the loans for which the number of
instalments are 24, 36 or 48. (using IN
operator)
20. Display the details of all the loans whose
Loan_Amount is in the range 400000 to
500000. (using BETWEEN operator)
21. Display the details of all the loans whose
rate of interest is in the range 11% to 12%.
(using BETWEEN operator)
22. Display the AccNo, Cust_Name and
Loan_Amount for all the loans for which the
Cust_Name ends with ‘Sharma’
