SQL - RDBMS Databases

Question 1

Identification

is an open source SQL database

Answer 1

MySQL

Question 2

Identification

MySQL was developed by a Swedish company called

Answer 2

MySQL AB

Question 3

MySQL History

Development of MySQL began in

Answer 3

1994

Question 4

MySQL History

MySQL was developed by

Answer 4

Michael Widenius & David Axmark

Question 5

MySQL History

First internal release on

Answer 5

23rd May 1995.

Question 6

MySQL History

Windows Version was released on

Answer 6

8th January 1998 for Windows 95 and NT.

Question 7

MySQL History

Sun Microsystems acquired MySQL AB on

Answer 7

26th February 2008.

Question 8

MySQL History

Version 5.1: production release

Answer 8

27th November 2008.

Question 9

Identification

It is a very large multi-user based database management system.

Answer 9

ORACLE

Question 10

Identification

Oracle is a relational
database management system developed by

Answer 10

‘Oracle Corporation’.

Question 11

Oracle History

Larry Ellison, Bob Miner and Ed Oates founded Software Development Laboratories to undertake development work.

Answer 11

1977

Question 12

Oracle History

Version 2.0 of Oracle was released and it became first commercial relational
database and first SQL database. The company changed its name to Relational
Software Inc. (RSI).

Answer 12

1979

Question 13

Oracle History

RSI started developing tools for Oracle.

Answer 13

1981

Question 14

Oracle History

RSI was renamed to Oracle Corporation.

Answer 14

1982

Question 15

Oracle History

Oracle released version 3.0, rewritten in C language and ran on multiple platforms.

Answer 15

1983

Question 16

Oracle History

Oracle version 4.0 was released. It contained features like concurrency
control - multi-version read consistency, etc.

Answer 16

1984 - 1985

Question 17

Oracle History

Oracle released Oracle11g. The new version focused on better partitioning, easy migration, etc.

Answer 17

2007

Question 18

Identification

is an entry-level
database management software by Microsoft

Answer 18

MS Access

Question 19

Identification

MS Access uses the __ database engine

Answer 19

Jet Database Engine

Question 20

Ms Access History

Access version 1.0 was released.

Answer 20

1992

Question 21

Ms Access History

Access 1.1 released to improve compatibility with inclusion the Access Basic programming language.

Answer 21

1993

Question 22

Ms Access History

a new database format was introduced ACCDB which supports complex data types such as multi valued and attachment fields.

Answer 22

Access 2007

Question 23

Identification

is a Relational Database Management System developed by Microsoft Inc.

Answer 23

MS SQL Server

Question 24

Identification

The primary query languages are of MS SQL Server are:

Answer 24

• T-SQL
• ANSI SQL