9. Using Databases Flashcards

1
Q

What kind of system is Microsoft Excel?

A

Flat file system

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

One way databases differ from flat file systems?

A

Databases support concurrent users without locking the database.

Flat file systems may support concurrent users, but it usually becomes locked to other users or restricted to read-only

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

Meaning of RDBMS?

A

Relational Database Management System

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

Describe relational databases (RDBMS)

A

Data is structured in tables, each defined by fields corresponding to its columns.

RDBMS typically use SQL to maintain data in databases

i.e. Microsoft SQL Server, Oracle Database, MySQL, Microsoft Office Access

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

What are database interfaces?

A

Processes used to manage databases

add/update & extract data

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

What’s used in RDBMS to create/update databases?

A

SQL relational methods

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

Data Definition Methods

What are DDL commands?

Data Definition Language

A

SQL commands altering the database’ structure

i.e. CREATE - adds databases or tables with specified primary & foreign keys

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

Data Manipulation Methods

Purpose of DML commands?

Data Manipulation Language

A

Insert/update records & extract data for viewing

A query

i.e. INSERT INTO TableName - adds a new row in a table in the database

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

Purpose of database access methods?

A

To run SQL commands or use graphical tools for data tasks

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

App architecture models

When is an app considered one-tier or standalone?

A

Front-end, processing logic, & database engine are hosted on same client

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

When is an app considered two-tier?

A

Front end & processing logic is hosted on client; Database engine is hosted on server

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

When is an app considered three-tier?

A

Front-end, processing logice, & database engine are hosted on separate systems

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

What does programmatic access mean?

A

Allowing apps to interact with systems via APIs

allows apps to interact with databases using SQL commands or stored procedures

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

An INSERT statement is an example of what data language type?

A

Data Manipulation Language

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