熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle DBA數據庫結構試題精選(2)

2013-11-13 15:51:08  來源: Oracle 

  Q : When will the rollback information applied in the event of a database crash
  
   before the crash occurs
   after the recovery is complete
   immediately after reopening the database before the recovery
   roll back infrmation is never applied if the database crashes
  
  
  
  
  
  Q : The data dictionary tables and views are stored in
  
   USERS tablespace
   SYSTEM tablespace
   TEMPORARY tablespace
   any of the three
  
  
  
  
  Q : Oracle uses the data dictionary tables and views
  
   to make the database user friendly
   to store user data
   to store application data
   for proper database functioning
  
  
  
  
  Q : 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
  
   AUD$
   PENDING_SESSIONS$
   USER_HISTORY$
   PENDING_TRANS$
  
  
  
  
  Q : A collection of segments is a (an)
  
   extent
   segment
   tablespace
   database
  
  
  
  
  
  Q : When the database is open which of the following tablespaces must be online
  
   SYSTEM
   TEMPORARY
   ROLLBACK
   USERS
  
  Q : Sorts can be managed efficiently by assigning ____ tablespace to sort operations
  
   SYSEM
   TEMPORARY
   ROLLBACK
   USERS
  
  
  
  Q : The sort segment of a temporary tablespace is created
  
   at the time of the first sort operation
   when the TEMPORARY tablespace is created
   when the memory required for sorting is kb
   all of the above
  
  
  
  
  Q : Which of the following segments is self administered
  
   TEMPORARY
   ROLLBACK
   CACHE
   INDEX
  
  
  
  
  
  Q : What is the default temporary tablespace if no temporary tablespace is defined
  
   ROLLBACK
   USERS
   INDEX
   SYSTEM
  
  
  
  
  Q : Rollback segments are used for
  
   read consistency
   rolling back transactions
   recovering the database
   all of the above
  
  
  
  
  Q : Rollback segment stores
  
   old values of the data changed by each transaction
   new values of the data changed by each transaction
   both old and new values of the data changed by each transaction
   none
  

From:http://tw.wingwit.com/Article/program/Oracle/201311/17399.html
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.