Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DBMS > SQL - RDBMS Databases > Flashcards

SQL - RDBMS Databases Flashcards

1
Q

Identification

is an open source SQL database

A

MySQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Identification

MySQL was developed by a Swedish company called

A

MySQL AB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

MySQL History

Development of MySQL began in

A

1994

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

MySQL History

MySQL was developed by

A

Michael Widenius & David Axmark

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

MySQL History

First internal release on

A

23rd May 1995.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

MySQL History

Windows Version was released on

A

8th January 1998 for Windows 95 and NT.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

MySQL History

Sun Microsystems acquired MySQL AB on

A

26th February 2008.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

MySQL History

Version 5.1: production release

A

27th November 2008.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Identification

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

A

ORACLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Identification

Oracle is a relational
database management system developed by

A

‘Oracle Corporation’.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Oracle History

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

A

1977

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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).

A

1979

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Oracle History

RSI started developing tools for Oracle.

A

1981

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Oracle History

RSI was renamed to Oracle Corporation.

A

1982

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Oracle History

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

A

1983

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Oracle History

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

A

1984 - 1985

17
Q

Oracle History

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

A

2007

18
Q

Identification

is an entry-level
database management software by Microsoft

A

MS Access

19
Q

Identification

MS Access uses the __ database engine

A

Jet Database Engine

20
Q

Ms Access History

Access version 1.0 was released.

A

1992

21
Q

Ms Access History

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

A

1993

22
Q

Ms Access History

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

A

Access 2007

23
Q

Identification

is a Relational Database Management System developed by Microsoft Inc.

A

MS SQL Server

24
Q

Identification

The primary query languages are of MS SQL Server are:

A
  • T-SQL
  • ANSI SQL

DBMS (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions