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
22. Which of the following is not a valid aggregate function?
- COUNT
- MIN
- MAX
- COMPUTE
23. mysql_pconnect() is used to make a persistent connection to the database which means a SQL link that do not close when the execution of your script ends.
- True
- False
24. What SQL clause is used to restrict the rows returned by a query?
- AND
- WHERE
- HAVING
- FROM
25. Which of the following is used to delete an entire MYSQL database?
- mysql_drop_database
- mysql_drop_entiredb
- mysql_drop_db
- mysql_drop_dbase
27. Primary Key does allow the Null Values. where as in Unique key doesn't accept the Null values. Question: True or False ?
- False
- True
29. Which of the following commands should be used to create a database named "student"?
- CREATE ?I student
- CREATE DATABASE student
- DATABASE /student
- DATABSE student
30. Which one will delete the table data as well as table structure?
- TRUNCATE
- DROP