Multiple Choice Questions:: 1. Mysql Is A

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

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
Loan_Amount is in the range 400000 to
500000

rate of interest is in the range 11% to 12%

for all the loans for which the number of
instalments are 24, 36 or 48. (using IN
operator)

Loan_Amount is in the range 400000 to
500000. (using BETWEEN operator)
rate of interest is in the range 11% to 12%.
(using BETWEEN operator)

Loan_Amount for all the loans for which the
Cust_Name ends with ‘Sharma’

Cust_Name ends with ‘a’

Cust_Name contains ‘a’
Cust_Name does not contain ‘P’

Cust_Name contains ‘a’ as the second last
character
27. Display the details of all the loans in the

ascending order of their Loan_Amount

descending order of their Interest_Date
ascending order of their Loan_Amount and
within Loan_Amount in the descending order
of their Interest_Date
30. Put the interest rate 11.50% for all the

loans for which interest rate is NULL
31. Increase the interest rate by 0.5% for all

the loans for which the loan amount is more
than 400000
32. For each loan replace Interest with

(Loan_Amount*Int_Rate*Instalments)12*100
33. Delete the records of all the loans whose

start date is before 2007
34. Delete the records of all the loans of ‘K.P.

Jain’
35. Add another column Category of type
CHAR(1) in the Loan Table
OUTPUT PROGRAMS:
36. SELECT cust_name, LENGTH(Cust_Name),

LCASE(Cust_Name), UCASE(Cust_Name) FROM
Loan_Accounts WHERE Int_Rate<11.00;
37. SELECT LEFT (Cust_Name,3), Right(Cust_Name,3)

SUBSTR(Cust_Name,1,3) FROM Loan_Accounts WHERE
Int_Rate>10.00;
38. SELECT RIGHT(Cust_Name,3), SUBSTR(Cust_Name,5)
FORM Loan_Accounts;
39. SELCT DAYNAME(Start_Date) FROM Loan_Accounts;
40. SELECT ROUND(Int_Rate*110/100,2) FROM

Loan_Accounts WHERE Int_Rate>10;
41. SELECT POW(4,3), POW(3,4);

42. SELECT ROUND(543.5694,2), TRUNCATE(543.5694,-
1);
43. SELECT TRUNCATE(543.5694,2),

TRUNCATE(543.5694,-1);
44. SELECT LENGTH(“Prof.M.L.Sharma”);

45. SELECT CONCAT(“SHIEKH”,” HAROON”)”FULLNAME”;
46. SELECT YEAR(CURDATE()),MONTH(CURDATE()),

DAY(CURDATE());
47. SELECT DAYOFYEAR(CURDATE()),

DAYOFMONTH(CURDATE()), DAYNAME(CURDATE());
48. SELECT LEFT(“Unicode”,3),RIGHT(“Unicode”,4);

49. SELECT
INSTR(“UNICODE”,”CO”),INSTR(“UNICODE”,”CD”);
50. SELECT MID(“Informatics”,3,4),SUBSTR(“Practice”,3);

Multiple Choice Questions:: 1. Mysql Is A

Uploaded by

Copyright:

Available Formats

Multiple Choice Questions:: 1. Mysql Is A

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Multiple Choice Questions:: 1. Mysql Is A

Uploaded by

Copyright:

Available Formats

Multiple Choice Questions:

2. USE <database name> command

3. Number of columns in a table is called

5. Number of rows in a table is called

6. ORDER BY clause is used to sort data

7. A Table can have

8. Wild card characters are used

10. Like clause is used for

Lab Exercises from MySQL

2. Use the database LOANS

3. Create the table Loan_Accounts and insert

4. Display the details of all the loans

6. Display the details of all the loans with less

7. Display the AccNo and Loan_Amount of all

8. Display the Int_Rate of all the loans started

10. Display the details of all the loans whose

11. Display the amounts of various loans from

12. Display the number of instalments of

14. Display the Cust_Name and Loan_Amount

15. Display the Cust_Name and Loan_Amount

16. Display the details of all the loans which

18. Display the details of all the loans whose

19. Display the Cust_Name and Loan_Amount

20. Display the details of all the loans whose

22. Display the AccNo, Cust_Name and

23. Display the AccNo, Cust_Name and

24. Display the AccNo, Cust_Name and

26. Display the AccNo, Cust_Name and

27. Display the details of all the loans in the

28. Display the details of all the loans in the

30. Put the interest rate 11.50% for all the

31. Increase the interest rate by 0.5% for all

32. For each loan replace Interest with

33. Delete the records of all the loans whose

34. Delete the records of all the loans of ‘K.P.

36. SELECT cust_name, LENGTH(Cust_Name),

37. SELECT LEFT (Cust_Name,3), Right(Cust_Name,3)

39. SELCT DAYNAME(Start_Date) FROM Loan_Accounts;

40. SELECT ROUND(Int_Rate*110/100,2) FROM

41. SELECT POW(4,3), POW(3,4);

43. SELECT TRUNCATE(543.5694,2),

44. SELECT LENGTH(“Prof.M.L.Sharma”);

46. SELECT YEAR(CURDATE()),MONTH(CURDATE()),

47. SELECT DAYOFYEAR(CURDATE()),

48. SELECT LEFT(“Unicode”,3),RIGHT(“Unicode”,4);

50. SELECT MID(“Informatics”,3,4),SUBSTR(“Practice”,3);

You might also like