Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to resolve name conflicts between variables and columns?

1031

What happens to the current transaction if the session is ended?

1098

How to rename an index?

1071

What is the scope of a local variable?

1067

What privilege is needed for a user to query tables in another schema?

973

How to initialize variables with default values?

1243

How to define a variable of a specific record type?

1078

What is an external table?

1020

What are named parameters?

1090

How to connect to a remote server?

1124

What are the predefined tablespaces in a database?

1081

What happens if you use a wrong connect identifier?

1065

How to login to the server without an instance?

1162

How to manage transaction isolation level?

1006

How to export several tables together?

1049

Un-Answered Questions { Oracle }

How many types of canvases are there.

What are the varoius components of physical database structure of oracle database?

1006

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2008

List out the components of logical database structure of oracle database.

1035

What is an anonymous block?

1249

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

593

What is dba in sound level?

583

What is a dynamic performance view in oracle?

991

What is oracle log switch?

619

What is data type in oracle?

1125

How would you determine who has added a row to a table?

2316

What is variable? What is Flow of variable?

620

Why do we use bulk collect in oracle?

1058

Are database administrators in demand?

565

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

For More Un-Answered { Oracle } Questions Click Here