Oracle General Interview Questions
Questions Answers Views Company eMail

How to do a full database export?

627

How to bring a tablespace online?

509

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

522

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

600

How many file formats are supported to export data?

646

Why cursor variables are easier to use than cursors?

562

How to insert a record into a table?

628

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

572

How to invoke the original export import utilities?

496

What is the difference between formal parameters and actual parameters?

535

How to view the dropped tables in your recycle bin?

1 844

How to define an anonymous procedure without variables?

541

How many data types are supported?

609

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

552

How to define default values for formal parameters?

584


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to convert a date to char in oracle? Give one example.

580


Is oracle a language?

512


Explain the use of compress option in exp command.

540


How to list all user accounts in oracle?

603


How to invoke the original export import utilities?

496






What happens if the imported table already exists?

539


Will you be able to store pictures in the database?

629


What do you mean by merge in oracle and how can we merge two tables?

568


Explain the use of tables option in exp command.

585


Explain the use of file option in exp command.

591


Explain cascading triggers.

567


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1609


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

4657


Explain oracle data types with examples?

566


How do we get field details of a table?

538