1Z0-882 Exam Questions

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

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

You wish to create a trigger on the `city' table that will check the value of the `District' field before any INSERT. The trigger needs to change it to" Unknown" for an empty strin...

Using the query: SELECT Code FROM country WHERE Name = `united states' Which statement executed in the mysql client would create a prepared statement?

Which statement is true when working with PHP and prepared statement?

A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown: You modify the query and replace the SELECT operand with SELECT STRAIGHT...

You attempt to create a temporary table by using the following statement: CREATE TEMPORARY TABLE employeesMAIN SELECT * FROM employees1 UNION ALL SELECT * FROM employees2; What is...

Consider the table structure shown by this output: Mysql> desc city: 5 rows in set (0.00 sec) You execute this statement: SELECT -,-, city. * FROM city LIMIT 1 What is returned?

Examine this table that contains over two million rows of data: CREATE TABLE `news_feed' ( .id'bigint (20) NOT NULL AUTO _INCREMENT, .news _sources_id'varchar (11) NOT NULL, .datal...

In MYSQL 5.6 you have the table t1: CREATE TABLE t1 ( id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB; There are two connections to the server. They execute in this order: Co...

Assume that none of the databases exist. Which statement results in an error?

Which two code samples demonstrate valid methods for working with loops?

What are two ways in which normalizing your tables helps improve performance In MySQL?

You attempt to create two new tables: CREATE TABLE `warehouse' ( `id' int (11) NOT NULL AUTO_INCREMENT, `name' varchar (20) NOT NULL, `phone' varchar (20) NOT NULL, PRIMARY KEY (`...

Which statement correctly demonstrates using a subquery as a scalar expression?

Which statement is true about the difference between HASH and BTREE INDEXES?

You have created your connector/Net object to connect to MySQL. What are three valid database operations you can call?

Consider the query and its output: Mysql> SELECT Language As Lang FROM countrylanguage ->WHERE countrycode ='GBR'; A user wants to have an output as shown: What query would achieve...

Which three view types are not updateable?

When executing a stored routine, how is the SQL_MODE determined?

What is true about the contents of the INFORMATION_SCHEMATA table?

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

In the office table, the city column is structured as shown: Mysql> show columns from office like `city'\G --------------------1. row --------------------- Field: city Type: enum(`...

You have issued the statement: CREATE TABLE numbers (number INT NOT NULL) ENGINE=MYISAM What is the result of issuing the following statement: INSERT INTO numbers VALUES (NULL)

Assuming a table Country exists with a column Name, which of the following are valid uses of the LIMIT clause?

What keyword is missing from the following query in order to ensure that all results, including duplicates, are returned? SELECT time, action, user FROM log20040101 UNION SELECT ti...

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 MySQL command- line client is started with safe updates disabled. Mysql - -safe - updates=0 What happens when you execute an UPDATE statement without a WHERE clause?

Which condition must be true in order that a view is considered updateable?

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):...

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

You want to use the SHA -256 Authentication plugin with Connector/J. Which two parameter settings achieve this?

An application packs several fields of information into the details column of the table sensors. The first six characters of that data represent a location code. Example: "ABCDEFOO...

Consider the statements: Mysql> drop function foo; ERROR 1305 (420000): FUNCTION test, foo does not exist Mysql > show warnings; Mysql> get diagnostics condition 2 @msg=MESSAGE_TEX...

What would be the outcome when following statement is executed? SELECT Name FROM City WHERE CountryCode = 'USA' OR WHERE CountryCode = 'JPN'

Which of the following privileges is required for using TRUNCATE?

Which of the following are correct? A REPLACE statement may be used...

You want to create two databases, test and Test. Which of the following statements is true?

Your application is running slow. Which two features provide information that help to identify problems?

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

Consider the statement: CREATE TABLE t1 (a INT) PARTITION BY KEY /*150611 ALGORITHM = 1*/ What does this statement do?

Consider the table t1 created with this statement: CREATE TABLE t1( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Name CHAR (20) ENGINE=InnoDB; After inserting three rows, the table...

Inspect the SELECT query: Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date > `2008-10-11'; Guaranteed success with TestInsides...

Which statement describes the process of normalizing databases?

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?

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

You have a database `dev' that contains 15 tables, all of which use the CHARACTER SET `utfs' and the COLLATION `utfs_general_ci'. You perform the command: ALTER DATABASE `dev' CHAR...

A table (t1) contains 1000 random integer values in the first column (col1). The random values range from 1 to 1000. You execute this query: SELECT col1 FROM t1 WHERE col1< 100 UNI...

You started a MySQL command -Line session with sq1_ mode (empty), and created the person table with the structure: Mysql> DESC person; You issue: INSERT INTO person VALUES (`casper...

Consider the structure of the table countryLanguage and the distribution of the column Is official. DESCRIBE CountryLanguage; SELECT Isofficial, COUNT (Isofficial) FROM CountryLang...