Databases

Question 1

What is a database?

Answer 1

An organized storage of data that store tags, program commands, configurations and etc.

Question 2

What can you find in a historical database?

Answer 2

1) Values
2) Timestamp
3) Quality
4) Tag

Question 3

What can you find in an Alarm and Events Database?

Answer 3

1) Tag
2) Alarm state
3) Time
4) Data
5) Recommendation
6) Operator Acknowledge

Question 4

Databases can be ___________ due to a large amount of data.

Answer 4

Compressed

Question 5

What can databases use to prevent entities from changing values, or data in the database?

Answer 5

Encryption

Question 6

What is the major component in the database that holds all data?

Answer 6

A table made of fields and records

Question 7

What is a relational database?

Answer 7

A relational database has linked tables. This can be between customers and orders for example

Question 8

To make databases interact with each other they are _________.

Answer 8

Queried using Structured Query Language (SQL)

Question 9

What is DDE?

Answer 9

Dynamic Data Exchange, a Microsoft Windows mechanism to allow applications
(EXCEL/WORD and others) to talk/send data to each
other.

Question 10

To initiate a DDE conversation what 3 things does a client need to specify?

Answer 10

1) Application: typically this is the application’s executable filename like RSLinx

2) Topic: the subject of the conversation like RealParsExcel

3) Item: an item refers to identify data, for example in Excel these are cell numbers

Question 11

What is used to connect a database to a control system?

Answer 11

A driver:
ODBC-Open Database Connectivity
JDBC-Java Database Connectivity