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


Oracle Interview Questions
Questions Answers Views Company eMail

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

 534

How do you find current date and time in oracle?

 578

What is a snapshot in oracle database?

 563

How can I combine multiple rows into a comma-delimited list in oracle?

 571

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

 539

How to load excel data sheet to oracle database

 578

What does `(+)` do in a where clause?

 1 752

Is there an oracle sql query that aggregates multiple rows into one row?

 536

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

 530

what is the dual table in oracle?

 543

Is there any function in oracle similar like group_concat of mysql?

 526

What is oracle update statement with inner join ?

 573

How to upsert (update or insert into a table)?

 526

How to convert csv to table in oracle?

 517

What is the string concatenation operator in oracle?

 563

Un-Answered Questions { Oracle }

How to create an initialization parameter file?

531

What should a dba know?

259

How can we identify the resources for which the sessions are waiting?

1

What are the differences between primary key and unique key?

505

What is BBED in Oracle?

675




What are the differences between date and timestamp in oracle?

545

Can the query output be sorted by multiple columns in oracle?

561

What do you understand by a database object? Can you list a few of them?

596

Explain how are indexes update?

613

What are ddl statements in oracle?

580

How to view all columns in an existing table?

540

How to estimate disk space needed for an export job?

550

What is a user role in oracle?

606

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1732

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

556

For More Un-Answered { Oracle } Questions Click Here