1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

definition of cluster and non-clustered index?

CSS,

2464

how to get the index id?

Cognizant, TCS,

1 4871

Difference between join and a subquery?

Base Automation, NMDC,

8 42369

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

 2 4731

How to create index-by table in oracle?

 3 5232

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

 1572

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,

1596

What is Water Mark in Oracle?

Oracle,

7 20618

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 3977

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

Exilant,

1 10816

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

 2 8001

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

Metric Stream,

1 13633

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

HCL, Tesco,

5 15447

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

 5 6961

what is data abstraction

Semantic Space,

3 5746

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is partitioned table in Oracle?

620

What are a cluster and non-cluster index?

565

what is the difference between functional dependecy and multilevel dependency?

1978

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1728

What do database buffers contain?

555




Will you be able to store pictures in the database?

623

What the is the diff between local index and global index. give some example.

1119

How many anonymous blocks can be defined?

573

What is an oracle wallet?

502

How to define an anonymous procedure with variables?

533

What is set verify off in oracle?

561

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2161

Explain the use of Merge statement in oracle 11g

580

Explain an exception and its types?

595

What do you mean by group by clause?

541

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