Prepare Interview

Exams Attended

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

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:

Related interview subjects

MySQL interview questions and answers - Total 108 questions
DBMS interview questions and answers - Total 73 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
©2023 WithoutBook