Database hosting

Question 1

Database hosting

Answer 1

Selects the machine where the database software executes.

Question 2

Choices

Answer 2

Local machine (localhost)
On-premise physical or virtual machine(cosc304.ok.ubc.ca)
Cloud-based hosting(physical/virtual/container) as a service on platforms such as Amazon, Google

Question 3

Microsoft excel

Answer 3

Used to store data without using a database. Excel allows importing and exporting data with databases

Question 4

OLTP

Answer 4

Databases designed to handle many small queries and updates are referred to as Online transaction processing (OLTP) systems

Question 5

OLAP

Answer 5

Online analytical systems are designed for decision support application where large amounts of data is analyzed often with ad hoc queries

Question 6

features of OLTP

Answer 6

For transaction data
data is dynamic
common transaction
transaction driven
large number of usersf