The following command has been successfully executed:
Create Sequence EmpSeq;
The following block of PL/SQL code is executed:
How many of the following statements are false:
The anonymous block increments the sequence
The anonymous block retrieves the next value from the sequence
The anonymous block resets the sequence
The anonymous block will not output anything
The actual syntax of sequence is
Create Sequence seqname followed by startswith and endswith
The above sequence doesn't contain any initiated value. So the default value will be allocated.
So while incrementing it increases to the value.
As it was increasing the seq value, next value can be also retrieved.
For resetting sequence either you should drop and recreate it or use alter statement.
Yes as there is value for sequence it print something.
So only a, b are true. Rest all are false(c, d)
Get Answers For Free
Most questions answered within 1 hours.