DBMS-MySQL Question and Answer

DBMS-MySQL Question and Answer
21. A table may be joined to itself.
  • True
  • false
  • None of the above
Show Answer
22. Which of the following is not a valid aggregate function?
  • COUNT
  • MIN
  • MAX
  • COMPUTE
Show Answer
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
Show Answer
24. What SQL clause is used to restrict the rows returned by a query?
  • AND
  • WHERE
  • HAVING
  • FROM
Show Answer
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
Show Answer
26. MySQL supports the complete SQL99 standard
  • false
  • true
Show Answer
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
Show Answer
28. How much character are allowed to create database name?
  • 55
  • 72
  • 64
  • 40
Show Answer
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
Show Answer
30. Which one will delete the table data as well as table structure?
  • TRUNCATE
  • DROP
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test