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 5113

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

 1612

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

 1 2136

Whats the benefit of dbms_stats over analyze?

 1487

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

 1574

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?

 1449

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 2505

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

Wipro,

1 4895

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,

1843

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

 1367

where the dff data will be stored

Infosys,

1795

key flexfield structure

Infosys,

1595

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,

7434

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

 1433

How to retrieve first and last records from a table?

DELL, QSmart,

7 9355

Un-Answered Questions { Oracle }

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

609

what are savepoint mode and cursor mode properties ?

1

What is a scenario in odi?

283

How to execute a stored procedure in oracle?

612

What is system tablespace?

621




What do you understand by the term 'normalization'? Explain the various modes of normalization?

257

How to select some columns from a table in oracle?

543

How can you determine the space left in a file system?

343

How to generate query output in html format?

558

How to convert character types to numeric types?

566

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1468

Difference between negative and positive adjustments : oracle accounts receivable

615

How to insert a record into a table?

628

Why we use bulk collect in oracle?

526

How do we represent comments in oracle?

619

For More Un-Answered { Oracle } Questions Click Here