試験内容は定期的に見直されるため、古い教材では安心できません。GoShikenのOracle MySQL 8.0 Database Developer練習問題は2026年の出題範囲に沿って更新されており、1Z0-909の最新の出題傾向を押さえた内容です。ご購入後365日間は無料で最新版をご利用いただけます。

Oracle 1Z0-909 試験概要:

Oracle 1Z0-909 試験シラバストピック:

Oracle MySQL 8.0 Database Developerのよくある疑問を解決します

Oracle MySQL 8.0 Database Developer 認定 1Z0-909 試験問題：

問題 #1

Which select statement returns true?

A. SELECT NULL <=> NULL;
B. SELECT NULL = NULL;
C. SELECT NULL := NULL;
D. SELECT NULL <> NULL;

問題 #2

Examine these statements and output:

Now, examine this command:
Mysql> ROLLBACK;
What is true about the effect of the command?

A. It has no effect.
B. It undoes the insert command.
C. It undoes both insert and update commands.
D. It undoes the update command.
E. It returns an error because there is no active transaction.

問題 #3

You must reclaim memory used by a prepared statement named prep. Which two achieve this?

A. DEALLOCATE PREPARE prep?
B. DROP PREPARE prep;
C. PREPARE prep FROM '';
D. SET @a = ''; EXECUTE prep USING @a;
E. SET @prep = NULL;
F. DROP PROCEDURE prep;

問題 #4

Examine these statements issued from Session 1 which execute successfully:

Now, examine this statement issued from Session 2:

What is the outcome of the update statement in Session 2?

A. A deadlock will occur.
B. The statement will wait for the transaction in Session 1 to finish.
C. The row will be updated immediately.
D. The transaction in Session 1 will be rolled back automatically.

問題 #5

Examine these statements which execute successfully:

Which two changes will improve this query performance?

A. CREATE INDEX 1X7 ON users (user_name) USING HASH;
B. CREATE INDEX 1X4 ON Locations (site_id, loc_shared);
C. CREATE INDEX 1X5 ON users (loc_id);
D. CREATE INDEX 1X6 ON users (user_name);
E. CREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH
F. CREATE INDEX IX1 ON locations (loc_shareci) ;
G. CREATE INDEX 1X3 ON locations <loc_site_id) ;

解説：