Database-Oracle [3i Infotech Placement]: Sample Questions 83 - 84 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 83

Oracle
Edit

Describe in Detail

Essay▾

Difference between “ORACLE” and “MICROSOFT ACCESS” databases.

Explanation

Difference between Oracle and Microsoft Access
NameMicrosoft AccessOracle
DescriptionMicrosoft Access combines a backend RDBMS (JET/ACE Engine) with a GUI frontend for data manipulation and queriesWidely used RDBMS
Primary database modelRelational DBMSRelational DBMS
DeveloperMicrosoftOracle
Initial release19921980
Current release2016 (16.0. 4229.1024) , September 201512 Release 2 (12.2. 0.1) , March 2017
Cloud-basednono
Implementation languageC ++C and C ++
APIs and other access methodsDAO

OLE DB

ADO. NET

ODBC

ODP. NET

Oracle Call Interface (OCI)

JDBC

ODBC

Supported programming languagesC

C#

C ++

Delphi

Java (JDBC-ODBC)

VBA

Visual Basic. NET

C

C#

C ++

Clojure

Cobol

Delphi

Eiffel

Erlang

Fortran

Groovy

Haskell

Java

JavaScript

Lisp

Objective C

OCaml

Perl

PHP

Python

R

Ruby

Scala

Tcl

Visual Basic

Partitioning methodsnonehorizontal partitioning
Replication methodsnoneMaster-master replication

Master-slave replication

Question 84

Oracle

Question

MCQ▾

SNAPSHOT is used for … .

Choices

Choice (4)

a.

System server

b.

Synonym

c.

Table space

d.

Dynamic data

Answer

d.

Explanation

  • Snapshot is used for dynamic data.
  • Staged copy of the data in a data store used in one or more processes.
  • The storage statement is mostly used to speedily create point-in-time of data- valid “backup solution” .

Use of Snapshots

  • Easy network loads:
    • To reduce network load- use snapshots to distribute corporate data.
    • Efficient batch process from a single master site.
  • Mass deployment:
    • Temples to quickly and easily use snapshot environments to support mass deployment.
  • Disconnecting computing:
    • One of the solutions for sales applications running on a laptop.
    • A developer can integrate the duplicate management API for refresh on-demand into the sales application.

Developed by: