Oracle Interview Questions
Questions Answers Views Company eMail

What is tns service name?

622

What is a tns file?

500

What is a tns service name?

536

What is sharded cluster?

519

What is a cognitive schema?

527

What is columnar storage what is the advantage?

544

What is object data modeling?

507

What is query image?

584

What is rich query?

540

What is the difference between sharding and partitioning?

502

What is the difference between sharding and replication?

476

What does sharding mean?

539

What is connection pool in oracle?

556

What is connection pooling in oracle?

552

What is dual table oracle?

527


Un-Answered Questions { Oracle }

How to export your connection information to a file?

595


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1805


What is query image?

584


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1647


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1611






What is parameterized cursor in oracle?

577


How to create a table index?

567


What is the difference between sga and pga?

315


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

1738


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1858


How to convert dates to characters in oracle?

582


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1550


what is the difference between restoring and recovering?

556


Explain the use of full option in exp command.

587


Can we write dml statement in function in oracle?

634