简述游标的作用和游标操作的基本步骤。

简述游标的作用和游标操作的基本步骤。


相关考题:

关于程序包中的游标说法正确的有()。A、可定义为%ROWTYPE类型B、Return子句是可选的C、在包的实现体部分必须给出游标的完整声明D、不可以定义Ref游标

You find today’s performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()A、create baseline metrics for today’s performanceB、write the current database metrics to a database table and create a trigger to compare with future database statisticsC、write the current database metrics to a flat file and create an operating script to compare with future database statisticsD、write the current database metrics to a database table and create a procedure to compare with future database statisticsE、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

Which three SELECT statements displays 2000 in the format “$2,000.00”?()A、SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;B、SELECT TO CNAR(2000, ‘$0,000.00’) FROM dual;C、SELECT TO CNAR(2000, ‘$9,999.00’) FROM dual;D、SELECT TO CNAR(2000, ‘$9,999.99’) FROM dual;E、SELECT TO CNAR(2000, ‘$2,000.00’) FROM dual;F、SELECT TO CNAR(2000, ‘$N,NNN.NN’) FROM dual;

Which command would you use to determine what database backups are currently available for restore?()A、list database backupB、report database backup  C、list backup of databaseD、list summary backupE、report backup of database

Which two tasks can your perform by using the TO_CHAR function? ()A、Convert 10 to 'TEN'B、Convert '10' to 10C、Convert '10' to '10'D、Convert 'TEN' to 10E、Convert a date to a character expressionF、Convert a character expression to a date

You are managing an Oracle Database 11g database with this backup strategy:  - Every Sunday night, level 0 backup is performed.  - On Monday night and subsequent days, level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true()A、The backup contains all the used blocks.B、The backup contains all the used and unused blocks.C、The backup contains blocks that have changed since the last level 0 backup.D、The backup contains blocks that have changed since the last level 1 backup taken last week.

Which two Oracle products come pre-packaged with Oracle’s JRockit JDK ?()A、 Oracle WebLogic ServerB、 Oracle CoherenceC、 Oracle DatabaseD、 Oracle Real Time Operations Control

What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()A、BMR lowers the mean time to recover (MTTR).B、BMR supports point­in­time recovery of individual data blocks.C、BMR enables you to use incremental backups for block recovery.D、BMR enables recovery even when the database is not mounted or open.E、BMR enables you to use proxy backups to perform block media recovery.F、BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.

Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area (UGA) information and improve the shared pool performance?()A、large poolB、streams poolC、keep buffer cacheD、recycle buffer cache

You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()A、 You find that one of the redo log members in each redo log group is lost.B、 You find that a data file that belongs to the USERS tablespace is damaged.C、 You find that a data file that belongs to the SYSTEM tablespace is damaged.D、 You find that the current redo log group is damaged and is not available for recovery.E、 You realized while performing a recovery that an archived redo log file needed for recovery is lost.