Online Access Free 1z0-882 Practice Test

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 "p%_\_";
• D.SELECT code FROM operations WHERE code LIKE "p_\%\_";
• E.SELECT code FROM operations WHERE code LIKE " '%'%_' "ESCAPE " ' '';

Assume that the current database has a table with the following structure (the values for the Field column have been
removed for the purpose of this question)
Mysql > DEBS count trylanguage;

How can you select only the first two columns?

• A.It is not possible without using the column names or without using any other tables or queries.
• B.SELECT *{1,2} FROM Countrylanguage;
• C.SELECT 1, 2 FROM Countrylanguage;
• D.SELECT * (1), *[2] FROM Counyrylanguage;
• E.SELECT * FROM Counytrylanguage LIMIT 1, 2,

Which two can be used to obtain information stored in the Diagnostics Area?

• A.SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1
• B.GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT;
  SELECT @errno, @msg;
• C.SHOW WARNINGS
• D.SHOW GLOBAL STATUS LIKE 'Diagnostics'

Which condition must be true in order that a view is considered updateable?

• A.There must be a subquery in the WHERE clause that refers to a table in the FROM clause.
• B.The view must only refer to literal values.
• C.The user must have the UPDATE or DELETE privilege for the underlying table.
• D.There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.

Inspect the SELECT query:
Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date >
'2008-10-11';

2 rows in set (0.00 sec)
Which action will optimize the query?

• A.Add the keyword STRAIGHT_JOIN.
• B.Add an index on the to_ date column.
• C.Add an index to the employees. emp _no column.
• D.Add the FORCE INDEX (PRIMARY) optimizer hint for the employees table.