Intro to DBMS Flashcards

1
Q

SQL stands for ________ .

A

Structured Query Language

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

Which of the following is not considered to be a basic element of an enterprise-class database system?

A

COBOL programs

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

An application where only one user accesses the database at the given time is an example of a(n) ______.

A

single-user database application

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

The following are components of a database except ____.

A

reports

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

Helping people keep track of things is the purpose of a(n) _______.

A

database

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

Because it contains a description of its own structure, a database is considered to be ________.

A

self-describing

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

Which of the following products was the first to implement true relational algebra in a PC DBMS?

A

R:base

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

The DBMS that is most difficult to use is ____.

A

Oracle Corporation’s Oracle

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

Which of the following products implemented the CODASYL DBTG model?

A

IDMS

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

What is a network database management system that is accessed by a subschema?

A

IDMS/DB

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

What are the two methods of retrieving records within a subschema from an application program (IDMS)?

A

Network access (DML)** and LRF-based access (LRF)

**traditional

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