1. What are the components of Physical database structure of Oracle Database?
ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files
2. What are the components of Logical database structure of ORACLE database?
Tablespaces and the Database’s Schema Objects.
3. What [...]
Read Full Post »
1. What is PL/SQL ?
Ans. PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching.
2. What is the basic structure of PL/SQL ?
Ans. PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.
3. What are the [...]
Read Full Post »