Oracle Interview Questions and Answers. Frequently Asked Oracle Job Interview Questions with Answers for freshers & experienced. Oracle Database Important Interview Questions.
Are you preparing for a job interview based on the Oracle, here we are providing some Commonly Asked Oracle Interview Questions with Answers.
Oracle Interview Questions for Freshers
1. What is oracle database ?
Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database had physical and logical structures. Logical structures and physical structures are separated from each other.
2. What is a Control File ?
Control file is a binary file which stores Database name, associated data files, redo files, DB creation time and current log sequence number. Without control file database cannot be started and can hamper data recovery.
3. What is a table Cluster ?
Table Cluster is a group of related tables that share common columns are store related data in the same block.
4. What is RAW datatype?
RAW datatype is used to store values in binary data format. The maximum size for a raw in a table in 32767 bytes.
5. What is BLOB datatype?
A BLOB data type is a varying length binary string which is used to store two gigabytes memory. Length should be specified in Bytes for BLOB.
Oracle Database Important Interview Questions & Answers
6. What is NULL value in oracle?
NULL value represents missing or unknown data. This is used as a place holder or represented it in as default entry to indicate that there is no actual data present.
7. What is VArray?
VArray is an oracle data type used to have columns containing multivalued attributes and it can hold bounded array of values.
8. What is Oracle Table?
A Table is the basic unit of data storage in Oracle Database. The Tables of a database hold all of the user accessible data. Table data is store in rows and columns.
9. What are the different file extensions that are created by Oracle Reports?
Rep file and Rdf file
10. How many memory layers are in the Oracle shared pool?
Library Cache and Data Dictionary Cache