Oracle Interview Questions
Questions Answers Views Company eMail

How to create tables for odbc connection testing?

588

What is a named program unit?

686

How to open a cursor variable?

688

What happens to indexes if you drop a table?

807

How to test null values?

766

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

607

How to do a full database export?

730

How to bring a tablespace online?

616

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

637

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

708

How many file formats are supported to export data?

744

Why cursor variables are easier to use than cursors?

661

How to insert a record into a table?

747

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

660

How to invoke the original export import utilities?

587


Un-Answered Questions { Oracle }

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

355


What is the easiest method to create a file on unix?

336


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1788


Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

431


Explain an exception?

638






How to create a new oracle data file?

646


Difference between Row Id and Row Num?

442


Hi Can any one tell me what are the API's used in requisition import.

1590


Can a View based on another View in Oracle?

730


How to define a record variable to store a table row?

651


Explain a data segment?

751


How to change user password in oracle?

700


Explain self joins in oracle?

658


You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

334


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1953