Oracle 1z0-882 問題集

質問 1：
Using the query:
SELECT Code FROM country WHERE Name = 'united states'
Which statement executed in the mysql client would create a prepared statement?
A. PREPARE STATEMENT countrycode FROM 'SELECT code FROM counyry WHERE Name =?.;
B. PREPARE countrycode As 'SELECT code FROM country WHERE Name =?.;
C. PREPARE countrycode FROM 'SELECT code FROM country WHERE Name =?.;
D. PREPARE STATEMENT countrycode As 'SELECT code FROM country WHERE Name =?.;
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Consider a table my_table , with contents shown:

You execute:
SELECT a b, b a
FROM my_table
WHERE a < s
ORDER BY b;
What does this statement return?

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

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

質問 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?
A. SELECT UPPER (BINARY location) as location FROM MemberLocation
B. SELECT UPPER (Location) as location FROM MemberLocation
C. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation
D. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
When working with stored routines, these details are available:
The affected -rows count
The number of conditions that occurred
The condition information, such as the error code and message
Where can you find these default?
A. In the Handler area, defined in the DECLARE handler_action HANDLER block in a stored routine
B. In the Diagnostics area, part, of which can be stored in user-defined or routine variables
C. In the Signal area, which is set with the help of the SIGNAL statement in a stored routine
D. In the Error area, which can be accessed with the help of the SHOW ERRORS statement
正解：B

質問 6：
Examine this table that contains over two million rows of data:
CREATE TABLE 'news_feed' (
.id'bigint (20) NOT NULL AUTO _INCREMENT,
.news _sources_id'varchar (11) NOT NULL,
.dataline' datetime NOT NULL,
.headline' varchar (256) NOT NULL,
.story' text NOT NULL,.tag varchar (32768) DEFAULT NULL,
PRIMARY KEY ('id')
KEY 'dateline' ( 'dateline')
)
Examine this query that returns 332 rows of date:
SELECT *
FROM news_feed
WHERE DATE(dateline)= '2013-01-01'
Which change would show the greatest improvement in the response time of the query?
A. Use numeric equivalents for comparing the two dates:
SELECT. . .WHERE MOD(UNIX_TIMESTAMP (dateline), 86400 =UNIX_TIMESTAMP ('2013-01-01')
B. Use the LIKE operator:
SELECT . . .WHERE dateline LIKE '2013-10-01&'
C. Use a date range comparison:
SELECT . . . WHERE dateline >= '2013-01' and dateline < '2013-01-02'
D. USE the DATEDIFF function:
SELECT . . . WHERE DATEDIFF (dateline, '2013-01-01') = 0
正解：C

質問 7：
You have a database 'dev' that contains 15 tables, all of which use the CHARACTER SET 'utfs' and the COLLATION
'utfs_general_ci'.
You perform the command:
ALTER DATABASE 'dev' CHARACTER SET ='latin' COLLATION='latin1'_swedish_ci'
What is the result?
A. The statement succeeds and all of the tables inside the database are converted to user the new settings.
B. The statement succeeds and new tables created in this database use the new settings as their default values.
C. You get an error while trying to change from a more inclusive CHARACTER SET like 'utfs to a less' inclusive
CHARACTER SET like 'latin'.
D. You get an error because changes to the CHARACTER SET or COLLATION attribute can happen only for empty
databases.
E. You get an error because database are not allowed to have CHARACTER SET or COLLATION attributes.
F. You get an error because the settings for CHARACTER SET and COLLATION attributes do not match the settings for
the tables inside the database.
正解：B