www.itechowais.tech Aggregate Function and its advantages-   Aggegate function :- In DBMS, Aggregate function is a function where the values of multiple rows are grouped together to form a single summary …

Q) What is sequence ? Write and explain the syntax ‘ CREATE SEQUENCE ’ statements. ANS:   Sequence :-                                     ·       A Sequence is a set of integers (1,2,3…) that is used to generate a number s…

Q) Explain the different parameters of ‘ CREATE SEQUENCE ’ statement. ANS: a)     START WITH – ·        Specifies the first sequence number to be generated. b)     INCREMENT BY – ·        Specifies the interval b/w se…

Q) Write the syntax of ‘ ALTER SEQUENCE ’ statement. ANS:   Alter Sequence :-              The  ALTER SEQUENCE  statement allows to change the Increment, Minimum value, Maximum value, Cached numbers and behaviour of a sequen…

Q) Write the syntax of ‘ DROP SEQUENCE’ statement. ANS:    Drop Sequence :- ·       The DROP SEQUENCE statement allows to remove a sequence from the database.              Syntax-   DROP SEQUENCE se…