problem1) Answer all the problems.
(i) What do you understand by system global area?
(ii) describe SQL and SQL plus.
(iii) Describe the use of DROP and Alter Table Command.
(iv) describe difference between UNION & UNION ALL commands.
(v) Distinguish between implicit and explicit cursor.
problem2) describe RDBMS. Describe the features and components of RDBMS.
problem3) Describe the oracle architecture. describe different oracle files.
problem4) What is the requirement of user account in oracle? Describe the syntax of creating the user account in detail.
problem5) Answer all the problems.
(i) What do you understand by data integrity?
(ii) prepare the syntax of ‘ORDER BY’ clause used in ‘SELECT’ statement.
(iii) Distinguish between GRANT and REVOKE command.
(iv) What do you understand by composite unique index?
(v) What scalar function?
problem6) Describe the use of following SQL * PLUS command-
(a) Accept
(b) Copy
(c) Describe
(d) Edit
(e) Run
(f) Undefine
problem7) What do you understand by object privilege? Describe all kinds object privilege that could be granted to the user with ‘grant’ command.
problem8) prepare brief notes on-
(i) PL/SQL character set
(ii) PL/SQL commands