Oracle 1z0-241热门认证资源分享

目录第一章Oracle的基本使用 (1)1.Oracle的安装、启动及卸载 (1)安装 (1)启动 (3)卸载 (3)2.Oracle管理工具的介绍 (4)3.SQL*PLUS常用命令 (5)连接命令 (5)文件操作命令 (5)交互式命令 (5)显示和设置环境变量 (6)第二章Oracle用户管理 (6)1.创建、修改、删除用户及权限的简单介绍 (6)创建用户 (6)修改用户密码 (6)删除用户 (6)用户管理的综合案例 (7)2.使用profile管理用户口令 (7)帐户锁定 (7)给帐户（用户解锁） (7)终止口令 (7)口令历史 (8)删除profile (8)目前主流数据库 (8)第三章Oracle表的管理 (8)1.表的管理 (8)表名和列的命名规则 (8)Oracle支持的数据类型 (9)创建表 (9)修改表 (10)查询表 (10)添加数据 (10)修改数据 (10)删除数据 (11)2.Oracle表查询 (11)基本查询 (11)使用算数表达式、列的别名、处理null值、连接字符串 (11)使用逻辑操作符号、order by子句、列的别名排序 (12)复杂查询 (13)数据分组-max,min,avg,sum,count (13)group by 和having子句 (13)对数据分组的总结 (14)多表查询 (14)自连接 (14)子查询（嵌套查询） (15)在多行子查询中使用all操作符 (15)在多行子查询中使用any操作符 (16)多列子查询 (16)在from子句中使用子查询 (16)分页查询 (17)合并查询 (17)3.创建数据库 (18)第四章Java连接Oracle、在Oracle中操作数据 (18)1.连接Oracle的两种方式 (18)使用jdbc_odbc桥连接方式 (18)使用jdbc连接Oracle (19)2.Oracle分页案例 (19)3.在Oracle中操作数据 (21)使用特定格式插入日期值 (21)使用子查询插入数据 (21)使用子查询更新数据 (21)第五章Oracle的事务、函数 (21)1.Oracle中的事务处理 (21)事务和锁 (22)提交事务 (22)回退事务 (22)事务的几个重要操作 (22)只读事务 (23)2.SQL函数的使用 (24)字符函数 (24)数学函数 (25)日期函数 (26)转换函数 (26)系统函数 (27)第六章数据库管理 (28)1.sys和system的区别 (28)2.管理初始化参数 (30)3.数据库（表、表结构、方案、数据库）的逻辑备份与恢复 (30)数据库（表、表结构、方案、数据库）的逻辑备份 (30)导出表 (30)导出表结构 (31)导出方案 (31)导出数据库 (31)数据库（表、表结构、方案、数据库）的逻辑恢复 (31)导入表 (32)导入方案 (32)导入数据库 (32)4.数据字典和动态性能视图 (32)数据字典 (33)用户名、角色、权限 (33)角色与权限的关系 (34)动态性能视图 (35)5.管理表空间和数据文件 (35)数据库的逻辑结构 (35)表空间 (36)建立表空间 (36)改变表空间的状态 (36)删除表空间 (37)扩展表空间 (37)移动数据文件 (38)显示表空间信息 (38)显示表空间所包含的数据文件 (38)其它表空间 (38)表空间小结 (39)第七章约束、索引、权限、角色 (39)1.维护数据的完整性 (39)约束 (39)商店售货系统表设计案例 (40)删除约束 (41)显示约束信息 (41)列级定义和表级定义 (41)2.管理索引 (42)创建索引 (42)使用原则 (42)索引的缺点 (42)其它索引 (43)显示表的索引信息 (43)3.管理权限和角色 (43)权限 (44)系统权限 (44)对象权限 (45)自定义角色授权 (48)删除角色 (48)显示角色信息 (49)精细访问控制 (49)角色、权限关系示意图 (49)第八章PL/SQL编程 (50)1.介绍 (50)2.编写工具及简单案例 (50)3.编写规范 (51)4.简单分类 (51)块的介绍 (51)块的结构 (52)块的实例 (52)过程 (54)函数 (55)包 (56)5.定义并使用变量 (57)标量 (57)复合变量 (58)PL/SQL记录 (58)PL/SQL表 (59)嵌套表 (59)参照变量 (59)Ref cursor 游标变量 (59)6.PL/SQL进阶–控制结构 (61)介绍 (61)条件分支语句 (61)二重条件分支 (62)多重条件分支 (62)循环语句（loop、while、for） (63)顺序控制语句（goto、null） (64)7.分页过程 (65)无返回值的存储过程 (65)有返回值的存储过程 (66)有返回值的存储过程（列表【结果集】） (66)编写分页过程 (68)8.例外处理 (71)例外的分类 (71)例外传递 (71)预定义例外 (71)9.视图 (74)视图与表的区别 (75)创建\修改\删除视图 (75)10.触发器 (75)触发器的功能： (75)触发器的组成部分： (76)触发器类型： (76)第一章Oracle的基本使用1.Oracle的安装、启动及卸载安装Oracle安装成功后，会默认生成三个用户：（1）sys用户：超级管理员，权限最高，它的角色是dba，密码是change_on_install（2）system用户：系统管理员，权限也很高，它的权限是dbaoper，密码是manager（3）scott用户：普通用户，密码是tigersys和system用户区别:1)最重要的区别，存储的数据的重要性不同【sys】所有oracle的数据字典的基表和视图都存放在sys用户中，这些基表和视图对于oracle的运行是至关重要的，由数据库自己维护，任何用户都不能手动更改。

Oracle_CertifyMe_1Z0-043 _v2010-08-04_186q_By-Savati Number: 1Z0-043Passing Score: 700Time Limit: 90 minFile Version: 2010-08-04Code: 1Z0-043Version:2010-08-04The most important questions of all for examThe options is available for examsBest wishes for examBy-SavatiExam AQUESTION 1You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.Which advisory component would you refer to, in order to determine that required size of the database buffer cache?A.Memory AdvisorB.Segment AdvisorC.SQL Tuning AdvisorD.SQL Access AdvisorE.Automatic Database Diagnostic Monitor (ADDM)Answer: ASection: (none)Explanation/Reference:QUESTION 2ExhibitIn your production database, the total waits and the time waited for log file parallel write are significantly high. While investigating the reason, you find that there are three redo log groups with two members in each group, and all redo log members are places on a single physical disk.What action would you take to minimize the waits?A.start the log writer slave processesB.increase the number of redo log filesC.increase the size of the redo log bufferD.place the redo log files on the different disksE.increase the number of log writer processesAnswer: DSection: (none)Explanation/Reference:QUESTION 3One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file.Which operation do you need to perform after re-creating the control file and opening the database?A.drop and re-create the read-only tablespacesB.rename the read-only data files to their correct file namesC.change the tablespace status from read/write to read-onlyD.re-create the read-only tablespace because it is automatically removedAnswer: BSection: (none)Explanation/Reference:QUESTION 4You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 110 MBWhich two statements are correct? (Choose two.)A.You cannot set a value for the DB_8K_CACHE_SIZE parameter.B.If you increase the size of the large pool to 120 MB, then the memory allocated to the shared poll will bereduced to 110 MB.C.If the value for SGA_TARGET is changed to 1 GB and SHARED_POOL_SIZE is set to 120 MB, thenmemory cannot be taken from the shared pool, even if the shared pool has free space available.D.If an application attempts to allocate more than 120 MB from the shared pool and free space is availablein the buffer pool, then the free space from the buffer pool is allocated to the shared pool.Answer: ACSection: (none)Explanation/Reference:QUESTION 5You are performing a block media recovery on the tools01.dbf data file in theSALESdatabase using RMAN. Which two statements are correct in this scenario? (Choose two.)A.You must ensure that the SALES database is mounted or open.B.You must restore a backup control file to perform a block media recovery.C.You must take the tools01.dbf data file offline before you start a block media recovery.D.You must put the database in NOARCHIVELOG mode to perform a block media recovery.E.You can perform only a complete media recovery of individual blocks, point-in-time recovery ofindividual data blocks is not supported.Answer: AESection: (none)Explanation/Reference:QUESTION 6ExhibitYou executed the following command to perform a backup of the USERStablespace:RMAN > BACKUP TABLESPACE USERS;Which type of backup would this command perform?A.backup setB.image copyC.incremental backupD.None; the user receives an error indicating that the backup type must be specified.Answer: ASection: (none)Explanation/Reference:QUESTION 7In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure?How would you recover the lost redo log member?A.import the database from the last exportB.restore all the members in the group from the last backupC.drop the lost member from the database and then add a new member to the groupD.restore all the database files from the backup and then perform a complete recoveryE.restore all the database files from the backup and then perform an incomplete recoveryAnswer: CSection: (none)Explanation/Reference:QUESTION 8You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?A.You do not need to restore all the data files.B.You do not need to open the database with the RESETLOGS operationC.You do not need to perform a full backup after the RESETLOGS operation.D.You do not need to recover all the data files to the same system change number (SCN).Answer: CSection: (none)Explanation/Reference:QUESTION 9ExhibitView the Exhibit and examine the Resource Manager settings for the groups at different levels.Which two effects would be the result of this setting? (Choose two.)A.The members of LOW_GROUP would get more priority than those of OTHER_GROUPS.B.The members of SYS_GROUP would get most of the CPU allocation at level 1.C.The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation attwo different levels.D.The members of LOW_GROUP would get no CPU allocation at level1 if the members ofOTHER_GROUPS are using all the CPU at level 2.E.The members of SYS_GROUP would get no CPU allocation at level 1 if the members ofOTHER_GROUPS are using all the CPU at level 2.Answer: ABSection: (none)Explanation/Reference:QUESTION 10The current time zone for one of the user sessions is set to the database local time zone. For one application, the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective? (Choose two.)e the ALTER SYSTEM command to change the time zonee the ALTER SESSION command to change the time zonee the ALTER DATABASE command to change the time zoneD.set the value for the operating system variable ORA_SDTZ on the client machineE.set the value for the operating system variable ORA_SDTZ on the database server machine Answer: BDSection: (none)Explanation/Reference:QUESTION 11You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning, while querying the user1.employeestable, you receive the following error message:01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5:'/u01/app/oracle/oradata/orcl/example01.dbf'You need to rectify the corruption while ensuring the following:The data file should remain online.The mean time to recover (MTTR) should be minimal. You are not using a backup control file and all the archived logs are accessible.Which option would you choose?A.flash back the corrupted blockse the DBMS_REPAIR packagee the RMAN TSPITR commande the RMAN BLOCKRECOVER commande the RESTORE DATABASE and RECOVER DATABASE commandsF.investigate the time at which the corruption occurred and perform a point-in-time recoveryAnswer: DSection: (none)Explanation/Reference:QUESTION 12You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)A.Flashback logs are not archived.B.Flashback logs are maintained in redo log files.C.Flashback logs are maintained in the Flash Recovery Area.D.Flashback logs are used to maintain Flashback Database related errors.E.Flashback logs need to be cleared manually after you disable Flashback Database.Answer: ACSection: (none)Explanation/Reference:QUESTION 13You executed the following query:SELECT operation, undo_sql, table_nameFROM flashback_transaction_query;Which statement is correct regarding the query output?A.It would return information regarding only the last committed transaction.B.It would return only the active transactions in all the undo segments in the database.C.It would return only the committed transactions in all the undo segments in the database.D.It would return both active and committed transactions in all the undo segments in the database.E.It would return information regarding the transactions that began and were committed in the last 30minutes.Answer: DSection: (none)Explanation/Reference:QUESTION 14Consider the following configuration:/devices/D1is a member of disk group dgroupA./devices/D2is a member of disk group dgroupA./devices/D3is a member of disk group dgroupA.You plan to add a new disk, /devices/D4,to the disk group dgroupA.You execute the following command:SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D*'; Which task would be accomplished by the command?A.The command adds the new disk, D4, to the disk group.B.The command would result in an error because the is no disk by the name "'/devices/D*'"C.The command will be ignored because disks starting with "D" are already members of the disk group.D.The command would result in an error because no wildcard characters can be used in the disk name.E.The command first detaches all the member disks starting with "D", and the reattaches them includingthe new disk.Answer: ASection: (none)Explanation/Reference:QUESTION 15You work as a database administrator at Certkiller .com. In your production database there is a job, CALC_STAT, which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic, thereby allowing users to modify the attributes of the task at run time without affecting the original task. Whichcomponent of Oracle Scheduler must you define to achieve this?A.WindowB.ProgramC.Job classD.Window groupAnswer: BSection: (none)Explanation/Reference:QUESTION 16Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database decreases initially, until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)A.increase the number of checkpoint processesB.define the POWER option while adding or removing the disksC.increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESD.increase the number of slave database writer processes by setting up a higher value forDBWR_IO_SLAVESE.increase the number of ASM Rebalance processes by setting up a higher value forASM_POWER_LIMIT during the disk addition or removalAnswer: BESection: (none)Explanation/Reference:QUESTION 17The current time is 12:00 noon. You want to recover the USERStablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?A.time-based recoveryB.log sequence recoveryC.cancel-based recoveryD.change-based recoveryAnswer: CSection: (none)Explanation/Reference:QUESTION 18You lost the PRODSTDtablespace, which was read/write. The tablespace was read-only when the last backup wasperformed. How would you recover the tablespace?A.restore the tablespace from the backup; there is no need to apply the redo informationB.restore the full database to recover the data up to the point when you performed the backupC.restore the tablespace from the backup and then perform a recovery using the backup control fileD.restore the tablespace from the backup and then recover the tablespace; all the redo information fromthe point when the tablespace was made read/write is appliedAnswer: DSection: (none)Explanation/Reference:QUESTION 19You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1and DG2with one device each.In the parameter file of the production database, the following parameters have been specified:DB_CREATE_ONLINE_LOG_DEST_1 = '+dg1'DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2'What would be the impact of this setting?A.When a new log group is added, it would have one member in each disk group.B.When a new log group is added, it would have two members in each disk group.C.When a new tablespace is added, it would have one data file in each disk group.D.When a new log file is added, it would have one member spread across the disk groups.Answer: ASection: (none)Explanation/Reference:QUESTION 20An RMAN backup job fails, displaying the following error:ORA-19809: limit exceeded for recovery filesYour analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in the future? (Choose two.)A.take the backup of the flash recovery area less frequentlyB.increase the value of the UNDO_RETENTION initialization parameterC.change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTOD.change the backup retention policy to retain the backups for a smaller period of timeE.increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterF.increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter Answer: DESection: (none)Explanation/Reference:QUESTION 21Your database operates inARCHIVELOGmode. User-managed consistent backups are performed every Sunday night.On Tuesday, client A drops a table at 8:00 a.m. as follows:SQL> DROP TABLE cust_ord PURGE;Table dropped.Client B executes a query at 9:00 a.m. on the same table as follows:SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord*ERROR at line 1:ORA-00942: table or view does not existClient B needs the dropped table and reports the problem to you.With reference to this scenario, which action should you take?A.retrieve the table by using the flashback featureB.restore all the data files from last Sunday's backup and then perform a time-based recoveryC.restore all the data files from last Sunday's backup and then perform a log sequence recoveryD.restore all the data files from last Sunday's backup and then perform a cancel-based recoveryE.restore from last Sunday's backup only data files that belong to the tablespace in which the table wasstored and then perform a complete recoveryAnswer: BSection: (none)Explanation/Reference:QUESTION 22You performed an incomplete recovery on your Oracle Database 10g database using the following command:SQL> RECOVER DATABASE2 UNTIL TIME '2004-08-05:12:10:03'3 USING BACKUP CONTROLFILE;In which situation would the above recovery be required?A. A user table was lost at the specified time.B. A redo log file was lost at the specified time.C.The backup control file is on a faster disk than the current one.D.The current control file has a different path compared with the intended time of recovery.E.The current control file does not match the physical structure of the database at the intended time ofrecovery.Answer: ESection: (none)Explanation/Reference:QUESTION 23While creating a job class using the DBMS_SCHEDULERpackage, you set the logging level toLOGGING_RUNS. What would be the impact of this setting?A.Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B.Oracle Scheduler would write detailed information to the job log for the first run of each job in the jobclass.C.Oracle Scheduler would write detailed information to the job log for each run of only the first job in thejob class.D.Oracle Scheduler would write detailed information for all operations performed on all jobs in the jobclass.Answer: ASection: (none)Explanation/Reference:QUESTION 24You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?A.create a hash cluster to store the dataB.create an index cluster to store the dataC.create a partitioned table to store the dataD.create a sorted hash cluster to store the dataE.create a heap table with rowid to store the dataAnswer: DSection: (none)Explanation/Reference:QUESTION 25You set the recovery window to seven days and the backup optimization to ONusing the CONFIGUREcommand of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLStablespace also, even though the contents of the tablespace have not changed after the backup on January 3.Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?A.configure a default device for RMAN backupsB.temporarily disable the retention policy for RMAN backupsC.configure automatic channel allocation for RMAN backupse the CONFIGURE command to reconfigure the recovery window to 60 daysAnswer: DSection: (none)Explanation/Reference:QUESTION 26Exhibit:You want to configure the Flashback Database feature and retain flashback logs for three days.The steps used in this process are displayed in the exhibit. In what sequence would you need to perform these steps to enable the Flashback Database feature?A.D, C, A, B, EB.D, A, C, B, EC.B, D, C, E, AD.D, B, E, C, AAnswer: ASection: (none)Explanation/Reference:QUESTION 27In which scenarios would you rebuild an index? (Choose all that apply.)A.when you need to disable the index usageB.when you need to change storage optionsC.when you need to enable index monitoringD.when you need to move the index to another tablespaceAnswer: BDSection: (none)Explanation/Reference:QUESTION 28You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:SGA_TARGET= 10GBSGA_MAX_SIZE = 14GBSTREAMS_POOL_SIZE = 1GBSHARED_POOL_SIZE = 3GBWhich two statements are correct in this scenario? (Choose two.)A. A maximum of 3 GB can be allocated to shared pool.B.The value for SGA_TARGET can be increased up to a maximum of 15 GB.C. A total of 14 GB memory will be allocated to the automatically tuned memory components.D.Increasing the value for SGA_TARGET will automatically increase the memory allocated forSTREAMS_POOL_SIZE.E.Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated toautotuned parameters.F.Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated toshared pool from 3 GB to 2 GB.Answer: BESection: (none)Explanation/Reference:QUESTION 29Which statement correctly describes the change tracking writer (CTWR) background process?A.It keeps track of changes in the background processes.B.It records the system change number (SCN) in the control file.C.It writes audit records for user changes to the change tracking file.D.It records any changes to the listened configuration in the listener.ora file.E.It records any changes to the database parameters in the change tracking file.F.It records the physical location of all the changes that are made to the database in the change trackingfile.Answer: FSection: (none)Explanation/Reference:Explanation:Subject: New Background Processes In 10gDoc ID: Note:268197.1 Type: HOWTOLast Revision Date: 18-JUL-2005 Status:PUBLISHEDCTWR=====This is a new process Change Tracking Writer (CTWR) which works with the new block changed tracking features in 10g for fast RMAN incremental backups.Subject: RMAN 10g : How To Size the Block Change Tracking File Doc ID: Note:306112.1 Type: HOWTO Last Revision Date: 22-MAY-2005 Status: REVIEWEDThe information in this document applies to:Oracle Server - Enterprise Edition - Version: 10.1.0.0 to 10.2.0.0 Information in this document applies to any platform.GoalThis is a clarification of the documentation for sizing the Block Change Tracking File.Block Change Tracking is used to optimize incremental backups. A new file is introduced:- Changed blocks are tracked by the CTWR background process as redo is generated- Database backups automatically use the change tracking file Sizing of this file is important, and even though you can use V$BLOCK_CHANGE_TRACKING viewto monitor the usage, it may in some cases not be easy to change the size, ie when using raw devices. QUESTION 30You work as a database administrator at Certkiller .com. In your production database, you observe thatusers' transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? (Choose three.)A.CPU usageB.degree of parallelismC.number of open cursorsD.number of sorts performedE.idle time for blocking sessionsF.number of disk I/O operations performedG.number of memory I/O operations performedAnswer: ABESection: (none)Explanation/Reference:QUESTION 31You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usagemetrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated.What could be the reason for this?A.The EVENT parameter was not set.B.The SQL_TRACE parameter is set to FALSE.C.The Enterprise Manager Grid Control is not used.D.The STATISTICS_LEVEL parameter is set to BASIC.E.The TIMED_STATISTICS parameter is set to FALSE.Answer: DSection: (none)Explanation/Reference:QUESTION 32You executed the following command in Recovery Manager (RMAN) against yourOracle 10g database:RMAN> REPORT NEED BACKUP days 3;What would be the output of this command?A. a list of files that require a backup within three daysB. a list of files that have not been backed up for three daysC. a list of files that RMAN recommends be backed up only once in every three days, based on lowvolatilityD. a list of files for which a backup has already been performed and may need a backup after three days Answer: BSection: (none)Explanation/Reference:QUESTION 33Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived and it contained information from 10:35 a.m. onwards.The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery:RMAN> RUN {2> SET UNTIL SEQUENCE 230 THREAD 1;3> ALTER DATABASE MOUNT;4> RESTORE DATABASE;5> RECOVER DATABASE;6> ALTER DATABASE OPEN RESETLOGS;With reference to this scenario, which statement is true?A.RMAN recovers up to log sequence 230, but not including 230.B.RMAN returns an error because the log sequence number mentioned in the command should be 229.C.RMAN returns an error because the log sequence number mentioned in the command may never bemissing.D.RMAN recovers up to and including log sequence 229 but then returns an error because log sequence230 is missing.Answer: ASection: (none)Explanation/Reference:QUESTION 34In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command:RMAN> RESTORE CONTROLFILE;Which two operations do you need to perform after restoring the control file from backup? (Choose two.)A.shut down and restart the instanceB.add new tempfiles to the temporary tablespaces after recoveryC.perform a media recovery and open the database with the RESETLOGS optionD.perform a media recovery and bring the database to NOARCHIVELOG modeAnswer: BCSection: (none)Explanation/Reference:QUESTION 35While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster.Which task must have been completed so that you are able to create the bitmap index?A. A primary key must have been created.B. A mapping table must have been created.C.An overflow tablespace must have been specified.D.The PCTTHRESHOLD option must have been specified.Answer: BSection: (none)Explanation/Reference:QUESTION 36ExhibitOne of the important tables in the USERStablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed that 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?A.You must recover all data files to the required system change number (SCN).B.You must recover all data files, except those that are offline, to the required SCN.C.You must recover all data files belonging to the USERS tablespace to the required SCN.D.You cannot recover all data files because segment space management is performed manually for theundo tablespace.Answer: BSection: (none)Explanation/Reference:QUESTION 37You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load.What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?A.mount the new disk group in the ASM instanceB.restart the ASM instance and the production database instanceC.register the new disk groups in the production database instanceD.restart the ASM instance without restarting the production database instanceE.include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart theASM instanceAnswer: ASection: (none)。

Exam : 1Z0-231Title : Oracle implement workflow 11i/2.6 Vendors :OracleVersion : DEMONO.1 John, a junior workflow developer, has approached you for advice on a workflow process that he isdefining. He is unclear about the implications of selecting the Runnable checkbox while defining theProcess Activity. What advice would you offer?A. Runnable allows the workflow engine to compile the process.B. Runnable allows the process to be included as a stand-alone subprocess.C. Runnable allows the workflow engine to check its status during process execution.D. Runnable allows the workflow engine to define this as a top-level process and initiate it. Answer: DNO.2 Message attributes must be associated with _____. (Choose all that apply.)A. a messageB. a notificationC. a responseD. an activity nodeAnswer: ANO.3 When a workflow application is integrated with Oracle Internet Directory, you must not create ad hocusers in the workflow local tables. What is the correct explanation for this restriction?A. to avoid discrepancies in user informationB. to avoid compromising the records in the WF_USERS viewC. to ensure that WF_ENGINE.CONTEXT_USER returns a reliable valueD. to ensure that users and positions in Oracle HR match workflow usersAnswer: ANO.4 You have been tasked with creating Business Events for an E-Business Suite workflow project. Whatwould you use to create your Business Events?A. Oracle Workflow BuilderB. Oracle Workflow Definition LoaderC. Oracle Business Event Definition LoaderD. Workflow Administrator Web page in E-Business SuiteAnswer: DNO.5 When defining a function activity, what is true about the Result Type? (Choose two.)A. Result Type is optional.B. Result Type is mandatory.C. Result Type can be changed after it is assigned to the function activity.D. Result Type should belong to the same item type as the function activity.Answer: ACNO.6 Under which four conditions can you create transitions, if the source activity in a workflow diagram hasan associated result type? (Choose four.)A. regardless of the result returned, labeled as <Any>B. when the activity times out, labeled as <Timeout>C. when the activity does not return a result, labeled as <No Match>D. when a result returned is not covered by other transitions, labeled as <Default>E. when a specific result is returned by the activity, labeled with the result display nameF. when the activity run simultaneously with 1 or more other activities, labeled as <Parallel> Answer: ABDENO.7 Which correctly describes the tiers of the Oracle Workflow architecture?A. Oracle Database tier and Application server tier onlyB. Oracle Database tier, Application server tier, and End-user client tier onlyC. Oracle Database tier, Application server tier, and Development client tier onlyD. Oracle Database tier, Application server tier, Development client tier, and End-user client tierAnswer: DNO.8 Which two are functions of Oracle Workflow Directory Service? (Choose two.)A. manage workflow notificationsB. provide information about rolesC. store performer and roles relationshipsD. manage workflow session connectionAnswer: BCNO.9 The WF_PARAMETER_LIST_T datatype can include up to a maximum of _____ parameter nameand value pairs.A. 99B. 100C. 101D. 999E. 1000Answer: BNO.10 You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?A. PhaseB. StatusC. Source TypeD. Rule FunctionE. Customization LevelAnswer: ENO.11 Which two statements are true about a Work Item with "Open" Notification? (Choose two.)A. The Work Item is not eligible for Purge.B. The Work Item is eligible for a Permanent purge.C. The Work Item is eligible for a Temporary purge.D. The Work Item is not complete because it still has "Open" Notification.E. The Work Item is eligible for both Temporary and Permanent purge.Answer: ADNO.12 You are creating a workflow. Which four activities can you perform using Oracle Workflow Builder'snavigation tree? (Choose four.)A. define functionsB. define notificationsC. define lookup codesD. control workflow processesE. upload and download data storesF. define processes and subprocessesAnswer: ABCFNO.13 What is the functionality of the "Allow modifications of customized objects" check box in the OracleWorkflow Builder dialog box that is displayed from the Help menu? (Choose two.)A. Having check box selected is equivalent to Workflow Definitions Loader Upgrade mode.B. Having check box deselected is equivalent to Workflow Definitions Loader Upload mode.C. If the check box is not selected, you can save your edits only to protected objects that you have accessto change, and cannot overwrite previously customized objects.D. If the check box is selected, you overwrite any protected objects that you have the ability (access) tomodify, and also any previously customized objects.Answer: CDNO.14 You completed your Java procedure for your external Java function activity, and you now want todeploy this to your server. What would you do to deploy the Java procedure?A. take the Java sources (.java) files and include them in your $APPL_TOPB. take the Java sources (.java) files and include them in your CLASSPATHC. take the Java classes (.class) files and include them in your $APPL_TOPD. take the Java classes (.class) files and include them in your CLASSPATHAnswer: DNO.15 What is true about a background engine? (Choose two.)A. It is a server-side PL/SQL procedure.B. When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.C. It executes deferred activities in decreasing order of their Cost property value (activities with highercost value are processed first).D. It would fail if another background engine process is started to handle the same type of activities withinthe same item type.E. During its single invocation, it processes activities that were stuck, deferred or timed out when thebackground engine was started.Answer: AENO.16 You completed your workflow definition. You want to save a copy of the definition to the file system forsource control purposes. How does Oracle Workflow Builder save that file?A. as a flat fileB. as a BPEL-compiled definitionC. as an XML file with an associated document type definition (DTD)D. as an XML file without an associated document type definition (DTD)Answer: ANO.17 Which option best describes the features of the Personal Worklist page, as compared with AdvancedWorklist?A. provides an overview of notificationsB. provides the capability to administer notificationsC. provides the most detailed options for searching workflowD. provides the most detailed options for searching workflow, and provides the capability to administernotificationsAnswer: CNO.18 Which three actions are allowed in event details? (Choose three.)A. SendB. RaiseC. DeleteD. ReceiveE. AcknowledgeAnswer: ABDNO.19 Which three types of integration does the Business Event System support? (Choose three.)A. point-to-pointB. parent/child messagingC. messaging hub systemD. distributed applications messagingE. simple object access protocol (SOAP) messagingAnswer: ACDNO.20 Which two agent listeners are meant for Oracle eBusiness Suite only? (Choose two.)A. Workflow ErrorB. Workflow DeferredC. Workflow Java ErrorD. Workflow Java DeferredE. Workflow Inbound NotificationF. Workflow Deferred NotificationAnswer: CD。

Oracle バックアップバックアップのの典型的な間違い典型的な間違いサーチマン佐藤サーチマン佐藤(Searchman Sato)(Searchman Sato)(Searchman Sato)/目次目次はじめに ......................................................................................................................................................................................................................................................................................................................................................................... 3 バックアップならエクスポート（の間違い） ............................................................................................................................................................................................................................... 4 バックアップですぐにツールを使う（の間違バックアップですぐにツールを使う（の間違い）い） .......................................................................................................................................................................................................... 7 物理バックアップは難しい（の間違い）.............................................................................................................................................................................................................................................. 8 ファイル同期を無視してバックアップ（の間ファイル同期を無視してバックアップ（の間違い）違い） ........................................................................................................................................................................................... 10 だったら意味ねえ、と怒る（間違い） ....................................................................................................................................................................................................................................................1111 複数ファイルを持てばいい（の間違い） ..................................................................................................................................................................................................................................................................... 14 おわりに (17)はじめにこんにちは、サーチマン佐藤です。

整理过程参考了一末夕阳的博客，复习过程的心得是，一百题看完复习前一部分,同时我还整理了一份打印版本的，上面只有题目，没有答案，建议在电脑上先看答案整理那一份,没有答案的那份打印出来，复习使用，可以有效加强记忆。

1.While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced。

Which two statements describe the consequences? (Choose two.)A。

The plan baselines can be evolved over time to produce better performance。

B. The newly generated plans are directly placed into the SQL plan baseline without being verified。

C。

The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.当部署一个新的应用模块时，软件供应商与用于被引入的新SQL的适当的SQL计划基线一起运送应用软件。

哪两个语句描述了后果？A，计划基线可以随着时间的推移演变,产生更好的性能。

Product Release Note Oracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II] [October] [2015]Product Release NoteTable of ContentsRELEASE NOTES (1)1.1B ACKGROUND /E NVIRONMENT (1)1.2P URPOSE (1)1.3P RODUCT S UMMARY (1)1.4R ELEASE H IGHLIGHTS (1)ENHANCEMENTS (2)1.5D ATAMYX I NTEGRATION (2)1.5.1Description (2)1.5.2Datamyx Input Files creation for Customers and FTP Upload (2)1.5.3Datamyx Triggers File Download, Dialer Extract Creation and ‘Triggers’ display (2)1.5.4Dealer / Sales Agent Reports on Datamyx Triggers (3)1.6I NTEGRATION I TEMS (4)1.6.1360 degree report and Combined Statement/Report Generation (4)1.6.2CASA Integration (4)1.6.3CIF Integration (7)PATCHES AND BUGS (14)SECURITY FIXES (15)LIMITATIONS AND OPEN ISSUES (16)1.7L IMITATIONS AND OPEN ISSUES (16)Release Notes1.1 Background / EnvironmentOracle Financial Services Software Limited has developed Oracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II] integrated solution with FLEXCUBE Universal Banking System. This integration enables OFSLL to integrate with FCUBS giving capability to integrate with centralized CIF, ELCM and CASA.OFSLL supports direct lending as well as indirect lending activities. For the indirect lending model, the solution offers comprehensive channel management that allows a financial institution to support its dealer network, including various compensation and participation programs.Oracle FLEXCUBE Universal Banking (FCUBS) is the core transaction processing back office system which caters to retail, corporate and investment streams of banking. FCUBS supports both retail and corporate flavors of lending and leasing businesses.OFSLL would be enhanced to co-exist and operate with a core banking system. With a generalized integration approach in place, effort required to integrate with any other third party core banking system can be considerably reduced.FCUBS is an application mainly for the banks and OFSLL is conventionally focused on NBFC (Non- banking financial company) market.1.2 PurposeThe purpose of this Release Note is to highlight the enhancements included in the Oracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II] integrated solution with FLEXCUBE Universal Banking System1.3 Product SummaryOracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II] integrated solution with FLEXCUBE Universal Banking System is built to meet various challenges faced by financial institutions. It addresses each of the lending processes — from design through execution. Its unique value lies in its ability to provide the business with predefined processes and a world-class framework that takes care of business risk and compliance needs.1.4 Release HighlightsThe key highlight of this release is to fix the critical bugs and to enhance the industry specific requirements.Enhancements1.5 Datamyx Integration1.5.1 Description∙To receive ‘Monitoring triggers from Datamyx, OFSLL provide s ‘input file’, which contains existing customer details. Once input files are created, OFSLL automatically uploads the same to Datamyx FTP server.1.5.2 Datamyx Input Files creation for Customers and FTP Upload∙Generate ‘input file’ using the BI Publisher. Input file has OFSLL existing customer information [Customer First Name, Customer Last Name, Full Street Address (Current Address), ZIP Code (Current Address), OFSLL Customer ID, and Customer Account Number].∙Using the ‘BI Publisher’, user can configure the frequency of file generation and auto upload into Oracle FTP server. Since system cannot access an external FTP server like Datamyx FTP server;for development purpose, system uses internal Oracle FTP server.∙While generating the customer input file, system needs to i nclude all the ‘ACTIVE’ customers (where loan account is not closed) every time, meaning Datamyx requires a full replacement of last sent file.∙In case multiple loan accounts exist for a customer, system needs to pick up the latest account created, meaning only one account number needs to be included.∙While creating the input file OFSLL needs to consider only the ‘primary applicant’ of a loan account∙ A facility is provided to upload the generated customer input file directly to the FTP server without any manual intervention from the lender side1.5.3 Datamyx Triggers File Download, Dialer Extract Creation and ‘Triggers’ display∙Manually download the latest Datamyx ‘Monitoring Triggers’ file from Oracle FTP server and save the information into OFSLL DB. (Post processing OFSLL Customer input file, Datamyx creates the corresponding monitoring triggers file and uploads the same into the designated location of Oracle FTP server).∙Creates a new batch job for the creation of ‘Market Trigger Events’ received on the response file to an account.∙Marketing trigger based campaign call activities are handled from the new tab ‘Cross/Up Selling Activities’ of customer services screen.∙Generates ‘Dialer Extract’ file by including the customer information received through the ‘Monitoring Triggers’ file and include s phone number details by picking the same from ‘Telecom’ section of OFSLL customer service customer details.∙While doing ‘call activities’, facility to view the ‘Monitoring Triggers’ information on the new tab ‘Cross / Up Selling Activities’ as part of OFSLL Customer Service screen.∙Facility to mark the information as part of ‘call activity’o Marks whether follow up required or noto Updates the follow up date∙ A marketing trigger based campaign call activity has any of the following ‘condition’ i.e.‘Opportunity’ either ‘Open’ or ‘Close’ and has a ‘Follow-Up Date’ in case it is still an ‘Open Opportunity’. While generating the dialer extract f or a date, system needs to include those accounts for which follow up date is same as extract file date and condition as ‘Open Opportunity’∙In case customer agrees for an offer provided by the marketing call agent, facility to create ‘Simple Loan Application’ so that origination process can be startedCross / Up Selling Activities. Path: Servicing → Customer Service → Cross/Up Selling Activities1.5.4 Dealer / Sales Agent Reports on Datamyx Triggers∙OFSLL supports a facility to generate Datamyx monitoring triggers report on customers with customer contact details and trigger(s) information1.6 Integration Items∙When in an integrated environment (INT_FCUBS = ‘Y’), OFSLL is enhanced to addresses the following scenarios.1.6.1 360 degree report and Combined Statement/Report Generation∙In case of customers who are having transactions across FCUBS and OFSLL business products, following FCUBS reports include OFSLL assets (Loan/Line/Lease) details. OFSLL sends the required information to generate the following reportso Combined Statement Generation (CSRCSTAD)o360 Degree Customer Report (Retail /Corporate) (STRCUSRP)∙FCUBS combines the list of all accounting transaction linked to a given CIF and generate as one single report. When the user generates the ‘combined statements’ by providing the required details and/ or the customer report, it generates the report with all the account details linked to the CIF number.∙While generating the report if there is any OFSLL accounts linked to CIF Id, FCUBS gets those details from OFSLL over DB call. OFSLL needs to fetch the required details to generate the report from transaction history (online) and hand off the details to FCUBS (Online). Then combine both details and generate the report in FCUBS∙If a single customer has different types of loans transactions spread across product processors of FCUBS and OFSLL like Mortgage Loans in FCUBS Mortgages module, Personal Loans in OFSLL Loans and Car Loan in OFSLL Auto loans, then, in this case, account statements /common asset reports generated by FCUBS for this customer includes OFSLL loan accounts also.o Customer Combined statement (CSRCSTAD) generated for a CIF includes the Loan/Line/Lease account details of the customer.o In Combined Statement Maintenance (STDCDSTM) screen, a facility is provided to select OFSLL asset account details also along with FCUBS assets.o In 360 Degree Customer Report (Retail/Corporate) (STRCUSRP), if the customer is having active asset details maintained in OFSLL, same also get displayed along with the assetdetails maintained in FCUBS.1.6.2 CASA Integration1.6.2.1Recurring CASA debits – [Incoming Payments]∙Recurring CASA Debits Retry [INCOMING PAYMENTS] –The batch is enhanced and forwarded to FCUBS to process the CASA debit∙New system parameter (CASA_DEBIT_MAX_RETRY_COUNT - MAXIMUM # OF TIMES THE CASA DEBIT RETRY ALLOWED FOR UNSUCCESSFULL PAYMENT is created to configure number of times the CASA debit retry count should be triggered (a numeric value parameter) ∙ A new batch job set ‘SET-ICS2’ is created, existing ‘ICCPRC_BJ_100_01’ batch job for CASA debit retry is enhanced and placed under the new ‘SET-ICS2’ batch job set.∙This batch runs in BOD and picks all the accounts, where CASA debit is required [based on criteria-> System date=Payment Due date] and does a function call one by one.o If payment is successful, system posts record in ‘CASA Reconciliation’ screen as ‘Processed’.o If payment is not successful, system posts a record in ‘CASA Reconciliation’ screen under NSF with NSF sub status as ‘OPENED’.o After system attempts ‘N’ number of times (based on system parameter) ‘CASA Debit Retry’ batch, if payment is successful then in ‘CASA Reconciliation’ screen the existingrecord in NSF with sub status ‘OPENED’ gets changed to ‘CLOSED’ (So whole NSF statuswould be ‘NSF-CLOSED’).∙At EOD, system picks up only ‘NSF-OPENED’ status records for ‘CASA Debit Retry’ before Non-sufficient funds batch job.∙Once NSF is posted, the ‘NSF-OPENED’ status record in ‘CASA Reconciliation’ screen change s to ‘NSF-CLOSED’ status.1.6.2.2Advance Entry [Outgoing payments]Few changes are taken in ‘Advance Entry’ screen to enable CASA entries.∙‘CASA Payments’ batch type is provided in ‘Advance Entry > Batch section > Batch Type’ LOV field.∙By default ‘CASA’ mode will be selected for ‘CASA Payments’ batch type in ‘Advance Entry > Advances section > Mode’ LOV field as shown in figure below.On posting, OFSLL calls FCUBS function for crediting CASA and debiting OFSLL account.∙On posting, OFSLL calls FCUBS function for crediting CASA and debiting OFSLL account.∙CASA advance reversal is allowed; On reversal, OFSLL will call the reversal function.∙All the advance entry transactions are recorded in AP transactions. Currently ‘Currency’ field is text field; it is changed to LOV field and is configured to ‘CURRENCY_CD’ l ook up type.∙In ‘Advance Entry’ screen ‘Advance Allocations’ is made mandatory for posting advances, system validates before posting whether ‘Advance Allocations’ are provided or not.‘Advance Entry Screen’ for CASA Payments1.6.2.3Advance Maintenance [Outgoing payments]∙New fragment ‘Advance Allocations’ is introduced in ‘Advance Maintenance’ screen with ‘Edit, View and Audit’ buttons.‘Txn Amt’ field in ‘Advance Maintenance >Advances Section’ is made non-editable, which was earlier editable.∙Based on the total ‘Advance Allocations’ amount, system validate s and updates the ‘Txn Amt’ field in ‘Advance Maintenance >Advances Section’. When user updates any record in ‘Advances’ section of ‘Advance Maintenance’ screen, system reverse s the existing amount and reposts with the updated amount and other details.∙When user updates any record in ‘Advance Maintenance > Advance Allocation’ section, it is updated at following places.o For CASA payments both in OFSLL account and FCUBS account.o For non-CASA payments only in OFSLL account.o‘Txn Amt’ Amount in the ‘Advances’ section record.∙All the ‘Advance Entry and Advance Maintenance’ transactions are recorded in ‘AP Transactions’.∙All CASA related transactions in ‘Advance Entry and Advance Maintenance’ screens are recorded in ‘CASA Reconciliation’ screen also.∙In ‘AP Transactions’ screen only the ‘Open’ status transactions are allowed to reverse the transaction.‘Advance Maintenance Screen’ for CASA Payments1.6.3 CIF Integration1.Changes done in Origination >Business Tab and Servicing >Business tab.∙“Existing Business #” is added in Origination >Business> Business >Affiliate Tabs. (Read only). “Existing Business” check box is added in Origination >Business> Business>Affiliate Tabs. (This is checked automatically). When user searches and adds a businessfrom “Business Search”, system populates the “Corporate CIF” number in “ExistingBusiness number” field and “Existing Business” check box is checked.∙“Business #” is added in Servicing > Customer Details> Business> Business Tab (Read only). When user adds a “Corporate CIF” using non mon etary transaction, systempopulates the “Corporate CIF” number in “Business #” field.Origination:Servicing:2.Changes done in Origination >Business >Business Search tab∙“Customer Type” LOV (Values as ‘Business’ and ‘Affiliates’) field is added in “Search Result” header in Origination >Business > Business search. “Copy Details” button isadded in Origination> Business>Business Search tab.∙If user selects Customer type as “Business” and clicks on “Copy Details”, business details are populated in Business >Business Details table. When the Business recordalready exists with same “Business Number” in “Business” tab, system throws anerror saying “Record Already Exists” and doesn’t allow copy ing the details.∙When user selects Customer type as “Affiliates” and if clicks on “Copy Details”, business details are populated in Business >Affiliates tab. If user tries to map thesame ‘Business Number’ to Business/Affiliate (both), system gives error m essage –“Cannot copy Business details, Business is already mapped to the Application”3.New Business “Tracking Attributes” tab∙“Tracking Attributes” tab is added tab under Origination >Business> Business and Servicing >Customer Details > Business. These “Tracking Attributes” gets copied to“Servicing” after Funding the Application4.Search and add the “Partner CIF” fr om Origination >Customer Search∙“Copy Partner Details” button is added next to the “Copy Customer Details” button in Origination >Customer Search. If user selects a Customer from search result andclicks on “Copy Partner Details” button, system copies the Customer details toPartner details in Origination >Business >Partners Tab.∙Mapping is done between “Customer” tables and “Partner” tab. Bu tton is enabled only when business tab is enabled5.Map the “Deceased” fag in FCUBS with “Deceased Date” the OFSLL∙The “Customer Deceased Date” of FCUBS is mapped to “Customer Deceased Date”in Servicing >Customer Details >Customer tab of OFSLL∙Changes done in FCUBS: “Customer Deceased Date” field is added in “OFSLL Parameters” tab in “STDCIF”. If the “Deceased” flag set as “Yes”, system makes the“Customer Deceased Date” as mandatory field and if user tries to input ‘CustomerDeceased Date’ without checking the ‘Deceased’ check box (In STDCIF Screen);system throws an error. FCUBS sends this “Customer Deceased Date” as part of CIFdata propagation to OFSLL.∙Changes done in OFSLL: OFSLL consumes the “Customer Deceased Date” as part of CIF data propagation from FCUBS and populates in “Customer Deceased Date” fieldin Servicing >Customer DetailsFCUBS ScreenOFSLL Screen6.“OFSLL Loan” balances are shown in 360 Degree View of FCUBS under “Summary >BalanceSheet Asset and Liabilities” for both Retail and Corporate. Sum of “Pay Off Amt” field of OFSLL is displayed Under “Assets” side of “Summary >Balance Sheet Asset and Liabilities” block7.Invoke OFSLL “Servicing/ Collection” Screen from FCUBS 360 Degree View screen of “Retail andCorporate Custome rs”.If user clicks on an Account number in “OFSLL Loans” tab, FCUBS System invokes a popup of respective account “Servicing/Collection” Screen of OFSLL. If user clicks onmultiple accounts, FCUBS opens multiple popup screens with respective account“Servicing/Collection” Screen of OFSLLFCUBS ScreenOFSLL Screen8.Map the “Tenure” field of “Professional” in FCUBS to “Years” field of Employment details Statedand Actual in Employments tab of OFSLL.Employment details field “Months” Stated and Actual in OFSLL are hidden (This information is not editable in OFSLL; if its populated from FCUBS) FCUBS ScreenOFSLL9.Display the Business (Corporate CIF) CASA account details of FCUBS in OFSLL Business>Financials TabWhen the existing Corporate customer is added as a Business, system pulls the CASA account details of Existing Corporate CIF and displays in Business > Financials tab.(Information in this tab is queried on FCUBS database). “Savings” and “TermDeposits” of FCUBS will be displayed under “Financial” tab of OFSLLPatches and BugsSecurity FixesLimitations and Open issues1.7 Limitations and open issuesSome of the limitations as well as known open issues within the application areProduct Release Note[October] [2015]Oracle Financial Services Lending and Leasing Release 14.2.0.0.1 [Phase II]Oracle Financial Services Software LimitedOracle ParkOff Western Express HighwayGoregaon (East)Mumbai, Maharashtra 400 063IndiaWorldwide Inquiries:Phone: +91 22 6718 3000Fax:+91 22 6718 3001/financial_services/Copyright © 1998, 2015, Oracle and/or its affiliates. All rights reserved .Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are “commercial computer software” pursuant to the applicable Federal Acquisition Regulation and agenc y-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or recompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. This software or hardware and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.。

Oracle® CloudImages for Oracle Tuxedo for OCI Release 22cF75080-04May 2023Oracle Cloud Images for Oracle Tuxedo for OCI, Release 22c F75080-04Copyright © 2022, 2023, Oracle and/or its affiliates.Primary Author: Preeti GandheContributing Authors: Tulika DasContributors: Maggie Li, Yash PatilContents1 Images for Oracle Tuxedo for OCI1.1About Oracle Tuxedo for OCI Images1-11.2Software Requirements1-31.3Ongoing Maintenance and Patching Requirements1-42 Create an Instance2.1Use an Image2-12.2Create Compartment Policies2-22.3Create an Instance Using the Compute Instance Console2-32.4Create an Instance Using the Marketplace2-41Images for Oracle Tuxedo for OCILearn about the images in Oracle Tuxedo for Oracle Cloud Infrastructure (Oracle Tuxedo forOCI) and how to use these images to create instances in Oracle Tuxedo for Oracle CloudInfrastructure.Topics:•About Oracle Tuxedo for OCI Images•Software Requirements•Ongoing Maintenance and Patching Requirements1.1 About Oracle Tuxedo for OCI ImagesOracle Tuxedo for OCI images are preinstalled with the Oracle Tuxedo software version22.1.0.0.0, shipped with Rolling Patch 001 (RP001). The Oracle Tuxedo for OCI images useOracle Linux 8.6 as the operating system.Oracle Tuxedo for OCI supports:•Bring Your Own License (BYOL) Images: If you already have a valid Tuxedo license and a support contract to use Tuxedo, then you can bring those licenses to OCI for usingthe BYOL images. You will only pay for the charges associated with the infrastructure andthe computing, for example, OCPUs, storage, and anything else required by the Tuxedoapplication.•Universal Credits Model (UCM) Images: Using UCM images incurs a fee per OCPU per hour for accessing the Tuxedo software. The use of these images implies a license andsupport agreement, even though a contract is not required.Table 1-1 Oracle Tuxedo OCI Marketplace Image billing optionsBring Your Own License (BYOL)Universal Credits Model (UCM)User brings user's own license.Oracle provides the license to the user.User is charged only for the Cloud er is charged for both the license and theinfrastructure.Oracle Tuxedo for OCI offers the following BYOL and UCM images:Oracle Tuxedo ImageIf you want to utilize only Oracle Tuxedo, without any add-on products.Oracle Tuxedo Enterprise Edition ImageIf you want to use at least one of the add-on products, in addition to Oracle Tuxedo. Inaddition to Oracle Tuxedo, the Enterprise Edition includes the following add-ons:•Oracle® Tuxedo Advanced Performance PackChapter 1About Oracle Tuxedo for OCI Images•Oracle® Tuxedo Jolt•Oracle® Service Architecture Leveraging TuxedoOracle Tuxedo Mainframe Modernization Runtimes ImageIn addition to Oracle Tuxedo Enterprise, the Oracle Tuxedo Mainframe Modernization subscription enables you to use at least one Tuxedo Mainframe Modernization Runtimes. Oracle Tuxedo Mainframe Modernization Runtimes include the following add-ons:•Oracle® Tuxedo Application Runtime for CICS•Oracle® Tuxedo Application Runtime for Batch•Oracle® Tuxedo Application Runtime for IMS•Oracle® Tuxedo Application Rehosting Test ManagerShapes for Oracle Tuxedo for OCI imagesYou can use any of the following compute shapes to create an instance with Oracle Tuxedo for OCI images:Standard- VM.Standard1.1, VM.Standard1.16, VM.Standard1.2, VM.Standard1.4, VM.Standard1.8,VM.Standard2.1, VM.Standard2.16, VM.Standard2.2,VM.Standard2.24, VM.Standard2.4,VM.Standard2.8, VM.Standard.B1.1, VM.Standard.B1.16,VM.Standard.B1.2, VM.Standard.B1.4,VM.Standard.B1.8, VM.Standard.E2.1, VM.Standard.E2.2,VM.Standard.E2.4, VM.Standard.E2.8FlexibleVM.Standard3.Flex (OCPU Constraint: 1 - 32, Memory Constraint: 1GBs - 512GBs) ,VM.Standard.E3.Flex (OCPU Constraint: 1 - 64, Memory Constraint: 1GBs - 1024GBs) ,VM.Standard.E4.Flex (OCPU Constraint: 1 - 64, Memory Constraint: 1GBs - 1024GBs)OptimizedVM.Optimized3.Flex (OCPU Constraint: 1 - 18, Memory Constraint: 1GBs - 256GBs)DenseVM.DenseIO2.16, VM.DenseIO2.24, VM.DenseIO2.81.2 Software RequirementsTable 1-2 Software Requirements for Tuxedo 22cComponent RequirementCOBOL CompilerMicro Focus Visual COBOL v6.0 or laterJava 2 JRE for the Java run-time environment T ested with JRE 1.8.0_341, 11.0.15.1, and 17.0.4and OpenJDK 17Java 2 Software Development Kit (SDK) for the Java development environment T ested with JDK 1.8.0_341, 11.0.15.1, and 17.0.4and OpenJDK 17Database for CORBA C++ applicationsT ested with Oracle Client 12cFor more additional information, please refer to Oracle Tuxedo Installation Guide .Table 1-3 Software Requirements for Tuxedo Application RuntimesComponent Requirement COBOL Compiler•Micro Focus Visual COBOL v6.0 or later •COBOL-IT Enterprise Edition 3.x(3.9.16 or later)Database Oracle database 12c or later Shell kshperlperl 5.28 or above with moduleData::Dumper(perl-Data-Dumper) installedChapter 1Software RequirementsChapter 1Ongoing Maintenance and Patching Requirements1.3 Ongoing Maintenance and Patching RequirementsOracle strongly recommends that you download and apply the latest patch, andupgrade your Tuxedo release as and when required. By patching the softwareregularly, you can update any security vulnerabilities and include the latest bug fixes.2Create an InstanceLearn how to create an Oracle Tuxedo for OCI compute instance using Oracle Tuxedo forOCI images.Topics:•Use an Image•Create Compartment Policies•Create an Instance Using the Compute Instance Console•Create an Instance Using the Marketplace2.1 Use an ImageUtilizing the Oracle Tuxedo for OCI images, you can create Oracle Tuxedo domain nodes inthe Oracle Cloud Infrastructure compute instances, with the entitlement to use Tuxedosoftware. The Oracle Tuxedo for OCI images contain the following two directories:•/u01/oraHome: Tuxedo software is installed in this directory. It also includes other utilities such as Oracle JDK 1.8 and OPatch.•/u01/app/oraInventory: Tuxedo inventory information is stored in this directory. Data files, installation logs, and Oracle home information are stored in it.Follow these instructions to use the Oracle Tuxedo for OCI images:•When you create an instance using an image, you must specify an SSH key. You require this SSH key to access the instance and launch it.•You can connect to an instance using the SSH command as the opc user.•SSH Private key: The private key associated with the public key is used duringprovisioning. For example, $ssh -I <private_key> opc@< ip_address>•The user public key was provided during provisioning. Log in directly with the following command: $ssh opc@< ip_address>•When you have logged in as the OPC user, switch to the Oracle user by using thefollowing command: $sudo su oracle•Use the source command to load Tuxedo environment variables such as TUXDIR, and JAVA_HOME from the tux.env file, which is required to run Tuxedo.Chapter 2Create Compartment Policies –Run the following command to load the Tuxedo environment variable:source /u01/oraHome/tuxedo22.1.0.0.0/tux.env•By default, tlisten is not configured. Oracle TSAM plus and MP/clustered mode configuration require tlisten. Follow the instructions to set the tlisten password:–cd /u01/oraHome/tuxedo22.1.0.0.0/–. ./tux.env–tlistpwd $TUXDIR•Tuxedo supports TLS by default. It is optional to use LDAP. When using Oracle Wallet, LDAP is not required. A user is required to configure LDAP only if any ofthe following conditions are met.–The use of legacy security credentials–The local host must use a port other than 389 for LDAP–There is no LDAP server running on localhost•LDAP configuration: Use the epifregedt command to modify the registry.•Use the following 3 commands after initialization to modify the TLS LDAPinformation:1.epifregedt -s -k SYSTEM/impl/security/BEA/key_management -aParams=privateKeyDir=file:///$TUXDIR/udataobj/security/keys2.epifregedt -s -k SYSTEM/impl/security/BEA/certificate_validation -aParams=caCertificateFile=file:///$TUXDIR/udataobj/security/certs/trust_ca.cer -a Params=peerValidationRuleFile=file:///$TUXDIR/udataobj/security/certs/peer_val.rul3.epifregedt -s -k SYSTEM/impl/security/BEA/certificate_lookup -aParams=userCertificateLdap=ldap://*LDAP_SERVICE_NAME*:*LDAP_PORTID*-a Params=ldapBaseObject=*LDAP_BASE_OBJECT* -aParams=filterFileLocation=file:///*LDAP_FILTER_FILE_LOCATION*•On Unix, the Tuxedo registry is located at $TUXDIR/udataobj/System.rdp. Using the command epifregedt -g, you can print the current registry. The firstcommand modifies the key management object to specify a particular private keydirectory.•Please run the following command and instructions to reset the administratorpassword for Oracle® Tuxedo Application Rehosting Test Manager.–$ORA_HOME/art_tm12.2.2.0.0/config.sh•Following links (if any) for creating a Tuxedo Domain: Using the Tuxedo Domains Component.2.2 Create Compartment PoliciesYou must be granted management access to Marketplace applications and ResourceManager if you are not an Oracle Cloud Infrastructure administrator. Oracle Tuxedo forOCI images allows you to create compute instances.The following are sample policies:Allow groupMyGroup to use app-catalog-listing in compartment MyCompartmentAllow groupMyGroup to manage instance-family in compartment MyCompartmentAllow groupMyGroup to manage orm-family in compartment MyCompartmentAllow group MyGroup to manage virtual-network-family in compartment MyNetworkCompartment2.3 Create an Instance Using the Compute Instance ConsoleThe compute instance console enables you to create a new instance using Oracle Tuxedo for OCI images.Follow the instructions to create an instance:1.Sign in to the Oracle Cloud Infrastructure console.2.Click Navigation from the menu, select Compute and under the Compute group, click Instances .3.Click Create Instance .If required, you can modify the name of the instance.4.Select the compartment in which to create the instance.5.Under Placement , select the Availability Domain for creating the instance. Click Show advanced options .6.Under Image and Shape , click Change Image and follow the instructions:a.From the Image source drop-down, select Marketplace , and you can either use Search or select one of the following Oracle Tuxedo for OCI images:•Oracle Tuxedo BYOL Image•Oracle Tuxedo Enterprise BYOL Image •Oracle Tuxedo UCM Image•Oracle Tuxedo Enterprise UCM Image•Oracle Tuxedo Mainframe Modernization Runtimes BYOL Image •Oracle Tuxedo Mainframe Modernization Runtimes UCM Imageb.For the selected image, click Arrow on the right, and then select the image build version for the BYOL or UCM images. For example, Oracle Linux 8.6 (labeled as <release >-ol8.6-<build >-<timestamp >)Chapter 2Create an Instance Using the Compute Instance Consolec.Review the terms and conditions and select the Oracle Terms of Use check box and click Select Image .7.Under Image and Shape , click Change Shape . Select the Instance Type andselect the shape.While creating a virtual machine, under Shape series , select a processor group,and then select a shape. To know the supported shapes, see Shapes for the images .8.Configure the network for the instance. Click Show advanced options to specify advanced network settings.9.Under Add SSH keys , generate a key, upload your public key, or paste the keys.10.Under Boot Volume , specify the size and encryption options for the instance's boot volume.11.Click Show advanced options to configure advanced settings.12.Click Create .For more details, see Creating a Linux instance in Oracle Cloud Infrastructure documentation .2.4 Create an Instance Using the MarketplaceBy using the Oracle Tuxedo for OCI images available on the Marketplace, you can create a new instance.Follow the instructions to create an instance using the Marketplace:1.Sign in to the Oracle Cloud Infrastructure console.2.Click the navigation menu, select Marketplace , and then click All Applications .3.Select one of the following Oracle Tuxedo for OCI images (BYOL or UCM) :•Oracle Tuxedo BYOL Image •Oracle Tuxedo Enterprise BYOL Image •Oracle Tuxedo UCM Image •Oracle Tuxedo Enterprise UCM Image •Oracle Tuxedo Mainframe Modernization Runtimes BYOL Image •Oracle Tuxedo Mainframe Modernization Runtimes UCM Image4.From the Version drop down, select the image build version.Every image is built for a specific operating system, which may not support all operating systems.•Oracle Linux 8.6 (labeled as <release >-ol8.6-<build >-<timestamp >)5.Review the terms and conditions and select the Oracle Terms of Use check box.6.Click Launch Instance .7.Select the compartment in which you want to create the instance.8.Under Placement , select the Availability Domain for creating an Instance.Click Show advanced options to specify capacity type and fault domain.9.Under Image and Shape , click Change Shape . Select the Instance Type andselect the shape.Chapter 2Create an Instance Using the Marketplace2-4While creating a virtual machine, under Shape series , select a processor group, and then select a shape. To know the supported shapes, see Shapes for the images .10.Configure the network for the instance and click Show advanced options to specifyadvanced network settings.11.Under Add SSH keys , generate a key, upload your public key, or paste the keys.12.Under Boot Volume , specify the size and encryption options for the instance's bootvolume.13.Click Show advanced options to configure advanced settings.14.Click Create .For more details, see Creating a Linux instance in Oracle Cloud Infrastructure documentation .Chapter 2Create an Instance Using the Marketplace2-5。