2016年Oracle DBA審計資料庫試題
Q. 1 : What feature in oracle allows you to monitor Suspicious Activity on the Datbase
1. Replication
2. Auditing
3. Monitoring
4. Tuning
Q. 2 : Auditing can be turned on by setting this parameter
1. DB_AUDIT_TRAIL
2. AUDIT_TRAIL
3. AUDIT_DB
4. None of the above
Q. 3 : What are the valid values for AUDIT_TRAIL Parameter
1. DB
2. OS
3. NONE
4. All of the above
Q. 4 : Where are the records stored if the following value is set in the PARAMETER file. "AUDIT_TRAIL=DB"
1. Database
2. Operating System File
3. Tape
4. None of the above
Q. 5 : Where is the audit information written to when the AUDIT_TRAIL parameter is set to NONE
1. Parameter File
2. Redo Log
3. OS File
4. Audit Trail is not turned on
Q. 6 : Which data dictionary object holds the information about audit codes and their associated names
1. AUDIT_INFO
2. DBA_AUDIT_INFO
3. AUDIT_ACTIONS
4. None of the above
Q. 7 : Audit Data is Stored in
1. SYS.X$AUDIT
2. SYS.V$AUD
3. $
4. None of the above
Q. 8 : Instance Startup Audit Records are Placed in
1.
2.
3. AUDIT_FILE_DEST
4. AUDIT_REC_DEST
Q. 9 : The db is running with Session audit and the audit table is full. What happens to new sessions
1. Nothing, They are not audited
2. New Connections are Not Allowed
3. Session allowed, with audit record to
4. None of the abvoe
Q. 10 : After Audit_Trail is set to NONE, the audit trail is disabled by
1. Restarting the Database
2. Disabling Restricted Mode
3. Grant Audit_trail to public
4. None of the above
Answer:
1=>2,
2=>2,
3=>4,
4=>1,
5=>4,
6=>3,
7=>3,
8=>3,
9=>2,
10=>1,
-
ORACLE與excel的資料互傳方法
眾所周知,MicrosoftExcel能很直觀而方便地進行資料輸入,統計,生成圖表,但它的資料管理能力有限,對大量的資料查詢能力不足,如果利用它資料計算方面的優點和大型資料庫ORACLE的資料查詢優點,可以設計出功能強大的資料處理系統。假設與Excel資料檔案相對應的職工情況表E...
-
Oracle認證考試注意事項
入場前請出示考試票以及兩種有效身份證件(請參照下文證件要求),並填寫簽到表及考生協議,手續不全者考管員有權拒絕其參加考試;若在考試過程中,由於技術故障導致考試無法進行,應立即與考管員聯絡,由考管員進行處理或安排重考,否則責任由考生本人承擔。證件要求(考生攜...
-
關於Oracle碎片拾掇的解析
至於系統管理員也就是說,何以責任書網路穩固運作,何以增高資料庫效能,使其愈加保險高效率,便顯得尤為重要。作為影響資料庫效能的一大要素--資料庫碎片,應該喚起DBA的足夠重視,及時發現並拾掇碎片就是DBA一項根本維護內容。一、碎片是何以發作的應生成一個數據庫時,它...
-
Oracle資料庫無響應故障處理方式
Oracle資料庫無響應故障,簡單地講就是資料庫例項不能響應客戶端發起的請求,客戶端提交一個SQL後,就一直處於等待資料庫例項返回結果的狀態。更嚴重的現象是客戶端根本不能連線到資料庫,發起一個連線請求後,一直處於等待狀態。Oracle資料庫無響應故障怎麼處理呢?下面...