1Z0-882 Exam Questions

Given the data: Expected output: Which query produces the expected output?

Which three statement types can be prepared?

A SELECT statement without an ORDER BY clause return some rows. Which statement is always true about the order of the returned results?

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_...

Inspect the CREATE TABLE below: Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB; Query Ok, 0 rows affected, 2 warnings (0.11 sec) Mysql> SHOW WARNINGS; Which two is...

Which of the following statements will add two columns of INT type to the `country` table?

The query below is attempting to CREATE a table based on the definition of the `world` table, including any column attributes and indexes. What is missing? CREATE TABLE t1 ______ w...

Which of the following will CREATE a table with exactly one multi-column index?

The people table contains the data as shown: Which two statements return two rows each?

Which two queries return a value of NULL?

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 mes...

The data from t1 table is: Assuming You want to see this output: Which query achieves the preceding result?

Consider the CREATE FUNCTION statement: CREATE FUNCTION countrycount () BEGIN DECLARE count INT; SELECT COUNT (*) INTO count FROM country; RETURN count ; END What is the outcome wh...

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 pr...

Which three database objects have non-case-sensitive names on all operating system?

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 s...

As a developer, you inherit this table as part of a project: CREATE TABLE exam ( Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY, Examinee_id INTEGER UNSIGNED UNIQUE, Score INTEGER U...

Which two Functions can be used in a C program to retrieve information about warning?

Consider the content of the class and student tables: Class Which three queries produce the same result?

You want to load data directly from a file into MYSQL by using the SOURCE command. Which types of data can the file contains to perform this?

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

Inspect the query: Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004'; 4 rows in set (0.00 sec) Mysql>EXPLAIN SELECT dept_no, emp_no F...

You create a table and a stored procedure: CREATE TABLE t1 (f1 int); INSERT INTO t1 VALUES (1), (2) , (3), (4), (5); CREATE PROCEDURE sum_t1() BEGIN DECLARE done INT DEFAULT 0; DEC...

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

You have two tables: news_source and news_feed. Here is some sample data from the news _feed table:

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

Assume that the current database has a table with the following structure (the values for the Field column have been removed for the purpose of this question) Mysql > DEBS count tr...

You execute this EXPLAIN statement for a SELECT statement on the table named comics.which contains 1183 rows: Mysql> explain select comic_ title, publisher from comics where comic_...

The friends table has the columns and contents as shown: Mysql> SELECT * FROM friends; This statement was executed: SELECT AVG (age) FROM friends What value is returned?

You wish to create a trigger on the country table. It will populate two session variables based on the row that is deleted: @old _countryNames with the value of the Name field @old...

Given the data from table t1: This DELETE command is executed: DELETE FROM t1 ORDER BY b.a DESC LIMIT 2; Which set of rows will be deleted by the command?

A table (t1) contains 1000 random integer values in the first column (col1). The random values are in the range of 0-1000. Examine this query: SELECT col1 FROM t1 WHERE col1 <=100...

You have access to a MySQL 5.6 database with the SELECT ,INSERT, and DELETE privileges on all tables in the mydb database. The mydb database. The mydb t1 table has five rows of dat...

You have two lists of values to correlate. Which query lists all names in colors1 and how many total matches are there in colors2?

Given the table City: SELECT Name FROM City WHERE CountryCode = `USA" OR WHERE CountryCode= `JPN' What does this statementprocedure?

Inspect the query: Mysql> SELECT count (emp_no) FROM titles WHERE title = `senior staff'; How can this query be optimized?

Examine the fruit and wine tables: Fruit You execute this query: SELECT fruited, fruitname FROM fruit UNION SELECT id, name, country FROM wine; What is the result?

The tab-delimited file"/tmp/people,txt contains: 1636 Carsten Pederson Denmark 4672 Kai Voigt Germany 4628 Max Mether France This is the structure of the people table: Mysq1> DESCR...

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 c...

Which two PHP modules provide APIs for developing MYSQL applications?

Which two can be used to obtain information stored in the Diagnostics Area?

Consider the structures of the country and countrylanguage tables. mysql >DESCRIBE country; mysql> DESCRIBE countrylanguage; Which query will give you the list of all European coun...

Assume your connection uses SQL mode ANSI_QUOTES. Which two statements cause a syntax error?

Consider the my_table table with these contents: You execute: SELECT 1 FROM my_table; What is the result?

Using the MYSQL command -Line client you have received the error "Lost connection to MYSQL server query" Which three are possible causes of the error?

An application tracks usage of educational courses in a company. Many people can take one course. Each person can take multiple courses. The data has been stored in one table but i...

Which two statements provide the definition for a view named view1 in the test database?

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

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 em...

These there tables represent a many -to-many relationship in asocial networking database: This query draft is constructed to report for the past 30 days: Which change will correct...