最新的Oracle Certified Professional, MySQL 5.6 Developer - 1z0-882免費考試真題
You are connected to a MySQL server and using a prepared statement. You accidentally exit your session.
What will happen if you log back in to use your prepared statement?
What will happen if you log back in to use your prepared statement?
正確答案: B
說明：（僅 Fast2test 成員可見）
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,
.dataline' datetime NOT NULL,
.headline' varchar (256) NOT NULL,
.story' text NOT NULL,.tag varchar (32768) DEFAULT NULL,
PRIMARY KEY ('id')
KEY 'dateline' ( 'dateline')
)
Examine this query that returns 332 rows of date:
SELECT *
FROM news_feed
WHERE DATE(dateline)= '2013-01-01'
Which change would show the greatest improvement in the response time of the query?
CREATE TABLE 'news_feed' (
.id'bigint (20) NOT NULL AUTO _INCREMENT,
.news _sources_id'varchar (11) NOT NULL,
.dataline' datetime NOT NULL,
.headline' varchar (256) NOT NULL,
.story' text NOT NULL,.tag varchar (32768) DEFAULT NULL,
PRIMARY KEY ('id')
KEY 'dateline' ( 'dateline')
)
Examine this query that returns 332 rows of date:
SELECT *
FROM news_feed
WHERE DATE(dateline)= '2013-01-01'
Which change would show the greatest improvement in the response time of the query?
正確答案: A
A statement exists that can duplicate the definition of the 'world'table.
What is missing?
CREATE TABLE t1 ___________world
What is missing?
CREATE TABLE t1 ___________world
正確答案: A
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 CASCADE clause.
Consider the command WHERE id =1;
What is the effect of the above command?
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 CASCADE clause.
Consider the command WHERE id =1;
What is the effect of the above command?
正確答案: A
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 two keywords cannot be used in multi-table deletes?
正確答案: C,D
說明：（僅 Fast2test 成員可見）
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?
Fruit
You execute this query:
SELECT fruited, fruitname FROM fruit
UNION
SELECT id, name, country FROM wine;
What is the result?
正確答案: C
Which statement correctly demonstrates using a subquery as a scalar expression?
正確答案: C
說明：（僅 Fast2test 成員可見）
Identity two ways to configure a PHP application to use the UTF8 character set.
正確答案: C,D
說明：（僅 Fast2test 成員可見）
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_TEXT;
What is the result of the final statement?
Mysql> drop function foo;
ERROR 1305 (420000): FUNCTION test, foo does not exist
Mysql > show warnings;
Mysql> get diagnostics condition 2 @msg=MESSAGE_TEXT;
What is the result of the final statement?
正確答案: D