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