Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available orac,e9i testing centers with whom we are maintaining our relationship to get latest material. But our bitter enemy Brij Lall was his confidential mootsuddee, and conducted himself in so plausible a MB Exam Collection manner, that his tyrannies were never 1Z discovered. We provide all our 1Z exam training material in PDF format, which is a very common datahase found in all computers and gadgets. Our dumps provide you with a reliable, rewarding and easy way to know and 1Z Practice grasp what your actual exam really requires.
|Published (Last):||23 June 2017|
|PDF File Size:||11.66 Mb|
|ePub File Size:||9.50 Mb|
|Price:||Free* [*Free Regsitration Required]|
The filename format. Information stored inside a data dictionary table. LOG file for the corresponding instance. Information stored inside the corresponding initialization parameter file for the instance. Incorrect Answers B: Oracle will create a locally managed tablespaces, so information about a datafile will not be stored inside a data dictionary table. LOG file to store information about datafiles. It just keep log of database events and database structure changes.
D: Initialization parameter file will not be used to store this information. Oracle reads this file to set initialization parameters to start the instance. The structure of the database is stored inside control files. Oracle uses them to mount and open the database. No literal value is substituted for a shared cursor. Different execution plans are generated for substituted literal values. The substitution of a literal value will produce different execution plans.
The substitution of any literal value will produce exactly the same execution plan. Answer: D Explanation: Oracle9i has enhanced cursor sharing mode. When you specify SIMILAR, Oracle only uses the execution plan if is certain that the execution plan does not have any association with the specific literal value.
Incorrect Answers A: Literal value is substituted for a shared cursor. B: Exactly the same execution plans will be generated for substituted literal values. C: The substitution of any literal value will produce exactly the same execution plan. This avoids the previous need of shutting down the instance in order to modify the components of the SGA, namely the buffer cache and shared pool components. Which three statements are true for the Dynamic SGA feature?
Choose three A. The maximum granule size is 4 MB B. The minimum SGA configuration is three granules. One is for fixed SGA, one for database buffer, one for shared pool. Oracle9i has enhanced the nature of SGA parameters; they are now dynamic. You can change the values of the shared pool and the buffer cache without restarting the database instance.
The Oracle9i dynamic SGA concept enables you to take memory from one area of the SGA and allocate it to another area as needed while the database instance is up and running. Additionally, the unit of memory allocation fr SGA is a granule in Oracle9i. This parameter is just maximum limit for sum of the SGA components. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations?
You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. Global indexes remain intact and available for use by data manipulation language DML statements even for sessions that have not enabled the skipping of unusable indexes.
Answer: A, B, D Explanation: Oracle9i overcomes the problem of rebuilding the global index by giving you the option to update global indexes as Oracle performs the partition DDL. It provides each session with its own view of the database at a different point in the past. It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables.
It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes. It allows you to add new sites to multimaster replication environment without quiescing the master definition site.
Answer: B Explanation: The Oracle9i Cache Fusion allows you to execute scalable applications on a clustered database without having to partition the users or the database tables. Incorrect Answers A: It does not provide each session with its own view of the database at a different point in the past. C: The Oracle9i Cache Fusion feature does not dynamically reassign memory in your database buffer cache to different block buffer sizes.
D: It does not provide you ability to add new sites to multimaster replication environment without quiescing the master definition site. It is possible to switch to UNDO2; but current active transactions will abort. Only current active transactions will continue to execute inside UNDO1, all new transactions will be assigned to the new undo tablespace. Incorrect Answers A: You can switch undo tablespaces while active transactions will run in the old undo tablespace.
All new transactions will be assigned to the new undo tablespace. B: Current active transactions will abort if you switched undo tablespaces. They will not be automatically migrated to UNDO2. Incorrect Answers C: You cannot subtract timestamps. The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
Incorrect Answers A: The Oracle server does not create a new histogram based on existing histogram. D: The Oracle server creates a histogram not only based on application usage, but based on data distribution also.
Choose two A. External tables can be updated. External tables are read-only tables. Indexes can be created on external tables. Indexes cannot be created on external tables. Answer: B, D Explanation: External tables are read-only tables whose data resides in an external OS flat file, and whose definition is stored inside the database. Incorrect Answers A: External tables cannot be updated. They are read-only tables. C: Indexes cannot be created on external tables.
Oracle9i Database: Fundamentals II
1Z0-032 ORACLE9I DATABASE FUNDAMENTALS II PDF