(a) SQL statements can be grouped into 3 areas – DDL, DML and DCL

(a) SQL statements can be grouped into 3 areas – DDL, DML and DCL

Outline the role of DDL statements, DML statements and DCL statements. Give examples of
all statements.

(b) Outline the role of a trigger in maintaining a unique identifier on a table. What are the steps and requirements in implementing such a solution?

(c) Show the code to create a sequence to be used to populate the PROD_ID primary key on the PRODUCT Table.

(d) Show the code to create a trigger to populate the PROD_ID primary key on the PRODUCT table using a sequence.

(e) What is PL/SQL? How can it be used in a database and in application development?

(f) Write an anonymous PL/SQL block to display the following –

(a) SQL statements can be grouped into 3 areas – DDL, DML and DCL. Outline the role of DDL statements, DML statements and DCL statements. Give examples of
all statements.

(b) Outline the role of a trigger in maintaining a unique identifier on a table. What are the steps and requirements in implementing such a solution?

(c) Show the code to create a sequence to be used to populate the PROD_ID primary key on the PRODUCT Table.

(d) Show the code to create a trigger to populate the PROD_ID primary key on the PRODUCT table using a sequence.

(e) What is PL/SQL? How can it be used in a database and in application development?

(f) Write an anonymous PL/SQL block to display the following –

Is this the question you were looking for? If so, place your order here to get started!