Oracle Interview Questions



Page 1 of 1312345»...Last »

Can one rename a database user (schema)? (for DBA)

View the Answer

How are extents allocated to a segment? (for DBA)

View the Answer

What does COMMIT do ?

View the Answer

What is COST-based approach to optimization ?

View the Answer

Where can one find the high water mark for a table? (for DBA)

View the Answer

How does one prevent tablespace fragmentation? (for DBA)

View the Answer

How does one coalesce free space ? (for DBA)

View the Answer

What does ROLLBACK do ?

View the Answer

What database block size should I use? (for DBA)

View the Answer

How does one create a new database? (for DBA)

View the Answer

What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

View the Answer

What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

View the Answer

When does a Transaction end ?

View the Answer

What is Index Cluster ?

View the Answer

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

View the Answer

Page 1 of 1312345»...Last »