Oracle Interview Questions
Questions Answers Views Company eMail

How to create tables for odbc connection testing?

492

What is a named program unit?

580

How to open a cursor variable?

609

What happens to indexes if you drop a table?

698

How to test null values?

678

How to define a data source name (dsn) in odbc manager?

527

How to do a full database export?

637

How to bring a tablespace online?

518

Can group functions be mixed with non-group selection fields?

534

What is the relation of a user account and a schema?

614

How many file formats are supported to export data?

659

Why cursor variables are easier to use than cursors?

570

How to insert a record into a table?

640

How to define a variable to match a table column data type?

580

How to invoke the original export import utilities?

505


Un-Answered Questions { Oracle }

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1619


What is meant by joins? List out the types of joins.

526


Discuss row chaining, how does it happen? How can you reduce it?

290


Is oracle the best database?

521


What do you understand by the term 'normalization'?

286






nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1743


What is the disk migration? what is the steps involved in oracle disk migration?

719


What is ole automation?

1


What is a cursor and what are the steps need to be taken?

601


How to count groups returned with the group by clause in oracle?

574


What are a collation and state the different types of collation sensitivity?

549


Explain what does a control file contain?

607


How to use fetch statement in a loop?

553


Explain an exception and its types?

611


How many databases should a dba manage?

297