logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology See What Others Are Saying!
  • Question
  • Oracle Server supports two different forms of replication: Basic and Advanced replication. Explain difference between these.


  • Correct Answer
  • Basic Replication : Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements It can only replicate data and not procedures, indexes replication is always one-way, and snapshot copies are read only Advanced Replication : Advanced replication supports various configurations of updatable snapshot, multi-master and update anywhere replication It is more difficult to configure but allows data and other database objects like indexes and procedures to be replicated Differences between Basic and Advanced replications: - With basic replication, data replicas provide read-only access to the table data whereas advanced replication features extend the capabilities of basic read-only replication by allowing applications to update table replicas throughout a replicated database system - With Basic Replication applications can query data from local data replicas On the other hand with advanced replication, data replicas anywhere in the system can provide both read and update access to a table's data 


  • More questions

    • 1. How would you automatically transfer your visitors to a new web page?
    • Discuss
    • 2. The threshold limit upto which coins can be issued as per the Coinage Act 2011 ?

    • Options
    • A. 100
    • B. 200
    • C. 500
    • D. 1000
    • Discuss
    • 3. Cash Reserve Ratio ( CRR) and Stautory Liquidity Ratio (SLR ) are terms most closely related to which of the following industries/markets :

    • Options
    • A. Mutual Fund
    • B. Income Tax
    • C. Stock Exchange
    • D. Banking
    • Discuss
    • 4. What is the minimum period of time for which one can open an FD(Fixed Deposit) account ?

    • Options
    • A. 15 days
    • B. 6 months
    • C. 7 days
    • D. 1 year
    • Discuss
    • 5. Which Bank has been given scheduled bank status by RBI ?

    • Options
    • A. Disha
    • B. Suryoday
    • C. Janalakshmi
    • D. Ujjivan
    • Discuss
    • 6. Which class is used to indicate Black Navigation Bar ?

    • Options
    • A. .navbar-inverse
    • B. .navbar-black
    • C. .navbar-dark
    • D. .navbar-default
    • Discuss
    • 7. The journal entry to record a credit sale is

    • Options
    • A. Accounts Receivable
    • B. Accounts Payable
    • C. Both A & B
    • D. None of the above
    • Discuss
    • 8. What is CRR rate?
    • Discuss
    • 9. Which among the following are not access Specifiers in C++?

    • Options
    • A. Public
    • B. Protected
    • C. Default
    • D. Private
    • Discuss
    • 10. In which year, the first bank of India "Bank of Hindustan" was established ?

    • Options
    • A. 1677
    • B. 1770
    • C. 1796
    • D. 1831
    • Discuss


    Comments

    There are no comments.

Enter a new Comment