Download Oracle.1z0-882.ExamsKey.2018-11-28.59q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-882 |
| Exam Name: | MySQL 5.6 Developer |
| Date: | Nov 28, 2018 |
| File Size: | 3 MB |
Demo Questions
Question 1
You try to add a foreign key to the InnoDB table employees:
Mysq1> ALTER TABLE employees ADD FOREIGN KEY (Department_ID) REFERENCES departments (Department_ID);
ERROR 1215 (HY000): cannot add foreign key constraint
Which command will provide additional information about the error?
- SHOW ERRORS
- Error 1215
- SHOW ENGINE INNODB STATUS
- SELECT FROM information_schema.INNODB_SYS_FOREIGN
Correct answer: A
Explanation:
Reference: http://zeering.com/LoadAnswers.aspx?q=Foreign%20Key%20constraint (see update) Reference: http://zeering.com/LoadAnswers.aspx?q=Foreign%20Key%20constraint (see update)
Question 2
Identity two ways to configure a PHP application to use the UTF8 character set.
- mysqli: :query (‘’SET NAMES utfs’’);
- mysqli : :set_charset (‘utf8’)
- spdo = new PDO (‘’mysql:host=localhost;dbname=test;charset=utfs’’, user’’, ‘’pass’’);
- PDO: :set_charset(‘’utf8’’)
Correct answer: B
Explanation:
Reference: http://stackoverflow.com/questions/5842980/a-permanent-way-of-doing-mysqli-set-charset Reference: http://stackoverflow.com/questions/5842980/a-permanent-way-of-doing-mysqli-set-charset
Question 3
The data from t1 table is:
Assuming You want to see this output:
Which query achieves the preceding result?
- SELECT name FROM t1 WHERE name LIKE ,_e%
- SELECT name FROM t1 WHERE name LIKE,e%.;
- SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;
- SELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;
Correct answer: C
Explanation:
