The Highest Post

ORACLE Top questions

New Post


Recent Post

Find by name:

  • DBA
  • First Name
  • PostDate

  • Peter Agyekum I’m a developer. Explain why I need a unique key on my table.

    And really pretend that you’re a developer. If you’re a DBA manager, bring in one of your toughest developers to play bad cop. Challenge them – does it really improve performance or manageability? How do you know? Is it just your opinion, or where’s the proof? If they can explain it in clear, easy-to-comprehend terms, that bodes well for their ability to communicate with other teams. Speaking of inter-team communication…

    Peter Agyekum What is an Oracle Database?

    Oracle provides software to create and manage the Oracle Database. The database consists of physical and logical structures in which system, user, and control information are stored. The software that manages the database is called the Oracle Database server. Collectively, the software that runs Oracle and the physical database is called the Oracle Database system. A database buffer cache stores the data in memory for quicker access. The redo logs track and store all the changes made to the database. A Data Guard ensures data protection and high availability of data, and a control file records the physical structure of the database.

    Peter Agyekum What are the different Oracle Database objects?

    Tables Views Indexes Synonyms Sequences Tablespaces

    Peter Agyekum test

    test

    Peter Agyekum test

    test