MYSQL

Questions

1. Which of the following statements are true about SQL injection attacks?
2. Which of the following is an alternative to Subquery Factoring?
3. Which of the following will select the highest-priced record per item?
4. Which of the following will restore a MySQL DB from a .dump file?
5. How can an user quickly rename a MySQL database for InnoDB?
6. Which is the query to determine the Authors who have written at least 1 book with a popularity rating of less than 5?
7. The Flush statement cannot be used for:
8. What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?
9. What will be the query to display the courses in which the number of students enrolled is more than 5?
10. Which of the following statements is true?
11. Consider the query: SELECT name FROM Students WHERE name LIKE ‘_a%’; Which names will be displayed?
12. Which of the following is the best MySQL data type for currency values?
13. What are MySQL Spatial Data Types in the following list?
14. Which of the following formats does the date field accept by default?
15. Which of the following statements relating to Alias names is true?
16. What is the name of the utility used to extract NDB configuration information?
17. Which of the following is the correct way to change the character set to UTF8?
18. To quote a string within a string, which of the following can you use?
19. Which one of the following must be specified in every DELETE statement?
20. Which query will return values containing strings “Pizza”, “Burger”, or “Hotdog” in the database?
21. Which of the following will reset the MySQL password for a particular user?
22. Which of the following is the best way to modify a table to allow null values?
23. Which of the following will dump the whole MySQL database to a file?
24. Which of the following statements is true regarding character sets in MySQL?
25. Which of the following is an alternative to groupwise maximum ranking (ex. ROW_NUMBER() in MS SQL)?
26. Which query will determine how many books have a popularity rating of more than 7 on each subject?
27. Which of the following are true in case of Indexes for MYISAM Tables?
28. What will happen if two tables in a database are named rating and RATING?
29. SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000; Which of the following statements is correct with regard to this code?
30. Which of the following statement will results in 0 (false)?
31. Which query will display data from the Pers table relating to Analyst, Clerk and Salesman who joined between 1/1/2005 and 1/2/2005 ?
32. How can a InnoDB database be backed up without locking the tables?
33. What does the term “overhead” mean in MySQL?
34. Consider the following queries: create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade); Which of the following statements is true?
35. Which of the following statements are true?
36. Which of the following statements is used to change the structure of a table once it has been created?
37. Which of the following will show when a table in a MySQL database was last updated?
38. Which of the following results in 0 (false)?
39. What is the main purpose of InnoDB over MyISAM?
40. View the following Create statement: Create table Pers( EmpNo Int not null, EName Char not null, Join_dt Date not null, Pay Int ) Which line contains an error?
41. Which of the following is not a String column types?
42. What will happen if some of the columns in a table are of char datatype and others are of varchar datatype?
43. If you insert (00) as the value of the year in a date column, what will be stored in the database?
44. Which of the following statements is true is regards to whether the schema integration problem between development, test, and production servers can be solved?
45. What is true regarding the TIMESTAMP data type?
46. Which of the following is not a SQL operator?
47. What will happen if you write the following statement on the MySQL prompt? SELECT NOW();
48. Assuming the column col1 in table tab1 has the following values: 2,3,NULL,2,3,1 What will be the output of the select statement below? SELECT count(col1) FROM tab1
49. What is true about the ENUM data type?
50. Which of the following statements grants permission to Peter with password Software?
51. What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;
52. Which of the following is not a MySQL statement?
53. When running the following SELECT query: SELECT ID FROM ( SELECT ID, name FROM ( SELECT * FROM employee ) ); The error message ‘Every derived table must have its own alias’ appears. Which of the following is the best solution for this error?
54. The REPLACE statement is:
55. Which of the following is the best way to disable caching for a query?
56. What is the maximum size of a row in a MyISAM table?
57. Which of the following are not Numeric column types?
58. Which of the following statements is true regarding multi-table querying in MySQL?
59. Consider the following table definition: CREATE TABLE table1 ( column1 INT, column2 INT, column3 INT, column4 INT ) Which one of the following is the correct syntax for adding the column, “column2a” after column2, to the table shown above?
60. Examine the data in the employees table given below: last_name department_id salary ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries will execute well?