Oracle Database SQL 試験対策問題集

模擬試験モードの設定

上記は本サイトの模擬試験モードの設定値です。実際の試験の出題数・制限時間・合格基準は、各認定プログラムの公式サイトでご確認ください。

出題分野

• Relational Database Concepts and SQL SELECT（関係モデルと SELECT）（出題比率 13%）
• Controlling User Access and Data Dictionary Views（権限とデータ辞書）（出題比率 6%）
• Restricting and Sorting Data（行の絞り込みと並べ替え）（出題比率 10%）
• Single-Row Functions and Time Zones（単一行関数と時間帯）（出題比率 10%）
• Conversion Functions and Conditional Expressions（変換関数と条件式）（出題比率 6%）
• Group Functions and Subqueries（集計と副問い合わせ）（出題比率 10%）
• Data from Multiple Tables and SET Operators（結合と集合演算子）（出題比率 16%）
• Managing Tables using DML statements（DML とトランザクション）（出題比率 9%）
• Use DDL to manage tables and their relationships（DDL と制約）（出題比率 14%）
• Managing Indexes, Synonyms, Sequences, and Views（索引とビュー）（出題比率 6%）

フリー問題

1. A query computes salary + commission_pct * salary as the total for every employe…
2. A report builds a display name by joining a first name, a middle name and a last…
3. A team is turning an entity relationship diagram into a query. The diagram shows…
4. A new developer needs to build tables in the developer's own schema and also nee…
5. A WHERE clause reads job_id = 'SA_REP' OR job_id = 'AD_VP' AND salary > 15000 an…
6. A report has to show the five highest paid employees. The writer adds FETCH FIRS…
7. A query needs the length of service of each employee. The developer writes SYSDA…
8. A query contains MOD(salary, bonus_divisor) and some rows hold a zero in bonus_d…
9. A query must show a null where the current job code equals the previous job code…
10. A query has to list the departments whose average salary is above 8000, and has …
11. A developer writes WHERE salary > AVG(salary) in a query over one table and rece…
12. Two queries each return a list of product identifiers, and some identifiers appe…
13. A salary grade table holds a lowest value and a highest value for each grade. A …
14. Two tables share the column names department_id and manager_id. A developer join…
15. A session updates 40 rows without committing, then issues a CREATE TABLE stateme…
16. A load job has to copy the rows of last year from a live table into an archive t…
17. A very large table has a column that the application no longer reads. The team w…
18. Two sessions both insert rows into the same global temporary table and then both…
19. A developer writes a CREATE TABLE statement and puts every constraint after the …
20. A team creates a public synonym for a table so that every user can write the sho…