Oracle General Interview Questions
Questions Answers Views Company eMail

How to do a full database export?

637

How to bring a tablespace online?

520

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

536

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

615

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?

642

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

580

How to invoke the original export import utilities?

507

What is the difference between formal parameters and actual parameters?

547

How to view the dropped tables in your recycle bin?

1 866

How to define an anonymous procedure without variables?

551

How many data types are supported?

621

How to connect to the server with user account: sys?

566

How to define default values for formal parameters?

596


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the differences between date and timestamp in oracle?

554


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1448


Please explain oracle data types with examples?

590


Please explain drop constraint oracle?

629


Why is oracle database so popular?

566






What is a sub query? What are its various types?

585


What is the simplest tool to run commands on oracle servers?

520


Give syntax for SQL and ORACLE joins.

634


How to define a sub function?

666


How to export data to a csv file?

627


How to convert dates to characters in oracle?

584


How to do a full database export?

637


Explain database link?

666


Is it possible to insert comments into sql statements return in the data model editor ?

2069


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1558