Oracle 1Z0-042 考試概覽:
| 認證廠商: | Oracle |
| 考試名稱: | Oracle Database 10g:系統管理 I |
| 考試代碼: | 1Z0-042 |
| 考試費用: | 約 125 美元 |
| 及格分數: | 68% |
| 實際考試題數: | 90 |
| 考試時間: | 120 minutes |
| 支援語言: | English, 其他語言,依考試中心提供而定 |
| 相關認證: | Oracle Database 10g:系統管理 II (1Z0-043) Oracle Database SQL Fundamentals (1Z0-051) |
| 證照有效期限: | 終身有效(Oracle 10g 認證雖已停辦,但依其歷史規定為永久有效) |
| 考試形式: | 選擇題, 線性出題模式 |
| 範例考題: | Oracle 1Z0-042 範例考題 |
| 考試方式: | 於授權考試中心(Prometric)或 Oracle 核准之管道進行實體考試 |
| 必備條件: | 無正式報考門檻,惟通常建議具備 SQL 語法與資料庫管理相關概念之經驗 |
| 官方大綱網址: | https://www.oracle.com/education/certification/ |
Oracle 1Z0-042 考試大綱主題:
| 章節 | 目標 |
|---|---|
| 備份、復原與效能調校 | - 資料庫備份概念 - 效能監控與復原基礎概念 |
| 安裝與設定 | - 資料庫設定輔助工具 - 安裝 Oracle Database 10g 軟體 |
| Oracle Database 架構與概念 | - 記憶體結構與處理程序 - 資料庫元件與執行個體架構 |
| 資料庫建立與管理 | - 建立與控管資料庫 - 管理資料表空間與資料檔 |
| 網路與 Oracle Net Services | - 設定接聽程式與 tnsnames.ora - 用戶端連線方式 |
| 使用者安全與管理 | - 角色管理與安全機制 - 建立使用者帳戶與權限配置 |
最新的 10g DBA 1Z0-042 免費考試真題:
1. While planning to manage more than one database in your system, you perform the following activities:
1.Organize different categories of files into independent subdirectories.
2.Use consistent naming convention for database files.
3.Separate administrative information pertaining to each database.
Which option corresponds to the type of activities performed by you?
A) Oracle Managed Files
B) Oracle Grid Architecture
C) Oracle database architecture
D) Optimal Flexible Architecture
2. You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to, in order to confirm that the alert has been raised due the event?
A) the alert.log file
B) the Database Control Home page
C) the Database Control Maintenance page
D) the DBA_ALERTS view
E) the Database Control performance page
3. Your database is configured with the following parameters related to SGA:
SGA_TARGET=256MB
SHARED_POOL_SIZE=32MB
DB_CACHE_SIZE=100MB
LARGE_POOL_SIZE=0
JAVA_POOL_SIZE=0
STREAMS_POOL_SIZE=0
Which two statements are true about the configuration? (Choose two.)
A) 124 MB (256 minus 132) of memory is available for use by all the manually sized components.
B) The shared pool and the default buffer pool will not be sized smaller than 32 MB and 100 MB, respectively.
C) The shared pool and the default buffer pool will not be sized bigger than 32 MB and 100 MB, respectively.
D) 124 MB (256 minus 132) of memory is available for use by all the manually and automatically sized components.
E) The SGA_TARGET value cannot be sized smaller than 100 MB.
4. Your test database is running in NOARCHIVELOG mode. What are the implications of this?
A) You can perform the backup of only the SYSTEM tablespace when the database is open.
B) You can perform closed database backups.
C) You cannot perform schema-level logical backups.
D) You can perform open database backups.
5. A user receives the following error while executing a query:
ORA-01555: snapshot too old
Which two options can be the solutions to avoid such errors in future? (Choose two.)
A) increase the size of redo log files
B) enable the retention guarantee for the undo tablespace
C) increase the size of the undo tablespace
D) increase the size of the default temporary tablespace
E) increase the size of the Database Buffer Cache
問題與答案:
| 問題 #1 答案: D | 問題 #2 答案: B | 問題 #3 答案: B,D | 問題 #4 答案: B | 問題 #5 答案: B,C |

下載最新試用版
1362位客戶反饋
我們對我們的產品非常有信心,所以我們不提供会给客户带去麻煩的產品。








58.247.5.* -
我無法形容此刻我的心情,要是沒有 VCESoft 提供的考古題,我不能確定我能通過 1Z0-042 考試,你們提供的題庫非常完美,很高興當初購買了這考題。