Question

The following command has been successfully executed:

Create Sequence EmpSeq;

The following block of PL/SQL code is executed:

Begin
    dbms_output.put_line(EmpSeq.NextVal);
End;

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

Answer 1

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)