DBMS-MySQL Question and Answer
DBMS-MySQL Question and Answer
31. The USE command?
- Is used to load code from another file
- Has been deprecated and should be avoided for security reasons
- Is a pseudonym for the SELECT command
- Should be used to choose the database you want to use once you've connected to MySQL
32. 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
emp_id emp_name
1 Brush
2 Jerrin
what value will be return by below query ?
Select count(*) from employees
- 3
- 2
- 1
- none of the above
33. The main MySQL program that does all the data handling is called?
- mysql.exe
- mysql
- mysqld
- httpd
34. A SELECT command without a WHERE clause returns?
- All the records from a table that match the previous WHERE clause
- All the records from a table, or information about all the records
- SELECT is invalid without a WHERE clause
- Nothing
35. MySQL Access security is controlled through?
- The ID that the user logged into the server through, and priveliges set up for that account.
- MySQL login accounts, and priveliges set for each account
- The normal login security is sufficient for MySQL, and it does not have any extra controls of its own.
- A table of valid IP addresses, and priveliges set up for each IP address
36. In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions.
- True
- Fasle
- Either True or False
- None of the above