Oracle Interview Questions and Answers
The Best LIVE Mock Interview - You should go through before Interview
Intermediate / 1 to 5 years experienced level questions & answers
Ques 1. What is the use of Control File?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
Is it helpful?
Add Comment
View Comments
Ques 2. What is an Oracle sequence?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
Is it helpful?
Add Comment
View Comments
Ques 3. What are synonyms used for?
- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users:
- What are the components of physical database structure of Oracle database?
- What are the components of logical database structure of Oracle database?
- What is a tablespace?
- What is SYSTEM tablespace and when is it created?
- Explain the relationship among database, tablespace and data file?