MySQL Questions and Answers

Practice Mode
Showing 10 of 36 questions
Q21
A table may be joined to itself.
  • A True
  • B false
  • C None of the above
Answer: Option A
Q22
Which of the following is not a valid aggregate function?
  • A COUNT
  • B MIN
  • C MAX
  • D COMPUTE
Answer: Option D
Q23
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.
  • A True
  • B False
Answer: Option A
Q24
What SQL clause is used to restrict the rows returned by a query?
  • A AND
  • B WHERE
  • C HAVING
  • D FROM
Answer: Option B
Q25
Which of the following is used to delete an entire MYSQL database?
  • A mysql_drop_database
  • B mysql_drop_entiredb
  • C mysql_drop_db
  • D mysql_drop_dbase
Answer: Option C
Q26
MySQL supports the complete SQL99 standard
  • A false
  • B true
Answer: Option A
Q27
Primary Key does allow the Null Values. where as in Unique key doesn't accept the Null values. Question: True or False ?
  • A False
  • B True
Answer: Option A
Q28
How much character are allowed to create database name?
  • A 55
  • B 72
  • C 64
  • D 40
Answer: Option C
Q29
Which of the following commands should be used to create a database named "student"?
  • A CREATE ?I student
  • B CREATE DATABASE student
  • C DATABASE /student
  • D DATABSE student
Answer: Option B
Q30
Which one will delete the table data as well as table structure?
  • A TRUNCATE
  • B DROP
Answer: Option B

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test