Oracle interview questions – page 2

1,328 questions. Tap “Show answer” to check yourself.

Advertisement
  1. How to create DSN..Explain?

  2. Find the Odd Man Out among the following: a) MYSQL b) ORACLE c) POSTGRESQL d) UNIX

  3. In What scenerio intercompany and mass- allocation journal can be used in business?

  4. What is the exact diiference between DBMS and RDBMS

  5. PLS-00222: no function with name 'string' exists in this scope

  6. In which table sub inventory related information for item isstored?

  7. What are centralized and decentralized level of control ofitem attributes?

  8. What is the difference between inventory org id andinventory organisation id

  9. How can i install active directory in windows 2008

  10. Differentiate between intra & inter UOM class conversionwith examples.

  11. How will you get the concurrent program output as email?

  12. In account tableaccount type amountac1 credit 300ac2 debit 5000ac3 credit 3000ac1 debit 4000ac3 debit 2000ac2 credit 4000write a query how to get sum of credit & sum of debit

  13. Advertisement
  14. How to kill session?

  15. What is unit of measure classes? give atleast two examples.name the underlying table.

  16. Can i know what is flow of unipay related to UK legislation?what is meant by unipay here? what is the use of Unipay?where we use this unipay?

  17. What are the prerequisite set ups for inter organizationtransaction?

  18. What is the difference between DBMS and RDBMS??

  19. ORA-26026: unique index string.string initially in unusablestate

  20. What are the receipt types in Po?

  21. Difference between MS Access and Oracle

  22. Is that Possible To create package without Specification , If Yes Give any Examples

  23. ORA-12988: cannot drop column from table owned by SYS

  24. What is a bitmap index?

  25. How to migrate .rdf file from dev instance to test instance?

  26. Advertisement
  27. What are the type of triggers available in Oracle Reports ?

  28. Can a table has a column that has only view data and in other columns we can change data?

  29. After using set unused can we enable the column again to use?Please give me some answers....

  30. Can we create aliases for every table beforehand? if yeswhar are the disadvantages?

  31. ORA-00205: error in identifying controlfile, check alert logfor more info

  32. What is the difference between Recurring Journals andRecurring Invoices? What is the need for the RecurringJournals in GL when Recurring invoices exist in AP?

Advertisement