MySQL Questions and Answers
MySQL database questions with answers focus on SQL queries, data manipulation, and database design — essential skills for any software developer. These programming questions and answers with explanations cover SELECT, JOIN, GROUP BY, indexes, and stored procedures. Practicing MySQL aptitude test questions improves your ability to write efficient queries and solve practical database problems. Ideal for TCS, Infosys, and Accenture placement preparation, these MCQs and exercises strengthen your command over relational database concepts, ensuring success in both programming interviews and technical assessments.
MySQL
Showing 10 of
36 questions
11. To remove duplicate rows from the result set of a SELECT use the following keyword:
- NO DUPLICATE
- UNIQUE
- DISTINCT
- None of the above
12. Which of the following can add a row to a table?
- Add
- Insert
- Update
- Alter
13. To use MySQL on your computer, you'll need?
- FTP and Telnet
- Some sort of client program to access the databases
- A Browser
- Perl, PHP or Java
14. Which SQL statement is used to insert a new data in a database?
- INSERT INTO
- UPDATE
- ADD
- INSERT NEW
15. In a LIKE clause, you can could ask for any value ending in "qpt" by writing
- LIKE %qpt
- LIKE *ton
- LIKE ton$
- LIKE ^.*ton$
17. MySQL is
- A Programming language
- A Programming language
- A technique for writing reliable programs
- A Relational Database Management System
18. In a LIKE clause, you can ask for any 6 letter value by writing?
- LIKE ??????
- LIKE .{6} Answer 5: LIKE ^.{6}$
- LIKE ...... (that's six dots)
- LIKE ______ (that's six underscore characters)
19. The result of a SELECT statement can contain duplicate rows.
- False
- True
- None of the above