Oracle 1z0-882 問題集

質問 1：
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?
A. (2,8) and (10,8)
B. (7,1) and (1,4)
C. (2,8) and (1,4)
D. (7,1) and (10,8)
正解：B

質問 2：
Which three statement types can be prepared?
A. CREATE TABLE
B. LOAD DATA INFILE
C. ALTER VIEW
D. CREATE VIEW
E. CALL
正解：A,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three are valid identifiers for the user table in the mysq1 database?
A. 'mysq1'. 'user'
B. 'mysq1. user'
C. Mysq1. 'user'
D. myssq1. user
E. ''mysq1. User''
正解：A,C,D

質問 4：
Consider the statement:
CREATE TABLE t1 (a INT) PARTITION BY KEY
/*150611 ALGORITHM = 1*/
What does this statement do?
A. Create the t1 table partitioned by KEY with the default algorithm in all versions.
B. Create the t1 table partitioned by KEY using algorithm 1 only if the preceding statement returned error condition
50611.
C. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL version 5.6.11 and the default algorithm in
other versions.
D. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL versions 5.6.11 or newer and the default
algorithm in older versions.
正解：D

質問 5：
Which three statements describe valid reasons why queries that use "SELECT" construct are discouraged?
A. SELECT * prevents the use of indexes, so a full table scan for every query.
B. SELECT * causes more data than you need to be sent via the client/server protocol if your application needs only
some columns.
C. SELECT *causes your application to depend on the columns present when you wrote it , so your application could
break if the table structure changes.
D. SELECT * may cause more data than you need to be read from disk if your application needs only some columns.
E. SELECT * causes the statements to return all rows from the table.
正解：B,C,D

質問 6：
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 メンバーにのみ表示されます)

質問 7：
The tab-delimited file"/tmp/people,txt contains:
1636 Carsten Pederson Denmark
4672 Kai Voigt Germany
4628 Max Mether France
This is the structure of the people table:
Mysq1> DESCRIBE people;

Which statement will load the first and last names into the Names column and the country into the country column?
A. LOAD DATA INFILE '/tmp/people,txt, INTO TABLE People.
(@Skip. @First, @Last, @Country)
Country=@country
B. LOAD DATA INFILE '/tmp/people.txt ' INTO TABLE People
@ Skip=$1 , @ First=$2, @Last=$3, @ Country=4,
(CONCAT (@First, ' ' .@ Last) , @ Country)
C. LOAD DATA INFILE '/tmp/people.txt'INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4
(CONCAT (@First, ' ',@Last) , @ Country)
D. It is not possible to load the data from the file/tmp/people.txt into the people table,as shown.
E. LOAD DATA INFILE '/tmp/people.txt 'INTO TABLE People
(@ Skip, @First , @Last, @Country
SET Name=CONCAT (@First, ' ',@Last)
正解：E