Oracle 1z0-882 問題集

質問 1：
These there tables represent a many -to-many relationship in asocial networking database:

This query draft is constructed to report for the past 30 days:
Which change will correct this query?

A. Option A
B. Option C
C. Option D
D. Option B
正解：D

質問 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. No; FOR EACH ROW is invalid syntax.
B. Yes; the trigger works correctly.
C. No; the OLD keyword cannot be used in an INSERT trigger.
D. No; the syntax should be CREATE TRIGGER city-bi ON city BEFORE INSERT....
正解：C

質問 3：
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?
A. (201,Pluto)
B. (101,Pluto)
C. (300,Pluto)
D. (200.pluto)
正解：A

質問 4：
Which statement is true about the difference between HASH and BTREE INDEXES?
A. HASH indexes support rightmost prefixing of keys, which makes them faster than BTREE indexes in many causes.
B. HASH indexes are used only for equality comparisons (= or<=>),whereas BTREE indexes can also be used for range
searches (>or<).
C. HASH indexes are much faster than BTREE indexes but can only be used for a single column.
D. HASH indexes can be used by the optimizer to speed up ORDER BY operations and not BTREE indexes.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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?
A. An error result as the function must be defined with the CONTAINS SQL clause.
B. An error result as the variable type returned by the function must be defined with a RETURNS clause.
C. An error results as the count variable is not initialized with a value.
D. An error results as the SELECT must assign the return values to a user variable.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three connector/J connection strings can be used to connect to the MYSQL server?
A. Jdbc :mysqli://localhost/test?user=xxx&password=xxx
B. Jdbc:mysql:proxy://localhost/test?user=xxx&password=xxx
C. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxx&password=xxx
D. Jdbc:mysq1://localhost/test?user =xxx&password=xxx
E. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxx&password=xxx
正解：C,D,E

質問 7：
You want to load data directly from a file into MYSQL by using the SOURCE command.
Which types of data can the file contains to perform this?
A. SQL commands
B. MyISAM or InnoDB data files
C. Comma-delimited data
D. Tab-delimited data
正解：A
解説: (Topexam メンバーにのみ表示されます)