pg电子游戏软件,类似车行168的软件,单机游戏内购破解平台,今日打牌财神方位查询老黄历

Oracle DBA創建數據庫練習題及答案

時間:2024-08-10 06:00:27 Oracle認證 我要投稿
  • 相關推薦

2016年Oracle DBA創建數據庫練習題及答案

  Q. 1 : When will the rollback information applied in the event of a database crash

  1. before the crash occurs

  2. after the recovery is complete

  3. immediately after re-opening the database before the recovery

  4. roll back infrmation is never applied if the database crashes

  2

  Q. 2 : The data dictionary tables and views are stored in

  1. USERS tablespace

  2. SYSTEM tablespace

  3. TEMPORARY tablespace

  4. any of the three

  3

  Q. 3 : Oracle uses the data dictionary tables and views

  1. to make the database user friendly

  2. to store user data

  3. to store application data

  4. for proper database functioning

  4

  Q. 4 : No data in any data dictionary tables should be deleted or altered by any user. Which of the following object is an exception to this rule,

  1. AUD$

  2. PENDING_SESSIONS$

  3. USER_HISTORY$

  4. PENDING_TRANS$

  1

  Q. 5 : A collection of segments is a (an)

  1. extent

  2. segment

  3. tablespace

  4. database

  3

  Q. 6 : When the database is open, which of the following tablespaces must be online

  1. SYSTEM

  2. TEMPORARY

  3. ROLLBACK

  4. USERS

  1

  Q. 7 : Sorts can be managed efficiently by assigning ____ tablespace to sort operations.

  1. SYSEM

  2. TEMPORARY

  3. ROLLBACK

  4. USERS

  2

  Q. 8 : The sort segment of a temporary tablespace is created

  1. at the time of the first sort operation

  2. when the TEMPORARY tablespace is created

  3. when the memory required for sorting is 1kb

  4. all of the above

  1

  Q. 9 : Which of the following segments is self administered

  1. TEMPORARY

  2. ROLLBACK

  3. CACHE

  4. INDEX

  3

  Q. 10 : What is the default temporary tablespace, if no temporary tablespace is defined

  1. ROLLBACK

  2. USERS

  3. INDEX

  4. SYSTEM

  4

  Q. 11 : Rollback segments are used for

  1. read consistency

  2. rolling back transactions

  3. recovering the database

  4. all of the above

  4

  Q. 12 : Rollback segment stores

  1. old values of the data changed by each transaction

  2. new values of the data changed by each transaction

  3. both old and new values of the data changed by each transaction

  4. none

  1

【Oracle DBA創建數據庫練習題及答案】相關文章:

2024年Oracle數據庫面試試題及答案10-25

Oracle數據庫SELECT語句03-27

oracle數據庫基本語句02-08

Oracle數據庫語句大全12-21

Oracle數據庫認證層次03-09

Oracle數據庫基本知識03-31

ORACLE數據庫操作基本語句03-06

oracle數據庫培訓課程大綱03-21

oracle數據庫基礎知識01-21

主站蜘蛛池模板: 策勒县| 盐城市| 施甸县| 台前县| 富裕县| 贵德县| 济阳县| 城固县| 毕节市| 铜鼓县| 云龙县| 房产| 山西省| 莫力| 新巴尔虎右旗| 阳江市| 桐柏县| 革吉县| 房山区| 南投县| 凤山市| 志丹县| 荣昌县| 襄垣县| 板桥市| 迁安市| 九寨沟县| 绥德县| 湖州市| 吕梁市| 波密县| 曲阜市| 云和县| 威信县| 沂水县| 晋州市| 江津市| 临潭县| 西畴县| 肇源县| 台山市|