MySQL Questions and Answers

Practice Mode
Showing 10 of 36 questions
Q31
The USE command?
  • A Is used to load code from another file
  • B Has been deprecated and should be avoided for security reasons
  • C Is a pseudonym for the SELECT command
  • D Should be used to choose the database you want to use once you've connected to MySQL
Answer: Option D
Q32
Given an employees table as follows: emp_id     emp_name 1     Brush 2     Jerrin what value will be return by below query ? Select count(*) from employees
  • A 3
  • B 2
  • C 1
  • D none of the above
Answer: Option B
Q33
The main MySQL program that does all the data handling is called?
  • A mysql.exe
  • B mysql
  • C mysqld
  • D httpd
Answer: Option C
Q34
A SELECT command without a WHERE clause returns?
  • A All the records from a table that match the previous WHERE clause
  • B All the records from a table, or information about all the records
  • C SELECT is invalid without a WHERE clause
  • D Nothing
Answer: Option B
Q35
MySQL Access security is controlled through?
  • A The ID that the user logged into the server through, and priveliges set up for that account.
  • B MySQL login accounts, and priveliges set for each account
  • C The normal login security is sufficient for MySQL, and it does not have any extra controls of its own.
  • D A table of valid IP addresses, and priveliges set up for each IP address
Answer: Option B
Q36
In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions.
  • A True
  • B Fasle
  • C Either True or False
  • D None of the above
Answer: Option A

📚 More from Database

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