Oracle Interview Questions | Technical Interview & Viva Questions : KyaPoocha.com

Oracle Interview Questions

Pages (999999): [1] 2 3 » ... Last »

What is an Oracle view ?

View the Answer

How will you monitor rollback segment status?

View the Answer

What are the different types of Modules available in Oracle?

View the Answer

What is the usage of SAVEPOINTS?

View the Answer

How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

View the Answer

What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?

View the Answer

How will you activate/deactivate integrity constraints?

View the Answer

What is a database link?

View the Answer

How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?

View the Answer

What is CYCLE/NO CYCLE in a Sequence?

View the Answer

If a view on a single base table is manipulated will the changes be reflected on the base table?

View the Answer

Can a view be updated/inserted/deleted? If Yes - under what conditions?

View the Answer

What command would you use to create a backup control file?

View the Answer

Give two examples of referential integrity constraints?

View the Answer

Give the reasoning behind using an index?

View the Answer

Pages (999999): [1] 2 3 » ... Last »