3i Infotech Papers: Sample Questions 505 - 506 of 1245

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question number: 505

» Database » Oracle

Essay Question▾

Describe in Detail

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

Explanation

Difference between oracle and microsoft access

Difference between oracle and microsoft access

Name

Microsoft Access

Oracle

Description

Microsoft Access combines a backend RDBMS (JET/ACE Engine) with a GUI frontend for data manipulation and queries

Widely used RDBMS

Primary database model

Relational DBMS

Relational DBMS

Developer

Microsoft

Oracle

Initial release

1992

1980

Current release

2016 (16.0. 4229.1024), September 2015

12 Release 2 (12.2. 0.1), March 2017

Cloud-based

no

no

Implementation language

C++

C and C++

APIs and other access methods

DAO

OLE DB

ADO. NET

ODBC

ODP. NET

Oracle Call Interface (OCI)

JDBC

ODBC

Supported programming languages

C

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 methods

none

horizontal partitioning

Replication methods

none

Master-master replication

Master-slave replication

Question number: 506

» Database » MySQL

Essay Question▾

Describe in Detail

What is BCNF (Boyce-Codd Normal Form)?

Explanation

Boyce Codd Normal Form(BCNF)

Boyce Codd Normal Form (BCNF)

Boyce Codd Normal Form (BCNF)

  • A relational schema R is considered to be in Boyce–Codd normal form (BCNF) if, for every one of its dependencies X → Y, one of the following conditions holds true:

    • X → Y is a trivial functional dependency (i. e. , Y is a subset of X)

    • X is a superkey for schema R

  • Informally the Boyce-Codd normal form is expressed as “Each attribute must represent a fact about the key, the whole key, and nothing but the key. “