Oracle Interview Questions and Answers
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?
Related differences
Related interview subjects
| MySQL interview questions and answers - Total 108 questions |
| DBMS interview questions and answers - Total 73 questions |
| SQLite interview questions and answers - Total 10 questions |
| MSSQL interview questions and answers - Total 50 questions |
| Oracle interview questions and answers - Total 34 questions |
| Redis Cache interview questions and answers - Total 20 questions |
| SQL interview questions and answers - Total 152 questions |