Online Access Free 1z1-882 Exam Questions

Consider the structure of the table countryLanguage and the distribution of the column Is official.
DESCRIBE CountryLanguage;

SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;

You add an index on the Isofficial column.
Which two statement are true?

• A.The optimizer will choose the index when Isofficial='T' is in the WHERE clause.
• B.The optimizer will choose the index when Isofficial='F' is in the WHERE clause.
• C.The speed of INSERT statements to this table will be unchanged.
• D.The speed of INSERT statements to this table will be reduced.
• E.The optimizer will not choose the index on the Isofficial column.
• F.The speed of INSERT statements to this table will be improved.

You want to query the VARCHAR column ' code' values that match:
Start with "p"
End with "_"
Contain more than 3 characters
Assume that sql_mode is blank.
Which two queries select only those rows?

• A.SELECT code FROM operations WHERE code LIKE "p%_\_";
• B.SELECT code FROM operations WHERE code LIKE "p_%_%;_"ESCAPE "/";
• C.SELECT code FROM operations WHERE code LIKE " '%'%_' "ESCAPE " ' '';
• D.SELECT code FROM operations WHERE code LIKE "p%%_";
• E.SELECT code FROM operations WHERE code LIKE "p_\%\_";

You execute this EXPLAIN statement for a SELECT statement on the table named comics.which contains 1183 rows:
Mysql> explain select comic_ title, publisher from comics where comic_title like '& Action&';

row in set (0.00 sec)
You create the following index:
CREATE INDEX cimic_title_idx ON comics (comic_title, publisher);
You run the same EXPLAIN statement again;
Mysql > explain select comic_title ,publisher from comics where comic_title like '& Action&';

1 row in set (0.00 sec)
Why did the second SELECT statement need to read all 1183 rows in the index comic_title_idx?

• A.Because a LIKE statement always requires a full tables scan
• B.Because comic _title is part of acovering index
• C.Because comic_title is not the primary key
• D.Because a wildcard character is at the beginning of the search word

Which three view types are not updateable?

• A.A view containing a HAVING clause
• B.A view containing a WHERE clause
• C.A view containing a GROUP BY clause
• D.A view that contains a literal column
• E.A view created with the TEMPTABLE algorithm

When executing a stored routine, how is the SQL_MODE determined?

• A.By using TRADITTIONAL regardless of any other settings
• B.By the default SQL_MODE of the server
• C.By the current SQL _MODE of the session
• D.By the SQL_MODE that was set when the routine was defined