当前分类： 1Z0-032
问题：多选题Some data storage and transfer media have fixed-length physical records. When the data records are short， more then one can be stored in a single， physical record to use the storage space efficiently. Consider this data： 1119 Smith 1120 Yvonne 1121 ...
查看答案
问题：多选题When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）AThread number.BLog Sequence number.CControl file sequence number.DName of the last archived log....
问题：单选题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 strat...
问题：单选题Which of the following roles must be granted to a user to perform a full database import？（）A CONNECTB IMP_FULL_DATABASEC FULL_EXPORT_PRIVSD RESOURCEE FULL_IMPORT_PRIVS...
问题：单选题The three tasks shown have been completed in order to configure a naming method： Task 1： Installed on server and client： Oracle Net Services， TCP/IP， TCP/IP protocol adaptor Task 2： Started default listener on port 1521 Task 3： Added global database na...
问题：单选题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...
问题：单选题Which of the following files cannot be cataloged using the CATALOG command？（）A Data filesB Control filesC Archived log filesD Files storing RMAN scripts...
问题：单选题You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL CREATE USER rman_db01 IDENTIF...
问题：单选题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 M...
问题：单选题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....
问题：多选题What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）AGlobal indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with...
问题：单选题You can control instance recover performance by setting parameters to define targets for（）A The size of the redo buffer in SGA. B The instance that will perform recovery in Real Application Cluster database. C The number of blocks to be read during ins...
问题：多选题Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）ASWITCH_TIMEBSWITCH_GROUPCMAX...
问题：多选题Which two file types must be included in a closed database backup taken with operating system commands？（）Adata filesBcontrol fileCpassword fileDonline redo log filesEinitialization parameter file...
问题：单选题Which statement is true regarding remote archive log file destinations？（）A Only two destinations per remote database can be specified.B Destination is an Oracle Net alias specified by using the SERVICE keyword.C The REOPEN attribute must be used when u...
问题：单选题Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）A V$BACKUPSETB RC_DATABASEC V$BACKUP_SETD RC_BACKUP_SET...
问题：单选题Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）A RESTOREB RECOVERC REPORTD BACKUP...
问题：多选题Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the Database Administrator had few options to deal with stuck recovery. If the co...
问题：单选题Which server stack communication layer corresponds to the client application layer in a distributed environment？（）A RDBMSB ApplicationC Oracle Net foundationD Network ProtocolE Presentation...
