Oracle 1z0-882 Exam Questions

Question 6 of 99

A floating- point column defined as FLOAT(7,5)allows___________

7 digits to the left of the decimal point and 5 digits to the right

5 digits to the left of the decimal point and 7 digits to the right

7 digits in total, of which 5 are to the right of the decimal point

7 digits in total, of which 5 are to the left of the decimal point

Correct Answer: C

Question 7 of 99

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

Question 8 of 99

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, C

To configure a PHP application to use the UTF8 character set, you can use the 'mysqli::set_charset' method to set the character set for a MySQLi connection and configure the PDO object to set the character set in the DSN string. Therefore, the correct methods are using 'mysqli::set_charset('utf8')' and setting the charset in the PDO DSN string like 'new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'user', 'pass');'.

Question 9 of 99

The data from t1 table is:
Exam 1z0-882: Question 9 - Image 1

Assuming You want to see this output:
Exam 1z0-882: Question 9 - Image 2

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

Question 10 of 99

Which three are valid identifiers for the user table in the mysq1 database?

myssq1. user

‘mysq1. user’

‘mysq1’. ‘user’

Mysq1. ‘user’

‘’mysq1. User’’

Correct Answer: B, C, D

In MySQL, valid identifiers for database and table names can be enclosed in backticks, single quotes, or used without any quotes provided they adhere to naming rules. Option B uses single quotes around the full identifier 'mysq1. user', which is valid. Option C properly encloses both the database name and table name in single quotes, ensuring the identifier is interpreted correctly. Option D shows a version with a combination of a regular database name and a quoted table name, which is also allowed in some MySQL contexts. Option A contains a typo, which makes it invalid. Option E has improper quotation marks around the identifier, which disqualifies it as a valid identifier.