Oracle 1Z0-030: Oracle 9i: New Features For Administrators
#111. The TYPE clause used in the creation of an external table defines which access driver is used to convert the data when needed by SQL statements inside the database. Which type of access driver is supported for external tables?
#112. The enterprise data warehouse routinely receives data from various production OLTP databases. The database block size on the data warehouse is 8192, and in the OLTP databases it may be 2048, 4096 or 8192. The current SGA is 112 MB. Oracle9i has the ability to transport tablespaces with different block sizes. Which two parameters are required in order to "plug in" the OLTP tablespaces into the warehouse database? (Choose two.)
#115. After changing the PCTFREE value of the automatic space management table EMPLOYEES, which task can you perform in order for your change to take affect immediately?
#116. The dbms_logmnr_d.build database procedure allows the extraction of the data dictionary to a flat file, or to the online redo log files in Oracle9i. What are three benefits of using the online redo logs files for the data dictionary storage? (Choose three)
gen. 0.063
Forum
Master braindump