Free certification test prep

Q32. Examine this statement and output:

Which will provide the same level of detail when the error is encountered within a stored routine?

Q33. Examine this event’s metadata:

Now examine this command:
DROP USER ‘userl’e’localhost’;
Which effect will the command have on the event?

Q34. Examine these statements issued from Session 1 which execute successfully:

Now, examine this statement issued from Session 2:

What is the outcome of the update statement in Session 2?

Q35. Examine these statements issued from Session 1 which execute successfully:

Now, examine these statements issued from Session 2 which execute successfully:
Session 2>
BEGIN;
UPDATE band SET song=CONCAT (“Here Comes the “, song) WHERE song LIKE ‘ %Sun ; Which two are true?

Q36. Examine these statement which execute successfully:

Now, examine this desired output:

Which two queries will produce the out?

Q37. Examine this statement and output:

Now, examine these desired output values:

Which statement updates the table data as require

Q38. You must write a statement that combines the first_name and last_name columns from the employees table as “last_name, first_name.” Which two statements will do this?

Q39. Examine this statement which has executed successfully:

Q40. Examine the appointments table definition which contains one million rows:

Now, examine this statement which executes successfully:

Which statement will improve query performance?

Q41. Which two differences exist between the timestamp and date time data types?

Q42. Examine the employee table structure:

Which set of statements immediately returns empname for a given emp_id by using a parameterized prepare statement?
A)



D)

Q43. Examine this table definition:

The table must always remain a valid document store collection. What restriction does this impose on any added column?

Q44. Examine these commands and output:

Which is true?

Q45. Examine the contents of these tables:

Now examine the expected results for a user with privileges to access the table:

Which query returns the expected results?
A)

B)

C)

D)

Q46. Examine the Test.php script which is numbered for clarity, and its output:

PHP Fatal error: Uncaught Error: call to underined function mysqli_connect () in Test.php:2 Which action will fix this error?

Q47. Examine this statement which has executed successfully:

Q48. Examine the Test.php script which is numbered for clarity, and its output:

PHP Fatal error: Uncaught Error: call to underined function mysqli_connect () in Test.php:2 Which action will fix this error?

Q49. Examine the statement which executes successfully:
SET sql_mode=’ NO_ENGINE_SUBSTITTJTION’ ;
You try to create a table with a storage engine that is not available. What will happen?

Q50. Examine this statement and output:

What causes the error?

Q51. The employee table includes these columns:
e_id INT, e_name VARCHAR (45), dept_id INT salart INT
You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.
Which statement will create the function?
A)

B)

C)

D)

Q52. The meeting table stores meeting schedules with participants from five continents. The participants’ details are stored in another table.

You need to adjust the start_time and duration columns for optimal storage. What datatype changes would achieve this?

Q53. Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2:

Now, examine this statement that execute successfully in s1:
S1> SELECT * FROM emp;
Which is true about the result of the select statement?

Q54. Which select statement returns true?