Oracle General Interview Questions
Questions Answers Views Company eMail

How to shutdown your 10g xe server from command line?

788

How to export your connection information to a file?

834

How to shutdown your 10g xe server?

847

How a tablespace is related to data files?

831

Where is the export dump file located?

814

What are the original export and import utilities?

787

What is a connect identifier?

792

How to view all columns in an existing table?

733

What is an anonymous block?

921

How many anonymous blocks can be defined?

827

How to load data through external tables?

882

How to create a table index?

810

How to assign data of the deleted row to variables?

833

How to work with data objects interactively?

746

How to add a new column to an existing table with a default value?

796


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why does oracle 9i treat an empty string as null?

758


How to import one table back from a dump file?

812


What are data pump export and import modes?

837


What is an Oracle Instance?

900


How to convert numbers to characters in oracle?

803


1) Does oracle have any table which contain all the exceptions and it's code internally?

1522


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1678


How do I limit the number of rows returned by an oracle query after ordering?

902


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1710


What do you mean by cdb and pdb in oracle 12c?

846


Explain what are the characteristics of data files?

833


Give the different types of rollback segments.

814


What is the difference between a hot backup and a cold backup in oracle?

790


What is a select query statement in oracle?

730


What is set operator oracle?

736