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 10g自動收集統計信息
從OracleDatabase10g開始,Oracle在建庫後就默認創建了一個名為GATHER_STATS_JOB的定時任務,用於自動收集CBO的統計信息。這個自動任務默認情況下在工作日晚上10:00-6:00和週末全天開啟。調用DBMS_ER_DATABASE_STATS_JOB_PROC收集統計信息。該過程首先檢測統計信息...
-
Oracle認證:OracleTRUNC函數詳解
C函數OracleTRUNC函數可以截取數字和日期類型:C截取數字TRUNC(number)函數返回n1截取到n2位小數。如果省略n2時,則n1截取到0位置(即截取所有小數位)。如果n2為負數時,表示截取小數點左邊的n2位,被截取部分記為0.2.1語法其語法格式如下:TRUNC(n1[,n2])其中:n1為待截取...
-
Oracle認證體系介紹
oracle的體系很龐大,要學習它,首先要了解oracle的框架。在這裏,簡要的講一下oracle的架構,讓初學者對oracle有一個整體的認識。物理結構(由控制文件、數據文件、重做日誌文件、參數文件、歸檔文件、密碼文件組成)控制文件:包含維護和驗證數據庫完整性的必要信息、例...
-
華創信科oracle ocm認證費用
Oracle數據庫產品為財富排行榜上的前1000家公司所採用,許多大型網站也選用了Oracle系統。下面是小編收集的華創信科oracleocm認證費用,希望大家認真閲讀!OracleWDP培訓中心CUUG(優技培訓)是國內最早通過甲骨文公司審查成為oracleWDP培訓中心的高端IT培訓機構,主要...