当前分类： 1Z0-032
问题：单选题Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A V$DATAFILEB V$TEMPFILEC V$DBFILED V$DATAFILE_HEADER...
查看答案
问题：单选题What does the Character Set Scanner command line utility do？（）A Reports only on any Unicode character conversions required.B Performs character set conversions to the new specified character set.C Scans on any character set conversion required， then co...
问题：单选题The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（） 1. Shot down and start up the former primary instance wi...
问题：单选题Which RMAN command is used to verify the status of a backup or copy， and also updates the repository when files have been deleted using operating system commands？（）A CHANGEB RESYNCC CATALOGD CROSSCHECK...
问题：多选题Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）AGrand privileges on the interim ...
问题：多选题Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command？（）ARAWBLONGCVARCHARDLONG RAW...
问题：单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）A Only the damaged or lost data files.B All of the data files of the database.C Only the data files belonging to the SYSTEM tablespace.D The data files be...
问题：单选题SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in ...
问题：单选题What is true regarding direct-load insert？（）A A direct-load insert can be invoked by suing the APPEND hint.B Inserting using the NOLOGGING option is the default for direct-load inserts.C All data loaded using direct-load insert is loaded below the high...
问题：单选题Which of the following environment variables specifies a non-default location for the listener configuration file？（）A LSN_ADMINB TNS_ADMINC ADMIN_TNSD TSN_ADMIN...
问题：多选题You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）ANOCHECKSUMBMAXCORRUPTCCH...
问题：单选题You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）A RCO1 only.B DB01 only.C DB02 only.D DB01 and DB02 only.E D...
问题：单选题Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）A V$COPY_CORRUPTB V$COPY_CORRUPTIONC V$BACKUP_CORRUPTD V$BACKUP_CORRUPTION...
问题：多选题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 e...
问题：单选题What is true about version-enabled tables？（）A The unit of versioning is the schema.B It is possible to version enable a table pertaining to SYS.C There are as many segments as versions for the same base table.D It is possible to create workspaces if th...
问题：单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A ’SQL ALTER DATABASE OPEN’；B SQL ALTER DATABASE ’OPEN’；C OPEN DATABASE；D DATABASE OPEN...
问题：多选题Which four are true regarding the Workspace Manager in Oracle9i？ （）AAutomatically versions all tables.BAutomatically installed with Oracle9i.CMerges changes with parent rows or discard changes.DProvides mechanism to identify and resolve conflicts.EAllo...
问题：单选题Which of the following options would you choose to implement controlled access using remote authentication for your networks？（）A OiDB RADIUSC Wallet ManagerD Oracle Names Server...
问题：单选题Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords？（）A Wallet ManagerB RadiusC Oracle Internet DirectoryD None of the above...
问题：单选题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）A During a query’s parse time only. B During a query’s execution time only. C During any kind of DML statement execution. D During the execution of an INSERT statement only....
