What is CYCLE/NO CYCLE in a Sequence ?

What is CYCLE/NO CYCLE in a Sequence ?
by

1 Answer

Answer :

CYCLE specifies that the sequence continues to generate values after
reaching either maximum or minimum value. After pan ascending sequence reaches its maximum value, it generates its minimum value.
After a descending sequence reaches its minimum, it generates its
maximum.NO CYCLE specifies that the sequence cannot generate
more values after reaching its maximum or minimum value.
by

Related questions

What is a Sequence ?

Description : What is a Sequence ?

Last Answer : A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

What are the types of triggers and how the sequence of firing in text item

Description : What are the types of triggers and how the sequence of firing in text item

Last Answer : Triggers can be classified as Key Triggers, Mouse Triggers ,Navigational Triggers. Key Triggers :: Key Triggers are fired as a result of Key action.e.g :: Key-next-field, Key-up,Key-Down Mouse Triggers :: Mouse ... :: a) pre - text b) when new item c) key-next d) when validate e) post text

How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?

Description : How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?

Last Answer : Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

Give the sequence of execution of the various report triggers?

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

What is an Oracle sequence?

Description : What is an Oracle sequence?

Last Answer : A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

The join defined by the default data link is an outer join yes or no?

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Last Answer : Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

Difference between NO DATA FOUND and %NOTFOUND?

Description : Difference between NO DATA FOUND and %NOTFOUND?

Last Answer : NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead.

What is the built-in routine used to count the no of rows in a group?

Description : What is the built-in routine used to count the no of rows in a group?

Last Answer : Get_group _row_count System Variables

Which parameter in Storage clause will reduce no. of rows per block?

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

Why is it preferable to create a fewer no. of queries in the data model?

Description : Why is it preferable to create a fewer no. of queries in the data model?

Last Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

What is the maximum no of chars the parameter can store?

Description : What is the maximum no of chars the parameter can store?

Last Answer : The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

Identify the correct sequence of events in a cardiac cycle `:-`

Description : Identify the correct sequence of events in a cardiac cycle `:-`

Last Answer : Identify the correct sequence of events in a cardiac cycle `:-` A. Joint diastole `rarr` ... systole `rarr` Joint diastole `rarr` Ventricular systole

Carbon cycle includes (the following is a logical sequence)

Description : Carbon cycle includes (the following is a logical sequence)

Last Answer : Carbon cycle includes (the following is a logical sequence) A. `"Producer" to "Consumer" to " ... . `"Consumer" to "Producer" to "Decomposer"`

A simple sequence in which the grass grows, a cow eats the grass, a human eats the cow or drinks its milk, is an example of - (a) food chain (b) food web (c) food cycle (a) pyramid

Description : A simple sequence in which the grass grows, a cow eats the grass, a human eats the cow or drinks its milk, is an example of - (a) food chain (b) food web (c) food cycle (a) pyramid

Last Answer : Ans:(a)

__is the sequence of operations performed by CPU in processing an instruction: a. Execute cycle b. Fetch cycle c. Decode d. Instruction cycle

Description : __is the sequence of operations performed by CPU in processing an instruction: a. Execute cycle b. Fetch cycle c. Decode d. Instruction cycle

Last Answer : d. Instruction cycle

The correct sequence of phases of cell cycle is (a) G1 → S → G2 → M (b) M → G1 → G2 → S (c) G1 → G2 → S → M (d) S → G1 → G2 → M.

Description : The correct sequence of phases of cell cycle is (a) G1 → S → G2 → M (b) M → G1 → G2 → S (c) G1 → G2 → S → M (d) S → G1 → G2 → M.

Last Answer : (a) G1 → S → G2 → M

Which one of the following represents the correct sequence of stages in the life cycle of flukes? a. Cercaria to redia to miracidium to sporocyst b. Miracidium to sporocyst to redia to cercaria c. Metacercaria to redia to cercaria to sporocyst d. Redia to miracidium to metacercaria to cercaria

Description : Which one of the following represents the correct sequence of stages in the life cycle of flukes? a. Cercaria to redia to miracidium to sporocyst b. Miracidium to sporocyst to redia to cercaria c. Metacercaria to redia to cercaria to sporocyst d. Redia to miracidium to metacercaria to cercaria

Last Answer : b. Miracidium to sporocyst to redia to cercaria

Consider the following processes: [IES-1999] 1. Constant pressure heat addition. 2. Adiabatic compression. 3. Adiabatic expansion. 4. Constant pressure heat rejection. The correct sequence of these processes in Rankine cycle is: (a) 1, 2, 3, 4 (b) 2, 1, 4, 3 (c) 2, 1, 3, 4 (d) 1, 2, 4, 3

Description : Consider the following processes: [IES-1999] 1. Constant pressure heat addition. 2. Adiabatic compression. 3. Adiabatic expansion. 4. Constant pressure heat rejection. The correct sequence of these processes in Rankine cycle is: (a) 1, 2, 3, 4 (b) 2, 1, 4, 3 (c) 2, 1, 3, 4 (d) 1, 2, 4, 3

Last Answer : (c) 2, 1, 3, 4 

Which one of the following statements concerning the accounting cycle is incorrect? a. The accounting cycle includes journalizing transactions and posting to ledger accounts. b. The accounting cycle includes only one optional step. c. The steps in the accounting cycle are performed in sequence. d. The steps in the accounting cycle are repeated in each accounting period.

Description : Which one of the following statements concerning the accounting cycle is incorrect? a. The accounting cycle includes journalizing transactions and posting to ledger accounts. b. The accounting cycle includes ... sequence. d. The steps in the accounting cycle are repeated in each accounting period.

Last Answer : b. The accounting cycle includes only one optional step.

Arrange the knitting sequence in correct order 1. Needle falls, old loop rises closing latch of the needle 2. Needle is now ready to repeat cycle 3. Old loop is held on the stem of the needle. The latch is open 4. Old loop is cast off; new loop pushes the lap to open; needle rises and the new loop slides down to the stem of the needle 5. New loop is formed around the hook of the needle a. 2,1,5,3,4 b. 3,5,1,4,2 c. 3,5,4,1,2 d. 2,1,4,3,5

Description : Arrange the knitting sequence in correct order 1. Needle falls, old loop rises closing latch of the needle 2. Needle is now ready to repeat cycle 3. Old loop is held on the stem of the needle. The latch is open 4. Old loop is cast off; new ... a. 2,1,5,3,4 b. 3,5,1,4,2 c. 3,5,4,1,2 d. 2,1,4,3,5

Last Answer : b. 3,5,1,4,2

Continual (Continuous) improvement cycle is based on systematic sequence of -------------- activities. a) SDLC b) PDCA c) waterfall model

Description : Continual (Continuous) improvement cycle is based on systematic sequence of -------------- activities. a) SDLC b) PDCA c) waterfall model

Last Answer :  Ans : b.

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

What is import/export and why does one need it? (for DBA

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Are there any troubleshooting tips for OEM? (for DBA

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Where can one get more information about TCL? (for DBA

Description : Where can one get more information about TCL? (for DBA

Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

How does one start the Oracle Intelligent Agent? (for DBA

Description : How does one start the Oracle Intelligent Agent? (for DBA

Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:

What is the Oracle Intelligent Agent? (for DBA

Description : What is the Oracle Intelligent Agent? (for DBA

Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.

What are the types of SQL Statement ?

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

How does one backout events and jobs during maintenance slots? (for DBA

Description : How does one backout events and jobs during maintenance slots? (for DBA

Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes

What are the pre requisites ?

Description : What are the pre requisites ?

Last Answer : I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.

What kind of jobs can one schedule with OEM? (for DBA

Description : What kind of jobs can one schedule with OEM? (for DBA

Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

Difference between SUBSTR and INSTR ?

Description : Difference between SUBSTR and INSTR ?

Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Description : Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.

Explain UNION,MINUS,UNION ALL, INTERSECT ?

Description : Explain UNION,MINUS,UNION ALL, INTERSECT ?

Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

WHY USE RMAN ? (for DBA

Description : WHY USE RMAN ? (for DBA

Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

WHAT IS RMAN ? (for DBA

Description : WHAT IS RMAN ? (for DBA

Last Answer : Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.

What is the basic structure of PL/SQL ?

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

What are the two parts of a procedure ?

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

What are the datatypes a available in PL/SQL ?

Description : What are the datatypes a available in PL/SQL ?

Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.