1z1-882 by Oracle Actual Free Exam Questions And Answers

Question 1

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

A. 'mysq1. user'

B. myssq1. user

C. ''mysq1. User''

D. 'mysq1'. 'user'

E. Mysq1. 'user'

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 2

Your MYSQL server was successfully running for a days, and then suddenly stopped .You are sure that no mysqld
process is running.
Which two may provide diagnostic information to help determine why the MYSQL server stopped?

A. The slow query log file

B. The binary log file

C. The MYSQL server error log file

D. The syslog on Linux/UNIX or the Event view on windows

E. The general query log file

Discussion 0

Correct Answer: B,C Vote an answer

Question 3

When working with stored routines, these details are available:
The affected -rows count
The number of conditions that occurred
The condition information, such as the error code and message
Where can you find these default?

A. In the Signal area, which is set with the help of the SIGNAL statement in a stored routine

B. In the Error area, which can be accessed with the help of the SHOW ERRORS statement

C. In the Diagnostics area, part, of which can be stored in user-defined or routine variables

D. In the Handler area, defined in the DECLARE handler_action HANDLER block in a stored routine

Discussion 0

Correct Answer: C Vote an answer

Question 4

Examine the structure and content of the MemberLocation table:

You want to have the field location returned in all letters (example: BERLIN).
Which query would you use?

A. SELECT UPPER (Location) as location FROM MemberLocation

B. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation

C. SELECT UPPER (BINARY location) as location FROM MemberLocation

D. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

You have two tables:
CREATE TABLE department (
Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY,
Department _Name varchar(12) NOT NULL
) ENGINE=InnoDB
CREATE TABLE employee (
Employee_Number int unsigned NOT NULL PRIMARY KEY,
Employee_Name varchar(10) NOT NULL,
Department_ID int unsigned DEFAULT NULL,
FOREIGN KEY (Department ID) REFERENCES Department (Department_ID)
ON UPDATE SET NULL ON DELETE CASCADE
)ENGINE= InnoDB
The tables have the data:
Department

You execute the statement:
REPLACE INTO department (Department_ID, Department_Name) VALUES (1, 'Admin');
What data is in the employee table after the statement?

A. Option B

B. Option A

C. Option D

D. Option C

Discussion 0

Correct Answer: D Vote an answer

Question 6

Which three connector/J connection strings can be used to connect to the MYSQL server?

A. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxx&password=xxx

B. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxx&password=xxx

C. Jdbc:mysql:proxy://localhost/test?user=xxx&password=xxx

D. Jdbc:mysq1://localhost/test?user =xxx&password=xxx

E. Jdbc :mysqli://localhost/test?user=xxx&password=xxx

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 7

Which three statements describe valid reasons why queries that use "SELECT" construct are discouraged?

A. SELECT * prevents the use of indexes, so a full table scan for every query.

B. SELECT *causes your application to depend on the columns present when you wrote it , so your application could
break if the table structure changes.

C. SELECT * causes more data than you need to be sent via the client/server protocol if your application needs only
some columns.

D. SELECT * causes the statements to return all rows from the table.

E. SELECT * may cause more data than you need to be read from disk if your application needs only some columns.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 8

You have two test tables:
Code_innodb as InnoDB engine
Code_ myisam as MYISAM engine
The tables have the same structure:

The tables have one row of data:

You execute an INSERT statement on both code_myisam tables and receive duplicate key errors:
mysql> INSERT INTO code_innodb VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'charlie,),(4, 'Delta');
ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY'
Mysql> INSERT INTO code_myisam VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'charlie'),
(4, 'Delta');
ERROR 1062 (23000); Duplicate entry '3' for key 'PRIMARY'
What is the expected output of the SELECT statements?

A. Option B

B. Option A

C. Option D

D. Option C

Discussion 0

Correct Answer: B Vote an answer

Question 9

Consider the content of the class and student tables:
Class

Which three queries produce the same result?

A. SELECT *
FROM JOIN student
On class .class_id=student.class_id
WHERE NOT ISNULL (student.class_id)

B. SELECT *
FROM student
RIGHT JOIN class
ON class.class_id=student.class_id

C. SELECT *
FROM JOIN student
LEFT JOIN student
ON class. Class.class_id=student.class_id

D. SELECT *
FROM class
INNER JOIN student
WHERE NOT ISNULL (student.class_id)

E. SELECT *
FROM class
INNER JOIN student
ON class.class_id=student.class_id

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 10

Assume the user has just connected to the MySQL server.
What is the result of the query SELECT @ a?

A. A single NULL

B. The value of GLOBAL variable @ a

C. An empty string

D. An error that @ a is undefined

Discussion 0

Correct Answer: A Vote an answer

Oracle Certified Professional, MySQL 5.6 Developer - 1z1-882 Exam Practice Test

Contact Us

Useful Links

Latest Updated