1Z0-882 Real Exam Questions

Given the table City: SELECT Name FROM City WHERE CountryCode = `USA" OR WHERE CountryCode= `JPN' What does this statementprocedure?

Consider the my_table table with these contents: You execute: SELECT 1 FROM my_table; What is the result?

You wish to create a trigger on the country table. It will populate two session variables based on the row that is deleted: @old _countryNames with the value of the Name field @old _countryName with the value of the code field You may assume that only one row is ever deleted at a time. CREATE TRIGGER Country_ad AFTER DELETE ON Country FOR EACH ROW SET @old _CountryName= NEW.Name, @ old _CountryCode=NEW.Code; What is the outcome of the CREATE TRIGGER statement?

The contents of the parent and child tables are: The child table has the parent_id column that has a foreign key constraint to the id column of the parent table with ON DELETE CASCADE clause. Consider the command WHERE id =1; What is the effect of the above command?

In the office table, the city column is structured as shown: Mysql> show columns from office like `city'\G --------------------1. row --------------------- Field: city Type: enum(`paris'.'Amsterdam'.'New York'.'Tokyo') Null: Yes Key: Default:NULL Extra: Consider the output of the SELECT query executed on the office table: Mysql> SELECT DISTINCT city FROM office ORDER BY city: If the query is written as: SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR) In what order are the rows returned?