1Z0-032 题目列表
单选题Which statement is true regarding Oracle Shared Server architecture？（）AA dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. BUnder the Oracle Shared Server architecture, client-user processes connect to shared user processes.CEach dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. DOracle 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（）.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.
单选题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？（）ABack up the data file.BBring tablespace TS1 online.CCopy redo logs to the backup directory.DMake 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？（）Auser-managed backups.Bpartial database backups.Cconsistent database backups.Dinconsistent database backups.
单选题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.
多选题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？（）AHost naming method.BLocal naming method.CDirectory naming method.DExternal naming method.
单选题Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）AV$LOGBV$LOFHISTCV$LOGFILEDV$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.ALISTBSWITCHCVALIDATEDCONFIGUREERESYNC CATALOGFUPGRADE 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？（）ARebuild the index using the online option. BTake 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. CWithout setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. DTake 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？（）ADELETEDBOBSOLETECEXPIREDDUNKNOWN