In oracle there is column command, how will you explain that?

1055

does the query needs a hint to access a materialized view?

1857

State the various uses of dbcc command?

1060

Explain temporal data types in oracle

1095

types of indexes and the rationale behind choosing a particular index for a situation.

2510

interview questions with answer for cts

2583

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1949

What are the advantages of oracle 12c?

1180

What is the difference between primary key and unique key and foreign key in oracle?

982

Explain the use of online redo log files in oracle.

1037

What is an oracle and why it is used?

1150

Difference between hot backup vs. Cold backup?

991

Explain oracle instance.

1177

What is program global area (pga) in oracle?

1030

What are the system predefined user roles?

1041