1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

Explain the concept of the DUAL table.

 2 5132

What are the ways tablespaces can be managed and how do they differ?

 1614

From the database level, how can you tell under which time zone a database is operating?

 1 2159

Whats the benefit of dbms_stats over analyze?

 1493

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

 1581

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

 1453

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

 1 2509

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

Wipro,

1 4911

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

Cisco,

1844

Respected sir, Please send me technical questions related to oracle apps..

 1377

where the dff data will be stored

Infosys,

1801

key flexfield structure

Infosys,

1599

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

Punjab National Bank,

7439

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

 1440

How to retrieve first and last records from a table?

DELL, QSmart,

7 9410

Un-Answered Questions { Oracle }

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1639

What is the difference between formal parameters and actual parameters?

541

what are knowledge modules?

316

How to define a sub function?

662

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1831




What is oracle datasource?

547

What is a package ? What are the advantages of package ?

599

How to count duplicated values in a column in oracle?

550

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2173

What do you mean by a tablespace?

560

What is ceil and floor in oracle?

571

How to drop an index in oracle?

602

What is an explain plan and how does it help in optimizing the sql query?

1

Explain what are the type of synonyms?

578

What is the maximum number of triggers that can be applied to a single table?

555

For More Un-Answered { Oracle } Questions Click Here