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


Oracle Interview Questions
Questions Answers Views Company eMail

How to resolve name conflicts between variables and columns?

 573

What happens to the current transaction if the session is ended?

 527

How to rename an index?

 588

What is the scope of a local variable?

 585

What privilege is needed for a user to query tables in another schema?

 509

How to initialize variables with default values?

 636

How to define a variable of a specific record type?

 614

What is an external table?

 588

What are named parameters?

 616

How to connect to a remote server?

 562

What are the predefined tablespaces in a database?

 556

What happens if you use a wrong connect identifier?

 504

How to login to the server without an instance?

 622

How to manage transaction isolation level?

 564

How to export several tables together?

 568

Un-Answered Questions { Oracle }

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1567

What is the sequence of firing in report trigger?

1

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1695

What is concurrency in oracle?

547

What is the difference between restoring a database and recovering a database?

1




What is a server parameter file in oracle?

594

What is the difference between translate and replace?

560

How to create a new table in oracle?

591

What do you understand by a database object?

588

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

349

How do you generate file output from sql?

264

What is the implicit cursor in oracle?

570

Explain coalesce function?

627

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

289

Explain master-detail relationship with some examples.

583

For More Un-Answered { Oracle } Questions Click Here