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,

3028

how to get the index id?

Cognizant, TCS,

1 5644

Difference between join and a subquery?

Base Automation, NMDC,

8 45086

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

2 5699

How to create index-by table in oracle?

3 6570

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

1970

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,

2087

What is Water Mark in Oracle?

Oracle,

7 22795

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 5234

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

Exilant,

1 11858

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

2 8944

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

Metric Stream,

1 14508

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

HCL, Tesco,

5 17265

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

5 8693

what is data abstraction

Semantic Space,

3 7075

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between translate and replace in oracle?

1163

How can we force the database to use the user specified rollback segment?

1148

How to rename an existing table?

1123

How to delete multiple rows from a table in oracle?

1060

Explain temporal data types in oracle

1093

How do we create privileges in oracle?

1045

How to start a specific oracle instance?

1035

Explain integrity constraint?

1159

What is archive log in Oracle?

1131

How to view the tablespaces in the current database?

973

How do I find my oracle client driver version?

1038

Explain the difference between replace() and translate() functions in oracle?

1036

How to shutdown your 10g xe server from command line?

1084

How to rename an index in oracle?

1113

how to make an oracle object

2354

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