1. By default, all print jobs have a priority of ____.

2. The like conditional operator is used by the _____ operand1.

3. Which choice is an example of an aggregate function?Which choice is an example of an aggregate function?

4. The mysqldump command cannot generate output in _.

5. What is the correct usage of ENUM in MySQL?

6. What function finds the current time or date in MySQL?

7. Inside a transaction, several operations need to be performed. What would you do if an exception happens during that transaction?

8. How are permissions implemented in MySQL?

9. What is the valid way to create a database view in MySQL?

10. The left and right joins are also known as _.

11. Which option modifier tells a program not to exit with an error if it does not recognize the option, but instead to issue a warning?

12. Why would you use a common table expression (CTE)?

13. When a new student is added to a new database, you want new records to be created in the related tables such as Exam, Score and Attendance. How would you accomplish this?

14. A stored routine is a set of SQL statements stored on the server and takes form as either a procedure or a function. Which statement cannot be used inside stored routines?

15. Which choice is not an available string type for a column?

16. How would you retrieve data on all the customers where no phone number is stored?

17. Explain the security aspect of stored procedures

18. What is the equivalent of the mysqladmin reload command?

19. Which statement is true about TIMESTAMP and DATETIME data types?

20. Which command will return a list of triggers in the current database?

21. What is the maximum number of columns that can be used by a single table index?

22. Which is a valid constructor for a class named User?

23. What is the advantage of using a temporary table instead of a heap table?

24. Which choice is not a valid model for a stored procedure parameter?

25. What is the product of the database designing phase?

26. Which query lists the databases on the current server?

27. If you want to use MyISAM instead of InnoDB, which option do you need to specify in the CREATE TABLE statement?

28. You are importing data as JSON into a new table. You run CREATE TABLE json_data ( city JSON ); and insert rows into this table. What is the correct syntax to see the list of cities?

29. You need to restore a MySQL database from a backup file. Which command-line tool do you use for the actual data import, after re-creating the database?

30. Which type of backup includes all the changes made to the data since the last full backup was performed?

31. When working with MySQL cursor, what must you also declare?

32. In data migration, there is often a need to delete duplicate rows as part of data cleanup. Which statement works best?

33. Which statement about the TRUNCATE TABLE statement is true?

34. You are loading data into a table. Which command can you use to make sure that all data is inserted and duplicates rows are discarded?

35. What is one reason to introduce data redundancy into a normalized database design?

36. In recent versions of MySQL (8.0+), what's the correct syntax to declare a CTE (Common Table Expression)?

37. Management has requested that you build an employee database. You need to include each employee's current position and salary, as well as all prior positions and salaries with the company. You decide to use a one-to-many structure: an employee table with the main information such as name and address, and an employment table with position and salary history. You can use the employeeID field to connect them. What is employment.employeeID an example of?

38. In which table does MySQL store passwords for user accounts?

39. Which choice is not one of the table maintenance statements?

40. How would you list the full set of tables in the currently selected database?

41. How can you list all columns for a given table?

42. What is the MySQL perror command-line utility used for?

43. Which choice is not a processing algorithm for database views?

44. You need to run a complex query with recursive subqueries, but without creating a stored procedure or a function. Which command or clause do you use?

45. You manage a database with a table "customers". You created a temporary table also called "customers" with which you are working for the duration of your session. You need to recreate the temporary table with different specs. Which command do you need to run first?

46. You need to make your mysql system secure against attackers. What are you not supposed to do?

47. You need to make an exact copy of a table, with all columns and indexes. How can you get all of the information needed to accomplish this?

48. Which is the correct syntax of an extended insert statement?

49. Which statement can you use to load data from a file into the table?

50. Later versions of mysql support the native json data type for storing json documents. What is a drawback of json columns?

51. What table cannot have a trigger associated with it?

52. What mysql statement is used to check which accounts have specific privileges?

53. Each time MySQL is upgraded, it is best to execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server. What does this command do, upon finding a table with a possible incompatibility?

54. What is the requirement for using a subquery in the SELECT clause?

55. One form of backup, replication, enables you to maintain identical data on multiple servers, as a _ configuration.

56. You need to export the data in the customers table into a CSV file, with columns headers in the first row. Which clause do you add to your MySQL command?

57. After installing MySQL, it may be necessary to initialize the _ which may be done automatically with some MySQL installation methods.

58. MySQL option files provide a way to specify commonly used options so that they need not be entered on the command line each time you run a program. What is another name for the option files?

59. In an efficiently designed relational database, what does every table have?

60. How do you select every row in a given table named "inventory"?

61. What is the difference between DROP and TRUNCATE?

62. How can you filter duplicate data while retrieving records from a table?

63. You are working with very large tables in your database. Which SQL clause do you use to prevent exceedingly large query results?

64. A trigger is a database object that is associated with a table, and that activates when a particular event occurs for the table. Which three events are these?

65. If you need to order a table of movies by name, which query will work?

66. How does MySQL differ from SQL?

67. In SELECT * FROM clients; what does clients represent?

68. Which choice is NOT a statement you would use to filter data?

69. How can you remove a record using MySQL?

70. In MySQL, queries are always followed by what character?

71. What is the best type of query for validating the format of an email address in a MySQL table?

72. Which MySQL command modifies data records in a table?

73. MySQL uses security based on _ for all connections, queries, and other operations that users can attempt to perform.

74. Which MySQL command shows the structure of a table?

75. MySQL programs are a set of command-line utilities that are provided with typical MySQL distributions. MySQL is designed to be a database.

76. MySQL server can operate in different SQL modes, depending on the value of the sql_mode system variable. Which mode changes syntax and behavior to conform more closely to standard SQL?

77. Which query would NOT be used to administer a MySQL server?

78. If you were building a table schema to store student grades as a letter (A, B, C, D, or F) which column type would be the best choice?

79. MySQL uses environment variables in some of the programs and command-line operations. Which variable is used by the shell to find MySQL programs?

80. Which option of most MySQL command-line programs can be used to get a description of the program's different options?

81. You must ensure the accuracy and reliability of the data in your database. You assign some constraints to limit the type of data that can go into a table. What type of constraints are you assigning?

82. You need to export the entire database, including the database objects, in addition to the data. Which command-line tool do you use?

83. When you have a subquery inside of the main query, which query is executed first?

84. If there is no index, the dbms will perform a _____ scan.

85. If an error occurs, each of the numeric functions returns a/an ____________ value.

86. Databases are stored in ______ so that they are available when needed.

87. Attributes may share a ____.

88. A distributed database is composed of several parts known as database _____.

89. A centralized database management is subject to a problem such as _____.

90. Which operators have the same precedence as the <= operator?

91. Which data types can have an additional attribute AUTO_iNCREMENT?

92. Which values do logical operators evaluate to in MySQL?

93. Result of the following query? SELECT ExtractValue()

94. What will be the result of the following query? SELECT STRCMP()

95. What is the result of the query?SELECT 'This\ls\Four\Lines';

96. Which correctly describes the RLIKE operator?

97. For the COERCIBILITYO function. what does coercibility value of 0 mean?

98. Result of the following two queries? 1. SELECT POW(2.2): 2. SELECT POWER(2.3):

99. Which operators are supported by boolean full-text search?

100. Invalid year data type values are converted to which of the following?