1Z0-882 Online Practice Questions and Answers
The application logs contain many entries of the following:
ERROR 1153 (OSSO1): Got a packet bigger than `max_allowed_packet' bytes With two scenarios can
(Hibernate this error message?
A. The application tried to INSERT a row that exceeded max_allowed_packet.
B. The network caused an error Inducing the max_allowed_packet error.
C. The application did not use the COMPRESS () function for a large result set.
D. The application tried to SELECT many rows together that exceeded max__allowed_packet.
E. The application tried to SELECT a row that exceeded max_allowed_packet.
F. The operating system caused an error inducing the max_allowed_packet error.
Which two Functions can be used in a C program to retrieve information about warning?
A. mysql_info
B. mysql_error
C. mysql_warning_count
D. mysql_errno
You have a transaction that queries a table at the beginning of the transaction and performs the same
query later.
Which two transaction isolation levels guarantee that you get the same results both times?
A. Repeatable read
B. Read committed
C. Read uncommitted
D. Single user
E. serializable
Which two can be used to obtain information stored in the Diagnostics Area?
A. SHOW WARNINGS
B. GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT; SELECT @errno, @msg;
C. SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1
D. SHOW GLOBAL STATUS LIKE `Diagnostics'
Which three view types are not updateable?
A. A view created with the TEMPTABLE algorithm
B. A view containing a GROUP BY clause
C. A view containing a WHERE clause
D. A view containing a HAVING clause
E. A view that contains a literal column
Which two keywords cannot be used in multi-table deletes?
A. USING
B. ORDER BY
C. LIMIT
D. IGNORE
E. JOIN
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, )
The city table has the following structure:
Consider the statement with an incorrect field name:
PREPARE countryBYID FROM `SELECT country FROM city WHERE ID=?, What happens if a prepared
statement named countryByID already exists when the above statement is executed?
A. A duplicate name error will result because a prepared statement with the same name already exists.
B. An unknown column error will result and the old prepared statement definition will remain in effect.
C. An unknown column error will result and no prepared statement named countryByID will exist.
D. A warning will result and the old prepared statement definition will remain in effect.
Which three statement types can be prepared?
A. LOAD DATA INFILE
B. CREATE TABLE
C. CREATE VIEW
D. ALTER VIEW
E. CALL
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