Answer the following problems.
problem 1) What do you understand by the term Cursor?
problem 2) CREATE index mylndex ON myThble(myColumn). What type of Index will get created after executing this statement?
problem 3) describe the term Relational Calculus.
problem 4) Distinguish between the SQL and SQL*PLUS.
problem 5) describe the term control structure. Give suitable exs.
problem 6) What do you mean by defaults? Is there a column to which a default cannot be bound?
problem 7) How Candidate key is different from primary key and super key?
problem 8) prepare down the syntax of Table Creation and Deletion commands.
problem 9) Given an employee table, prepare a SQL query to determine the average salary?
problem 10) What do you understand by view? How it is created in PL SQL?