Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions？（）  

相似题目

• A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  A .  Flash back all the tables in the data file， one by one. B .  Restore the data file to a new location and perform a media recovery. C .  Flash back the database， there is no need to restore the data file. D .  Restore the data file from the most recent backup and flash the database.

  查看最佳答案

• You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use？（）

  A . Only host B . Only local C . Either host or local D . Both host and local

  查看最佳答案

• In which two cases would you use an outer join? （）

  A . The tables being joined have NOT NULL columns. B . The tables being joined have only matched data. C . The columns being joined have NULL values. D . The tables being joined have only unmatched data. E . The tables being joined have both matched and unmatched data. F . Only when the tables have a primary key/foreign key relationship.

  查看最佳答案

• In which case would you use a FULL OUTER JOIN? （）

  A . Both tables have NULL values. B . You want all unmatched data from one table. C . You want all matched data from both tables. D . You want all unmatched data from both tables. E . One of the tables has more data than the other. F . You want all matched and unmatched data from only one table.

  查看最佳答案

• You want to migrate your existing non­ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）

  A . the CONVERT command of RMAN B . Data Pump Export and Import into the same database C . conventional export and import into the same database D . the BACKUP DATABASE and RESTORE DATABASE commands of RMAN E . the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

  查看最佳答案

• In which situation would you use the Oracle Shared Server configuration？（）

  A . when performing export and import using Oracle Data Pump B . when performing backup and recovery operations using Oracle Recovery Manager C . when performing batch processing and bulk loading operation in a data warehouse environment  D . in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

  查看最佳答案

• You are designing a strategy for installing Windows server 2003 on the new domain controllers. Which method should you use？（）

  A .  Unattended installation B .  Remote Installation Services （RIS） C .  Automated Deployment Services （ADS） D .  Microsoft Systems Management Server （SMS）

  查看最佳答案

• You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

  A . Compare Period ADDM report B . AWR Compare Period report C . Active Session History (ASH) report D . Taking a new snapshot and comparing it with a preserved snapshot

  查看最佳答案

• You are about to configure PPP n the interface of a Cisco router. Which authentication methods could you use?（）

  A . SSL B . SLIP C . PAP D . LAPB E . CHAP F . VNP

  查看最佳答案

• Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

  A .  use DBMS_IJOB package B .  use Oracle Scheduler C .  use DBMS_JOB package D .  use Oracle Data Pump Export and Import

  查看最佳答案

• You are designing a strategy to perform inplace upgrade of domain controller in Boston and San Diego.  Which method should you use？（）

  A .  adprep B .  sysprep C .  Answer File D .  Remote Installtion Services （RIS）

  查看最佳答案

• You are designing a strategy for installing Windows server 2003 on the new domain controllers. Which method should you use?（）

  A . Unattended installation B . Remote Installation Services （RIS） C . Automated Deployment Services （ADS） D . Microsoft Systems Management Server （SMS）

  查看最佳答案

• Examine the CREATE DISKGROUP command used to create a disk group：   SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY  DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2；   In which situation would you use this method of disk group creation？（）

  A .  When two-way disk mirroring is required for the allocation units B .  When three-way disk mirroring is required for the allocation units C .  When using hardware mirroring or RAID D .  When disk mirroring is required for the Automatic Storage Management （ASM） disk

  查看最佳答案

• In which situation would you use static database registration for a listener（）

  A . when multiple databases are to be registered with the listener B . when DBAs need to connect remotely to start up the database instance C . when users need to connect the database instance using the host naming method D . when the database instance that is to be registered with the listener is configured in shared server mode

  查看最佳答案

• You are designing a strategy to enable the ATC application to successfully resolve computer names.  Which name resolution method should you use？（）

  A .  DNS B .  WINS C .  Hosts file D .  Lmhosts file

  查看最佳答案

• Which protocols would you want to use for secure VPN ？（）

  A . EAP B . Chap C . Ms-Chap D . PPTP E . PAP F . SPAP

  查看最佳答案

• Examine the CREATE DISKGROUP command used to create a disk group: https://assets.asklib.com/images/image2/2018080215151252767.jpg In which situation would you use this method of disk group creation?（）

  A . When two-way disk mirroring is required for the allocation units B . When three-way disk mirroring is required for the allocation units C . When using hardware mirroring or RAID D . When disk mirroring is required for the Automatic Storage Management (ASM) disk

  查看最佳答案

• You are designing a strategy to enable the ATC application to successfully resolve computer names. Which name resolution method should you use?（）

  A . DNS B . WINS C . Hosts file D . Lmhosts file

  查看最佳答案

• You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  

  A .  Data Pump Export and Import B .  conventional export and import C .  the CONVERT command of RMAN D .  the BACKUP AS COPY. command of RMAN

  查看最佳答案

• As A DBA， which of the following methods can you use to make a backup of your table？（）

  A . Recover Manager （RMAN） utility B . Import utility C . Export utility D . O/S backup command

  查看最佳答案

• A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  A . flash back all the tables in the data file， one by one B . restore the data file to a new location and perform a media recovery C . flash back the database; there is no need to restore the data file D . restore the data file from the most recent backup and flash back the database

  查看最佳答案

• For which two situations would you use functionality provided by the Resource Manager?（）

  A . setting idle timeout limits on resource plans B . saving storage space by using compressed backup sets C . creating jobs that will run automatically at a scheduled time D . assigning priorities to jobs to manage access to system resources E . creating alerts to perform notification when tablespaces are low on available space resource

  查看最佳答案

• Which of the following professional greeting would you use if you do not know the recipient?

  查看最佳答案

• With which people would you be formal and use titles?

  A:Your lead worker B:your manager C:your boss D:a close friend

  查看最佳答案