站内搜索
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？（）A
Use the DROP DATAFILE command.B
Use the DROP TABLESPACE command.C
Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.D
Ensure 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？（）A
IGNORE=YB
DIRECT=YC
CONSISTENT=YD
BUFFER=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？（）A
The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. B
The 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.C
The 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. D
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.
问题
单选题Which of the following commands must be issued to remove a stored script from the recovery catalog？（）A
DELETE SCRIPTB
ERASE SCRIPTC
REMOVE SCRIPTD
UNCATALOG 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？（）A
The initial request from the client to the listener.B
Messages between the dispatcher and the shared server background processes.C
A redirect message from the listener to the client during client connections.D
Round-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（）.A
An index used to join two bitmap indexes on a table.B
A bitmap index created for the join of two or more tables.C
A bitmap index created on the join of two or more indexes.D
A 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’？（）A
No literal value is substituted for a shared cursor. B
Different execution plans are generated for substituted literal values. C
The substitution of a literal value will produce different execution plans. D
The substitution of any literal value will produce exactly the same execution plan.
问题
单选题Which step is required for recover from an instance failure？ （）A
Start up only.B
Restore needed data files， then start up.C
Complete restore from backup， then start up.D
Perform point in time recovery， then start up.
问题
单选题Under the Oracle Shared Server architecture， client-user processes ultimately connect to a（）A
serviceB
listenerC
dispatcherD
shared 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’？（）A
No literal value is substituted for a shared cursor. B
Different execution plans are generated for substituted literal values. C
The substitution of a literal value will produce different execution plans. D
The substitution of any literal value will produce exactly the same execution plan.
问题
单选题Which phrase best describes RMAN multiplexed backup sets？（）A
Stripes a single backup set across multiple channels.B
Identical copies of backup pieces within a backup set.C
Multiple backup sets with multiple channels configured.D
Simultaneous reads from multiple files and writes into the same backup piece.