Oracle 1z0-882 問題集

質問 1：
A MySQL command- line client is started with safe updates disabled.
Mysql - -safe - updates=0
What happens when you execute an UPDATE statement without a WHERE clause?
A. Causes a syntax error
B. Results in an error
C. Updates every row in the specified table(s)
D. Results in - -safe-updates being enabled automatically
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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

質問 3：
The friends table has the columns and contents as shown:
Mysql> SELECT * FROM friends;

This statement was executed:
SELECT AVG (age) FROM friends
What value is returned?
A. 0
B. NULL
C. 10
D. 20
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which statement describes the process of normalizing databases?
A. Redundant tables are combined into one larger table to simplify the schema design.
B. Columns that contain repeating data values are split into separate tables to reduce item duplication.
C. Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest
allocation.
D. Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.
E. All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.
正解：B

質問 5：
Cormcctor/Net supports a decoupled database connection mode, where a database Connection is established only
when needed.
'
Choose the three parts that are involved when working with decoupled data.
A. OpenConnect.MySql, DataTTiread.MySql, CommandExecutor.MySql
B. DataSet, MySqlDataAdapter, MySql Command Builder
C. DecoupODBCConn, DecoupMyScjlruiiimanrt, DecoupMySqlRetum
D. MySqlQueryBuIld, MySqlQuerytxer. MySq I Query Results
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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

質問 7：
Which two code samples demonstrate valid methods for working with loops?
A. DECLARE i INT DEFAULT 0;
Test _loop; LOOP
SET i =i +1;
IF i >=5 THEN LEAVE;
END IF;
END LOOP test_loop;
B. DECLARE i INT DEFAULT 0;
WHILE i < 5 Do
SET i = i + 1;
END WHILE;
C. DECLARE I INT DEFAULT 0;
Test_loop: LOOP
SET i =i +1;
IF i> =5 THEN
LEAVE test_loop;
END IF;
END LOOP test_loop;
D. DECLARE i INT DEFAULT 0;
WHILE I < 5ITERATE
SET i = i +1;
END WHILE;
正解：B,C