Oracle Certified Professional, MySQL 5.6 Developer - 1z0-882무료 덤프문제 풀어보기
Consider the structure of the table countryLanguage and the distribution of the column Is official.
DESCRIBE CountryLanguage;
SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;
You add an index on the Isofficial column.
Which two statement are true?
DESCRIBE CountryLanguage;
SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;
You add an index on the Isofficial column.
Which two statement are true?
정답: A,C
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?
정답: A
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 true connecting the meaning of the warnings?
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 true connecting the meaning of the warnings?
정답: C,D
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_table;
Mysql > SELECT a, b FROM my_table;
1 row in set result of this query?
SELECT a-b
FROM my_table;
정답: A
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?
정답: A
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 contains:
These commands are executed:
DELETE FROM t1 WHERE id=200;
INSERT INTO t1 (name) VALUES ('pluto'):
Which data set is inserted in the table?
CREATE TABLE t1(
id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY,
Name CHAR (20)
ENGINE=InnoDB;
After inserting three rows, the table contains:
These commands are executed:
DELETE FROM t1 WHERE id=200;
INSERT INTO t1 (name) VALUES ('pluto'):
Which data set is inserted in the table?
정답: A
The people table contains the data as shown:
Which two statements return two rows each?
Which two statements return two rows each?
정답: B,E
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?
Which three are possible causes of the error?
정답: A,E,F
You have created your connector/Net object to connect to MySQL.
What are three valid database operations you can call?
What are three valid database operations you can call?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
Given the table City:
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
What does this statement procedure?
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
What does this statement procedure?
정답: B