1Z0-882 Exam Questions
110 real 1Z0-882 exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #51
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...
- Question #52
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...
- Question #53
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...
- Question #54
Using the query: SELECT Code FROM country WHERE Name = `united states' Which statement executed in the mysql client would create a prepared statement?
- Question #55
Which statement is true when working with PHP and prepared statement?
- Question #56
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...
- Question #57
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...
- Question #58
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?
- Question #59
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...
- Question #60
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...
- Question #61
Assume that none of the databases exist. Which statement results in an error?
- Question #62
Which two code samples demonstrate valid methods for working with loops?
- Question #63
What are two ways in which normalizing your tables helps improve performance In MySQL?
- Question #64
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 (`...
- Question #65
Which statement correctly demonstrates using a subquery as a scalar expression?
- Question #66
Which statement is true about the difference between HASH and BTREE INDEXES?
- Question #67
You have created your connector/Net object to connect to MySQL. What are three valid database operations you can call?
- Question #68
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...
- Question #69
Which three view types are not updateable?
- Question #70
When executing a stored routine, how is the SQL_MODE determined?
- Question #71
What is true about the contents of the INFORMATION_SCHEMATA table?
- Question #72
Which three are valid identifiers for the user table in the mysq1 database?
- Question #73
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(`...
- Question #74
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)
- Question #75
Assuming a table Country exists with a column Name, which of the following are valid uses of the LIMIT clause?
- Question #76
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...
- Question #77
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?
- Question #78
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?
- Question #79
Which condition must be true in order that a view is considered updateable?
- Question #80
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):...
- Question #81
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...
- Question #82
You want to use the SHA -256 Authentication plugin with Connector/J. Which two parameter settings achieve this?
- Question #83
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...
- Question #84
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...
- Question #85
What would be the outcome when following statement is executed? SELECT Name FROM City WHERE CountryCode = 'USA' OR WHERE CountryCode = 'JPN'
- Question #86
Which of the following privileges is required for using TRUNCATE?
- Question #87
Which of the following are correct? A REPLACE statement may be used...
- Question #88
You want to create two databases, test and Test. Which of the following statements is true?
- Question #89
Your application is running slow. Which two features provide information that help to identify problems?
- Question #90
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...
- Question #91
Consider the statement: CREATE TABLE t1 (a INT) PARTITION BY KEY /*150611 ALGORITHM = 1*/ What does this statement do?
- Question #92
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...
- Question #93
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...
- Question #94
Which statement describes the process of normalizing databases?
- Question #95
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?
- Question #96
Which two keywords cannot be used in multi-table deletes?
- Question #97
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...
- Question #98
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...
- Question #99
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...
- Question #100
Consider the structure of the table countryLanguage and the distribution of the column Is official. DESCRIBE CountryLanguage; SELECT Isofficial, COUNT (Isofficial) FROM CountryLang...