최신Oracle Certified Professional, MySQL 5.6 Developer - 1z1-882무료샘플문제
문제1
You want to compare all columns of table A to columns with matching names in table B.
You want to select the rows where those have the same values on both tables.
Which query accomplishes this?
You want to compare all columns of table A to columns with matching names in table B.
You want to select the rows where those have the same values on both tables.
Which query accomplishes this?
정답: B
문제2
A statement exists that can duplicate the definition of the 'world'table.
What is missing?
CREATE TABLE t1 ___________world
A statement exists that can duplicate the definition of the 'world'table.
What is missing?
CREATE TABLE t1 ___________world
정답: D
문제3
Given the table City:
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
What does this statement procedure?
Given the table City:
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
What does this statement procedure?
정답: D
문제4
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?
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?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
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?
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?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제6
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?
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?
정답: C
문제7
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): cannot add foreign key constraint
Which command will provide additional information about the error?
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): cannot add foreign key constraint
Which command will provide additional information about the error?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
Consider the CREATE FUNCTION statement:
CREATE FUNCTION countrycount ()
BEGIN
DECLARE count INT;
SELECT COUNT (*) INTO count FROM country;
RETURN count ;
END
What is the outcome when you try to create the function?
Consider the CREATE FUNCTION statement:
CREATE FUNCTION countrycount ()
BEGIN
DECLARE count INT;
SELECT COUNT (*) INTO count FROM country;
RETURN count ;
END
What is the outcome when you try to create the function?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제9
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 -ooozzz comments will be here FIELDS----FIELD64"
Given the query pattern:
SELECT ... FROM sensors WHERE details LIKE 'ABCDEF%'
Which three ALTER TABLE commands enable the optimizer to user an index for this WHERE patterns?
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 -ooozzz comments will be here FIELDS----FIELD64"
Given the query pattern:
SELECT ... FROM sensors WHERE details LIKE 'ABCDEF%'
Which three ALTER TABLE commands enable the optimizer to user an index for this WHERE patterns?
정답: A,D,E
문제10
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?
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?
정답: B