1z1-882無料問題集「Oracle Certified Professional, MySQL 5.6 Developer」

質問 1

Consider the structures of the country and countrylanguage tables.
mysql >DESCRIBE country;

mysql> DESCRIBE countrylanguage;

Which query will give you the list of all European countries where German is spoken?

（A）SELECT Code AS c, Name
FROM Country
WHERE Continent = ' Europe'
AND EXIST ANY (
SELECT Language, CountryCode
FROM CountryLanguage
WHERE CountryCode =Code
AND Language = 'German'
)

（B）SELECT Code AS c, Name
FROM Country
WHERE Continent = 'Europe'
AND (
SELECT *
FROM CountryLanguage
WHERE CountryCode =Code
AND Language ='German'
)

（C）SELECT Code AS c, Name
FROM Country
WHERE Continent = 'Europe'
AND EXISTS (
SELECT *
FROM CountryLanguage
WHERE CountryCode = Code
And Language= 'German'
)

（D）SELECT Code AS c, Name
FROM Country
WHERE Continent = 'Europe'
AND Name IN (
SELECT *
FROM CountryLanguage
WHERE CountryCode = Code
AND Language ='German'
)

正解：C 解答を投票する

質問 2

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 string or NULL.
CREATE TRIGGER City_bi
BEFORE INSERT ON CITY
FOR EACH ROW
BEGIN
IF OLD. District IS NULL OR OLD.District= . .
THEN
SET NEW.District='Unknown';
END IF :
END;
Does the CREATE TRIGGER statement accomplish this goal?

（A）Yes; the trigger works correctly.

（B）No; the syntax should be CREATE TRIGGER city-bi ON city BEFORE INSERT....

（C）No; the OLD keyword cannot be used in an INSERT trigger.

（D）No; FOR EACH ROW is invalid syntax.

正解：C 解答を投票する

質問 3

The data from t1 table is:

Assuming You want to see this output:

Which query achieves the preceding result?

（A）SELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;

（B）SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;

（C）SELECT name FROM t1 WHERE name LIKE ,_e%

（D）SELECT name FROM t1 WHERE name LIKE,e%.;

正解：B 解答を投票する

質問 4

Identity two ways to configure a PHP application to use the UTF8 character set.

（A）spdo = new PDO (''mysql:host=localhost;dbname=test;charset=utfs'', user'', ''pass'');

（B）PDO: :set_charset(''utf8'')

（C）mysqli: :query (''SET NAMES utfs'');

（D）mysqli : :set_charset ('utf8')

正解：A、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

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:
Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Connection 1> START TRANSACTION;
Connection 1> SELECT * FROM t1 WHERE id =1;
Connection 2> TRUNCATE TABLE t1;
What happens to the TRUNCATE TABLE command in connection 2?

（A）It runs concurrently with the transaction in connection 1 as each connection has its own view of the data in the t1
table.

（B）It blocks waiting for a table lock until the transaction in connection 1 ends.

（C）It immediately proceeds and causes an implicit commit of the transaction in connection1.

（D）It blocks waiting for a metadata lock until the transaction in connection 1 ends.

正解：D 解答を投票する

質問 6

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 this?

（A）SELECT GROUP_CSV(Language) As Lang FROM countrylanguage WHERE countrycode='GBR';

（B）SELECT GROUP_CONCAT (Language) As Lang FROM countrylanguage WHERE countrycode='GBR';

（C）SELECT GROUP_IMPLODE (Language) As Lang FROM countrylanguage WHERE countrycode= 'GBR';

（D）SELECT GROUP_CAT(Language) As Lang FROM countrylanguage WHERE countrycode='GBR';

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

Given the data:

Expected output:

Which query produces the expected output?

（A）SELECT colors2.name,colors1.name
FROM colors2
LEFT JOIN colors1
ON colors2.name=colors1.name

（B）SELECT colors2.name,colors1.name
FROM colors2
RIGHT JOIN colors1
ON colors2.name=colors1.name

（C）SELECT colors2.name, colors1.name
FROM colors2
NATURAL JOIN colors1
ON colors2.name=colors1.name

（D）SELECT colors2.name, colors1.name
FROM colors2
OPTIONAL JOIN colors1
ON colors2.name, colors1.name

（E）SELECT colors2.name, colors1.name
FROM colors2
STRAIGHT JOIN colors1
ON colors2.name, =colors1.name

正解：B 解答を投票する

質問 8

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 more than three people.
No employee can work for more than one manage.
Which of these designs represents a normalized schema that meets the project requirements?

（A）CREATE TABLE 'message' (
'id' int(11) NOT NULL AUTO_INCREMENT,
'manager' varchar(50) DEFAULT NULL,
PRIMARY KEY ("id')
)
CREATE TABLE 'employees' (
'id int (11) NOT NULL AUTO _INCREMENT,
'employees' varchar(25) DEFAULT NULL,
)

（B）CREATE TABLE 'manager' (
'manager' varchar (50) DEFAULT NULL,
'employee_list'varchar (150) DEFAULT NULL,
)

（C）CREATE TABLE 'manager'
'manager' varchar (50) DEFAULT NULL,
'employee2' varchar (50) DEFAULT NULL,
'employee' varchar (50) DEFAULT NULL,
UNIQUE ( 'manager ', 'employee1', 'employee2, 'employee3')
)

（D）CREATE TABLE 'managers' (
"id' int(11) NOT NULL AUTO_INCREMENT,
'manager' varchar (50) DEFAULT NULL ,
PRIMARY KEY ('id')
)
CREATE TABLE "employees' (
'id' int(11) NOT NULL AUTO _INCREMENT,
'manager_id' int(11) DEFAULT NULL,
'employee varchar (25) DEFAULT NULL,
PRIMARY KEY ('id')
)

正解：C 解答を投票する

質問 9

You want to query the VARCHAR column ' code' values that match:
Start with "p"
End with "_"
Contain more than 3 characters
Assume that sql_mode is blank.
Which two queries select only those rows?

（A）SELECT code FROM operations WHERE code LIKE "p_\%\_";

（B）SELECT code FROM operations WHERE code LIKE " '%'%_' "ESCAPE " ' '';

（C）SELECT code FROM operations WHERE code LIKE "p%%_";

（D）SELECT code FROM operations WHERE code LIKE "p_%_%;_"ESCAPE "/";

（E）SELECT code FROM operations WHERE code LIKE "p%_\_";

正解：A、E 解答を投票する

質問 10

You create a new,empty database called 'test'. You want to change the database 's CHARACTER SET to "latin1" and the
database 'sCOLLATION to 'latin_german_ci'.
Which statement is true?

（A）You can do this one command:
ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_german_ci

（B）Databases do not have CHARACTER SET or COLLATION attributes.

（C）You cannot change the CHARACTER set or COLLATION value on an existing database.

（D）You can only do this with two separate commands:
ALTER DATABASE 'test' CHARACTER SET latin1
ALTER DATABASE 'test' COLLATE latin_german1_ci

正解：A 解答を投票する

1z1-882 無料問題集「Oracle Certified Professional, MySQL 5.6 Developer」

弊社を連絡する

関連リンク

トップ試験