Oracle Database Administration I 試験対策問題集

模擬試験モードの設定

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

出題分野

• Oracle Database Architecture and Instances（構成要素とインスタンスの管理）（出題比率 13%）
• Users, Roles, Privileges, and Oracle Net Services（権限と接続）（出題比率 13%）
• Managing Storage（記憶域と領域の管理）（出題比率 8%）
• Managing Tablespaces, Datafiles, and Undo（表領域と UNDO 領域）（出題比率 11%）
• Moving Data and Oracle-Supplied Tools（データの移動と付属ツール）（出題比率 8%）
• Retrieving, Restricting, and Sorting Data（データの取得と絞り込み）（出題比率 11%）
• Single-Row Functions, Conversion, and Time Zones（単一行関数と変換）（出題比率 11%）
• Joins, SET Operators, Group Functions, Subqueries（結合と集計）（出題比率 14%）
• DDL, DML, Views, and Other Schema Objects（オブジェクトの管理）（出題比率 11%）

フリー問題

1. A tuning discussion turns to which shared memory structure holds which kind of c…
2. An architect explains that one database can be associated with more than one ins…
3. A new administrator is asked to describe what is running on the server once the …
4. A team wants to hand out a fixed set of privileges to twenty accounts and to cha…
5. A new account is created with a default tablespace named for the application dat…
6. A profile sets both a limit on the number of failed logon attempts and a limit o…
7. A history table is loaded once a month and is then read but never updated. Which…
8. A tablespace is created with automatic segment space management. Which statement…
9. A trainee asks how a tablespace relates to the files on disk and how a table rel…
10. A transaction updates several rows in different tables. Which statement about ho…
11. A dump file produced on one server is copied to the second server and the import…
12. One script has to serve fourteen departments without being edited for each of th…
13. A report adds a bonus column to a salary column and some rows come back empty in…
14. A code column stores digits as text and the report has to sort them in numeric o…
15. A trainee is told that some functions are single-row functions and others are gr…
16. Two queries with different numbers of selected columns are combined with a set o…
17. A list has to keep every product even when no order refers to it. The author wri…
18. An employee table holds the identifier of each manager in one of its own columns…
19. A parent row is deleted while a child table still holds rows that point at it an…
20. A long batch inserts rows in three phases and the operator wants to be able to u…