Oracle Interview Questions and Answers What are the components of physical database structure of Oracle database? Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files. What are the components of logical database structure of Oracle database? There are tablespaces and database’s schema objects. What is a tablespace? A database is divided into Logical Storage Unit called tablespaces. A tablespace [...]

Oracle Interview Questions and Answers What is the advantage of a stored procedure over a database trigger ? We have control over the firing of a stored procedure but we have no control over the firing of a trigger. What is the maximum no. of statements that can be specified in a trigger statement ? One. Can views be specified in a trigger statement ? No What are the values of :new and ld in [...]