1Z0-882 Real Exam Questions and Verified Answers

Question 1 Single choice

What is true about the contents of the INFORMATION_SCHEMATA table?

A
It contains information about the table structure for all databases.
B
It contains information about all the tables, triggers, and views for all databases.
C
It contains information such as name, character set, and collation for all the databases on the server.
D
It contains information including tables, trigger, stored routines, and views for all databases

Show answer and explanation

Correct answer: B

Question 2 Single choice

Consider the stored procedure CREATE PROCEDURE param_test (
IN P_in INT,
OUT P_out INT,
INPUT P_inout INT)
BEGIN
SELECT P_in, P_out, P_ inout;
SET P_in, P_inout
END
You execute a series of commands:

What is the output of the CALL and SELECT?

A
(0,0,0) and (0,0,0)
B
(0,0,0,) and (0,200,300)
C
(0,NULL,0) and(0,200,300)
D
(0,NULL,0) and (100,200,300)

Show answer and explanation

Correct answer: A

Question 3 Single choice

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?

A
It does not delete anything from any table but returns an error.
B
It deletes one row from the parent table but does not affect the child table.
C
It deletes one row from the parent table and two rows from the child table.
D
It deletes one row from the parent table and sets the parent_id column to NULL in the child.

Show answer and explanation

Correct answer: A

Question 4 Single choice

You have been tasked to create a database that will store a list of all managers and the employees who report directly to them. The following is stipulated:

No manage is managing more than three people.
No employee can work for more than one manage.

Which of these designs represents a normalized schema that meets the project requirements?

A
CREATE TABLE `manager'
`manager' varchar (50) DEFAULT NULL,
`employee2' varchar (50) DEFAULT NULL,
`employee' varchar (50) DEFAULT NULL,
UNIQUE ( `manager `, `employee1', `employee2, `employee3') )
B
CREATE TABLE `managers' (
"id' int(11) NOT NULL AUTO_INCREMENT,
`manager' varchar (50) DEFAULT NULL ,
PRIMARY KEY (`id')
)
CREATE TABLE "employees' (
`id' int(11) NOT NULL AUTO_INCREMENT,
`manager_id' int(11) DEFAULT NULL,
`employee varchar (25) DEFAULT NULL,
PRIMARY KEY (`id')
)
C
CREATE TABLE `manager' (
`manager' varchar (50) DEFAULT NULL,
`employee_list'varchar (150) DEFAULT NULL,
)
D
CREATE TABLE `message' (
`id' int(11) NOT NULL AUTO_INCREMENT,
`manager' varchar(50) DEFAULT NULL,
PRIMARY KEY ("id')
)
CREATE TABLE `employees' (
`id int (11) NOT NULL AUTO_INCREMENT,
` employees' varchar(25) DEFAULT NULL,
)

Show answer and explanation

Correct answer: A

Question 5 Single choice

Consider a table my_table , with contents shown:

You execute:

SELECT a b, b a FROM my_table WHERE a < s
ORDER BY b;

What does this statement return?

A
Option A
B
Option B
C
Option C
D
Option D

Show answer and explanation

Correct answer: A

Question 6 Single choice

Consider the my_table table with two integer columns, a and b, and the contents as shown; Mysql >
SELECT a, b FROM my_table;

1 row in set result of this query?
SELECT a--b
FROM my_table;

A
0
B
2
C
4
D
An error message

Show answer and explanation

Correct answer: A

Question 7 Multiple choice

Which three statement types can be prepared?

A
LOAD DATA INFILE
B
CREATE TABLE
C
CREATE VIEW
D
ALTER VIEW
E
CALL

Show answer and explanation

Correct answers: A, B

Question 8 Single choice

Identity two ways to configure a PHP application to use the UTF8 character set.

A
mysqli: :query (`'SET NAMES utfs'');
B
mysqli : :set_charset (`utf8')
C
spdo = new PDO (`'mysql:host=localhost;dbname=test;charset=utfs'', user'', `'pass'');
D
PDO: :set_charset(`'utf8'')

Show answer and explanation

Correct answer: B

Question 9 Multiple choice

Which two keywords cannot be used in multi-table deletes?

A
USING
B
ORDER BY
C
LIMIT
D
IGNORE
E
JOIN

Show answer and explanation

Correct answers: B, C

Question 10 Single choice

Cormcctor/Net supports a decoupled database connection mode, where a database Connection is established only when needed.
'
Choose the three parts that are involved when working with decoupled data.

A
OpenConnect.MySql, DataTTiread.MySql, CommandExecutor.MySql
B
MySqlQueryBuIld, MySqlQuerytxer. MySq I Query Results
C
DecoupODBCConn, DecoupMyScjlruiiimanrt, DecoupMySqlRetum
D
DataSet, MySqlDataAdapter, MySql Command Builder

Show answer and explanation

Correct answer: D