站内搜索
1Z0-032 问题列表
问题
单选题Which statement is true regarding Oracle Shared Server architecture？（）A
A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. B
Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.C
Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. D
Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.
问题
多选题SQ L*Loader is a utility that can perform which two tasks？（）ALoad data from a disk， tape， or named pipes.BLoad data into an Oracle database using DML statements.CExtract， reorganize， and insert data within an Oracle database.DLoad data from external files into tables in an Oracle database.ELoad data into an Oracle database using operating system commands.FLoad data directly from a non-Oracle database to an Oracle database.
问题
单选题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.
问题
单选题Data file DF1 belongs to tablespace TS1.，and the database is in ARCHIVELOG mode. You did an incomplete recover in the following steps： 1. Take data file DF1 offline. 2. Copy a backup copy of DF1 into the current DF1 location. 3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past. 4. Bring DF1 online. 5. Execute ALTER DATABASE OPEN RESETLOGS. To guarantee that the database is recoverable in the future， what is the least amount of work needed？（）A
Back up the data file.B
Bring tablespace TS1 online.C
Copy redo logs to the backup directory.D
Make a complete backup right after opening the database.
问题
多选题Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）AOnline backups.BSkipping unused block.CPartial database backups.DIncremental block-level backup.EDetection of corrupted blocks during backup.
问题
单选题What is true regarding a transaction executed in Automatic Undo Management mode？（）A
AB
BC
CD
D
问题
单选题Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A
user-managed backups.B
partial database backups.C
consistent database backups.D
inconsistent database backups.
问题
单选题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.
问题
多选题Which two statements are true regarding the use of UTF-16 encoding？ （）AEnables easier loading of multinational data.BUses a fixed-width Multibyte encoding sequence.CAsian characters are represented in three characters.DUsed a variable-width Multibyte encoding sequence.EEuropean characters are represented on one or two bytes.
问题
单选题Click the Exhibit button and examine the diagram. You are running a database that takes advantage of features provided by Connection Manager， heterogeneous services， and external procedures. The diagram depicts the components used for the naming method you just configured. Which naming method are you using？（）A
Host naming method.B
Local naming method.C
Directory naming method.D
External naming method.
问题
单选题Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）A
V$LOGB
V$LOFHISTC
V$LOGFILED
V$LOG_HISTORY
问题
多选题Examine the list of variables and their data types： AME DATA Type TS， TS1 TIMESTAMP TSZ TIMESTAMP WITH TIME ZONE TLZ TIMESTAMP WITH LOCAL TIME ZONE IYM INTERVAL YEAR TO MONTH IDS， IDSI INTERVAL YEAR To SECOND Which three expressions using the new data and time data types are valid？（）AIDS* 2BTS + IYMCTS –TSIDIDS – TSEIDS + IYM
问题
单选题RMAN automatically propagate information about the database structure， archived redo logs， backup sets， and data file copies into the recovery catalog from the target database’s control file. This information can also be propagated to the catalog manually by using the （）command.A
LISTB
SWITCHC
VALIDATED
CONFIGUREE
RESYNC CATALOGF
UPGRADE CATALOG
问题
单选题Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）A
Rebuild the index using the online option. B
Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C
Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D
Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
问题
单选题When issuing the CROSSCHECK command in RMAN， if a backup file CANNOT be found， to what status is that file set？（）A
DELETEDB
OBSOLETEC
EXPIREDD
UNKNOWN