1Z0-032 题目列表
单选题You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）AUse the DROP DATAFILE command.BUse the DROP TABLESPACE command.CEnsure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.DEnsure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
单选题Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）AIGNORE=YBDIRECT=YCCONSISTENT=YDBUFFER=Y
单选题Consider the following statement： SQL EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （- 2 ownname = ‘OE’， - 3 estimate_percent = DBMS_STATS.AUTO_SAMPLE_SIZE， - 4 method opt = ‘for all columns size AUTO’）； What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）AThe Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. BThe Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.CThe Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. DThe Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
单选题Which of the following commands must be issued to remove a stored script from the recovery catalog？（）ADELETE SCRIPTBERASE SCRIPTCREMOVE SCRIPTDUNCATALOG SCRIPT
单选题The direct handoff connection method to an Oracle9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture. Which type of message has been eliminated？（）AThe initial request from the client to the listener.BMessages between the dispatcher and the shared server background processes.CA redirect message from the listener to the client during client connections.DRound-trip messages between the listener and the shared server background processes.
多选题Online index rebuild functionality has been extended to include which four index structures？（）ABitmap indexes.BReverse key indexes.CFunction-based indexes.DKey-compressed indexes on regular tables.EKey-compressed indexes on IOT （including secondary indexes）
多选题Which three features are provided by Oracle Net Services？ （）AData encryption.BUser authentication.CTransparent data conversionDConfiguration and administration mechanisms.ESupport for multiple network transport protocols.
多选题Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）ARAWBLONGCVARCHARDLONG RAW
单选题A bitmap join index is defined as（）.AAn index used to join two bitmap indexes on a table.BA bitmap index created for the join of two or more tables.CA bitmap index created on the join of two or more indexes.DA bitmap index created on the join of two or more indexed-organized tables.
多选题When a check point occurs the （）. （）. and （） are synchronized.Adata filesBcontrol filesCredo log filesDparameter filesEarchive log files
单选题Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）ANo literal value is substituted for a shared cursor. BDifferent execution plans are generated for substituted literal values. CThe substitution of a literal value will produce different execution plans. DThe substitution of any literal value will produce exactly the same execution plan.
单选题Which step is required for recover from an instance failure？ （）AStart up only.BRestore needed data files， then start up.CComplete restore from backup， then start up.DPerform point in time recovery， then start up.
单选题Under the Oracle Shared Server architecture， client-user processes ultimately connect to a（）AserviceBlistenerCdispatcherDshared server process
单选题Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）ANo literal value is substituted for a shared cursor. BDifferent execution plans are generated for substituted literal values. CThe substitution of a literal value will produce different execution plans. DThe substitution of any literal value will produce exactly the same execution plan.
单选题Which phrase best describes RMAN multiplexed backup sets？（）AStripes a single backup set across multiple channels.BIdentical copies of backup pieces within a backup set.CMultiple backup sets with multiple channels configured.DSimultaneous reads from multiple files and writes into the same backup piece.