최신 1z1-882 무료덤프 - Oracle Certified Professional, MySQL 5.6 Developer
A table (t1) contains 1000 random integer values in the first column (col1).The random values are in the range of 0-
1000.
Examine this query:
SELECT col1 FROM t1 WHERE col1 <=100 UNION
SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC
What is the expected output?
1000.
Examine this query:
SELECT col1 FROM t1 WHERE col1 <=100 UNION
SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC
What is the expected output?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Given the data from table t1:
This DELETE command is executed:
DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;
Which set of rows will be deleted by the command?
This DELETE command is executed:
DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;
Which set of rows will be deleted by the command?
정답: B
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?
정답: B,E
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?
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?
정답: C
Which statement correctly demonstrates using a subquery as a scalar expression?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
Which two queries return a value of NULL?
정답: B,D
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
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?
You want to have the field location returned in all letters (example: BERLIN).
Which query would you use?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
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?
정답:
You have two tables:
CREATE TABLE department (
Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY,
Department _Name varchar(12) NOT NULL
) ENGINE=InnoDB
CREATE TABLE employee (
Employee_Number int unsigned NOT NULL PRIMARY KEY,
Employee_Name varchar(10) NOT NULL,
Department_ID int unsigned DEFAULT NULL,
FOREIGN KEY (Department ID) REFERENCES Department (Department_ID)
ON UPDATE SET NULL ON DELETE CASCADE
)ENGINE= InnoDB
The tables have the data:
Department
You execute the statement:
REPLACE INTO department (Department_ID, Department_Name) VALUES (1, 'Admin');
What data is in the employee table after the statement?
CREATE TABLE department (
Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY,
Department _Name varchar(12) NOT NULL
) ENGINE=InnoDB
CREATE TABLE employee (
Employee_Number int unsigned NOT NULL PRIMARY KEY,
Employee_Name varchar(10) NOT NULL,
Department_ID int unsigned DEFAULT NULL,
FOREIGN KEY (Department ID) REFERENCES Department (Department_ID)
ON UPDATE SET NULL ON DELETE CASCADE
)ENGINE= InnoDB
The tables have the data:
Department
You execute the statement:
REPLACE INTO department (Department_ID, Department_Name) VALUES (1, 'Admin');
What data is in the employee table after the statement?
정답: B