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

Oracle General Interview Questions

Questions Answers Views Company eMail

definition of cluster and non-clustered index?

CSS,

3098

how to get the index id?

Cognizant, TCS,

1 5700

Difference between join and a subquery?

Base Automation, NMDC,

8 45341

How to find no of saturdays in a month using single sql ?

2 5775

How to create index-by table in oracle?

3 6695

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

2007

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

TCS,

2140

What is Water Mark in Oracle?

Oracle,

7 23058

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 5383

How to call a stored procedure inside a trigger? Give an example.

Exilant,

1 11935

How to call a trigger inside a stored procedure?Give an example.

2 9014

Can we call a trigger inside a function and function inside a trigger? Give example.

Metric Stream,

1 14601

can we insert any row to dual table if i got the permission from DBA

HCL, Tesco,

5 17450

how to find the second highest salary in a given table????

5 8872

what is data abstraction

Semantic Space,

3 7224

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is materialized view in Oracle?

1112

Explain the use of online redo log files in oracle.

1077

What is a database schema in oracle?

1147

What privilege is needed for a user to create indexes in oracle?

1078

What is an Oracle index?

1698

What is the use of file param in imp command?

1213

What are the differences between char and varchar2 in oracle?

1245

How will you write a query to get a 5th rank student from a table student_report?

1918

How to Truncate Table in Oracle

1210

Use of an integrity constraint is better to validate data. Explain

1086

Explain user account with reference to oracle.

1028

What is oracle in java?

1014

What is a procedure in oracle?

1279

How to use subqueries in the from clause in oracle?

1165

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422

For More Un-Answered { Oracle General } Questions Click Here