MYSQL Viva Questions for Practical Exam
CLICK FOR CLASS 12 COMPUTER SCIENCE PRACTICAL QUESTION PAPER (SOLVED)
Click for Python Viva Questions
Q1. What is DBMS?
Q2. What is the full form of RDBMS.
Q3. Give two example of DBMS.
Q4. What is table in DBMS?
Q5. What is record in a table?
Q6. What is field in a table?
Q7. What are the advantages of DBMS?
Q8. Name the three types of relationship that can be formed in RDBMS.
Q9. What do you mean by Degree and Cardinality?
Q10. What is Primary Key in a table?
MYSQL Viva Questions for Practical Exam
Q11. What do you mean by Candidate key?
Q12. What is alternate key in a table?
Q13. Define Foreign Key.
Q14. What is referential integrity in DBMS?
Q15. What is MySQL?
Q16. What is SQL?
Q17. Expand DML and DDL.
Q18. Give two example of DDL commands
Q19. Give two examples of DML commands.
Q20. Define data type.
MYSQL Viva Questions for Practical Exam
Q21. Differentiate between Char and Varchar?
Q22. What is NULL value in MySQL?
Q23. What do you mean by comments in MySQL?
Q24. Which symbols are used to give Single line and Multiple line comment in MySQL?
Q25. Write a command to display all the existing databases in MySQL.
Q26. Define constraint in MySQL.
Q27. Name any two commonly used constraint.
Q28. What is the difference between Unique and Primary Key constraint?
Q29. Write a command to display the structure of table “Stock”
Q30. Which constraint ensures that a column can not have a NULL value?
MYSQL Viva Questions for Practical Exam
Q31. What is the difference between Update and Alter command in MySQL?
Q32. What is the difference between the following queries?
- Delete from Book;
- Delete from Book where price > 400;
Q33. Write a command to make Book_id as primary key after creating the table.
Q34. Which command is used to add a new column in a table?
Q35. Write a command to add a new column “Price” in a table “Book”.
Q36. What is the meaning of float(6,2)?
Q37. Write a command to delete a column “Price” from table “Book”.
Q38. Write a command to rename a column “Price” to “Amount” of table “Book”.
Q39. What is the difference between Delete and Drop command?
Q40. Write a command to delete the table “Book”.
MYSQL Viva Questions for Practical Exam
Q41. Which command is used to remove the database?
Q42. Name the command used to fetch data from the table.
Q43. What is the purpose of Order by Clause?
Q44. What is the output of the following command?
Select 5 + NULL;
Q45. Which operator is used for pattern matching?
Q46. Name two wildcard symbols which are used in MySQL for pattern matching.
Q47. Which wildcard character is used for single character?
Q48. Correct the following query
Select * from Book where Price = NULL;
Q49. By default Order by clause arrange records in _________________ order.
Q50. Which pattern is used along with Like operator to display only those names which ends with ‘na’?
MYSQL Viva Questions for Practical Exam
Q51. Which pattern is used along with Like operator to display only those names which starts with ‘na’?
Q52. Which pattern is used along with Like operator to display only those names which contains ‘na’?
Q53. Which pattern is used along with Like operator to display only those names which contains only four characters?
Q54. Which pattern is used along with Like operator to display only those names which ends with ‘na’ and contains total 6 characters?
Q55. Which symbol is used for “Not equals to” relational operator?
Q56. Name the clause which is used to display unique values from a column.
Q57. Name three logical operators in MySQL.
Q58. How many values return by aggregate functions in MySQL?
Q59. What do you mean by aggregate function?
Q60. Give two examples of aggregate functions.
MYSQL Viva Questions for Practical Exam
Q61. Which aggregate function return the total number of values in a column?
Q62. What is the difference between Count( ) and Count(*)?
Q63. Which aggregate function return the lowest value from a specific column?
Q64. Which aggregate function return the largest value from a specific column?
Q65. Which aggregate function return the addition of all the numeric values in a column?
Q66. Which aggregate function return the average of all the numeric values in a column?
Q67. Write a command to find the average of column “Price” in table “Book”
Q68. What would be the output of the following query?
| Price |
| 3000 |
| 2500 |
| NULL |
| 3500 |
Select AVG(Price) from Book;
Q69. Differentiate between Order by and Group by clause.
Q70. What is function?
MYSQL Viva Questions for Practical Exam
Q71. Name two types of functions available in MySQL.
Q72. Name any two single row functions.
Q73. Name a string function which returns the character for each integer passed.
Q74. Which function concatenates two string in MySQL?
Q75. What is the purpose of lower() function in MySQL?
Q76. Name a function which converts the string into uppercase.
Q77. In MySQL, which function extracts a substring from a given string?
Q78. Write the output of the following query:
Select substr(“CSIPLEARNINGHUB”,3,7); [/showhide]
Q79. Which function removes the leading spaces from the left of the given string?
Q80. Which function removes the leading and trailing spaces from the given string?
MYSQL Viva Questions for Practical Exam
Q81. Name a function which returns the length of the given string.
Q82. Write the output of the following:
Select len(substr(“Computer Science”, 4, 8));
Q83. Write the output of the following:
Select instr(“Corporate”, “or”);
Q84. Name any two String functions of MySQL which return numeric value.
Q85. Which function of MySQL returns the specific number of characters from the left side of the string.
Q86. How many arguments can be passed to substr() function in sql?
Q87. Name any two numeric functions of MySQL.
Q88. Write the output of the following:
Select mod(9, 2);
Q89. Write the output of the following:
Select mod(9, 12);
Q90. Is Power() a mathematical function in SQL?
MYSQL Viva Questions for Practical Exam
Q91. What is Power( ) function in SQL?
Q92. Write the output of the following.
Select round(15.164, 1);
Q93. Write a statement to round off value 15.164 to nearest tens.
Q94. Write a statement to find the square root of 25.
Q95. Write a statement to truncate value 12.67 to one decimal place.
Q96. Which function returns the current date?
Q97. Write a query to display the current date of your system.
Q98. Name a function which extracts the month part from date expression.
Q99. Which function returns the name of the month in MySQL?
Q100. Write the output of the following.
Select Day(“2015-05-13”)
MYSQL Viva Questions for Practical Exam
Q101. What is the difference between Monthname( ) and Dayname() function in MySQL?
Q102. Differentiate between Month( ) and Day( ) function in MySQL?
Q103. What is the difference between Now( ) and Sysdate( )?
Q104. What will be the output of : Select Concat(“CS”, “IP”, “IT”)
Q105. What are the two types of comment styles in MySQL?
Q106. What is Join in MySQL?
Q107. Define Equi Join.
Q108. What is Natural Join?
Q109. Differentiate between Numeric and String Functions.
CLICK FOR CLASS 12 COMPUTER SCIENCE PRACTICAL QUESTION PAPER (SOLVED)
Click for Python Viva Questions
MySQL Viva Questions Class 12
MySQL Viva Questions Class 12
2. Flow of Control (Loop and Conditional statement)
3. 140+ MCQ on Introduction to Python
4. 120 MCQ on String in Python
7. 100+ MCQ on Flow of Control in Python
8. 60+ MCQ on Dictionary in Python
Important Links
100 Practice Questions on Python Fundamentals
120+ MySQL Practice Questions
90+ Practice Questions on List
50+ Output based Practice Questions
100 Practice Questions on String
70 Practice Questions on Loops
70 Practice Questions on if-else
Disclaimer : I tried to give you the correct Questions and Answers of ”MySQL Viva Questions“ , but if you feel that there is/are mistakes in the Questions or Answers of “MySQL Viva Questions “ given above, you can directly contact me at csiplearninghub@gmail.com. The above MCQs are created for practice of students.