最新的Oracle Certified Professional, MySQL 5.6 Developer - 1z1-882免費考試真題
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?
Mysql - -safe - updates=0
What happens when you execute an UPDATE statement without a WHERE clause?
正確答案: A
說明：（僅 Fast2test 成員可見）
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 the result?
CREATE TEMPORARY TABLE employeesMAIN
SELECT * FROM employees1
UNION ALL
SELECT * FROM employees2;
What is the result?
正確答案: D
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', 'undefined')
What is the effect?
structure:
Mysql> DESC person;
You issue:
INSERT INTO person VALUES ('casper', 'undefined')
What is the effect?
正確答案:
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 JOIN.
What is the effect of adding STRAIGHT JOINs to the query?
You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN.
What is the effect of adding STRAIGHT JOINs to the query?
正確答案: C
Your application is running slow.
Which two features provide information that help to identify problems?
Which two features provide information that help to identify problems?
正確答案: B,C
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?
You execute:
SELECT a b, b a
FROM my_table
WHERE a < s
ORDER BY b;
What does this statement return?
正確答案: A
When executing a stored routine, how is the SQL_MODE determined?
正確答案: D
說明：（僅 Fast2test 成員可見）
Which three view types are not updateable?
正確答案: A,C,D
說明：（僅 Fast2test 成員可見）
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?
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?
正確答案: D
Which three database objects have non-case-sensitive names on all operating system?
正確答案: B,C,D
說明：（僅 Fast2test 成員可見）