Oracle AI Database SQL Associate 試験対策問題集

模擬試験モードの設定

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

出題分野

• Relational Concepts, SELECT, Restricting, Sorting（基礎と検索）（出題比率 20%）
• Using Functions（単一行関数・変換関数・グループ関数）（出題比率 25%）
• Multiple Tables, Subqueries, SET Operators（結合・副問合せ・集合演算）（出題比率 20%）
• DML, and Indexes, Synonyms, Sequences（DML と索引・シノニム・順序）（出題比率 10%）
• Use DDL to manage tables and their relationships（表と制約とビュー）（出題比率 15%）
• User Access, Dictionary Views, Time Zones（権限・辞書・時間帯）（出題比率 10%）

フリー問題

1. A load inserts a zero length string into a character column and a later query th…
2. A developer loads twenty rows into a table and later runs a query on it with no …
3. A query selects a department identifier and a job identifier from an employee ta…
4. A query builds a mailing line by concatenating a street column and a suite colum…
5. A developer writes NULLIF and passes the literal null as the first argument and …
6. A query calls SUBSTR on a telephone column with a starting position of minus fou…
7. A weekly report truncates each date to the start of its week and the buckets beg…
8. A long lived script relies on implicit conversion between a character column and…
9. A query applies INITCAP to a column that holds values such as jean o'brien and m…
10. A query lists two tables in the FROM clause and joins them on a shared departmen…
11. Three ways of writing an equijoin are available and a team has to pick one for a…
12. A developer combines two queries with UNION. The first query selects three colum…
13. A query joins two tables with the NATURAL keyword. Both tables hold a department…
14. A session updates two hundred rows and has not issued a COMMIT yet. A second ses…
15. A reporting user has to read a table that lives in another schema and the team d…
16. A batch job has to empty a table that holds ten million rows before it reloads t…
17. An error message names a constraint that nobody recognizes and the name looks ma…
18. A column that stores a country code is declared as a fixed length character type…
19. A new account has to be able to log in and to build its own tables and it also h…
20. A session sets its time zone to a value that differs from the time zone of the m…