Information Technology Flashcards Preview

FAR Flashcards > Information Technology > Flashcards

Flashcards in Information Technology Deck (70)
Loading flashcards...
61

What is a Cold Site?

If a main system goes down- a Cold Site will take time to get set up and running.

62

What is the most common database language?

SQL - Structured Query Language

63

What is a Data Definition Language?

Defines SQL Database

Controls SQL Tables

64

What is a Data Manipulation Language?

Queries SQL Database tables

65

What is a Data Control Language?

Controls Access to SQL Database

66

What are the characteristics of a Relational Database?

Logical structure

Uses rows and columns similar to spreadsheet

67

What are the characteristics of a Hierarchical Database?

Has various levels

Uses trees to store data

68

What are the advantages of a database?

Data is more accessible

Reduced redundancy

69

What are the disadvantages of a database?

Cost of installation

Skilled personnel required to maintain

70

What are the components of a database?

Desktop client

Application Server

Database Server

Think: Your desktop computer runs applications and saves to a database