CS 303

Question 1

Dynamic storage

Answer 1

dynamic storage (like RAM) requires power to maintain its information

Question 2

____________ doesn’t require power, by maintaining the contents even while turned off.

Answer 2

static storage

Question 3

Magnetic storage

Answer 3

uses magnetism and metal pieces embedded in a plastic film to encode information

Question 4

uses lasers and bumps on a plastic disk

Answer 4

optical storage

Question 5

exclusively uses electronics, particularly flash memory

Answer 5

flash storage

Question 6

remote storage

Answer 6

cloud storage

Question 7

encodes information by punching holes in paper cards

Answer 7

paper storage

Question 8

Three factors of storage:

Answer 8

speed, cost, evolution

Question 9

a column in a database

Answer 9

tuple

Question 10

functional dependencies

Answer 10

the relationship between a database attribute and another

Question 11

a _______ of a relation determine that no two tuples have the same attributes across the data set

Answer 11

key

Question 12

The term ___________ refers to the reduction of a complex structure to a simpler, more straightforward one.

Answer 12

decompose

Question 13

Each tuple is reliant only on a ______________

Answer 13

primary key

Question 14

How many child records or tables can a parent table have?

Answer 14

unlimited

Question 15

How many parent tables can a child record or table have?

Answer 15

1

Question 16

Ultimately, what is at the ‘top’ of a hierarchical database?

Answer 16

a single parent table

Question 17

What rough shape does a hierarchical database take?

Answer 17

a pyramid

Question 18

The type of database that stores journals and magazine articles is called a _____.

Answer 18

library database

Question 19

What is the main difference between a database and a database application?

Answer 19

The database contains the collection of information and data, while the database application is the software used to organize this data.

Question 20

_____________________ allows for jobs to be run with minimal to no human intervention following preset schedules and priorities, as long as the information needed to execute the job is present.

Answer 20

Batch processing

Question 21

Which of the following is a good example of batch processing?

Answer 21

Printing out paychecks

Question 22

The property that determines if a batch job is executed faster or slower than others is referred to as its …

Answer 22

priority

Question 23

Jobs that run in a batch processing environment…

Answer 23

… can be executed at any point, and may use different priority settings to manage their impact on other jobs and users.

Question 24

FIFO stands for _____.

Answer 24

first in, first out

Question 25

In a batch processing model, the executing jobs that are being processed by the computer are often said to be running...

Answer 25

in the background

Question 26

What is the main distinguishing feature of a batch processing system?

Answer 26

It accumulates one or more transactions over a period of time before processing them at a later scheduled time.

Question 27

only the whole transaction should be saved/processed

Answer 27

atomicity

Question 28

the data going out must remain the same when it is saved

Answer 28

consistent

Question 29

separate from other transactions

Answer 29

isolated

Question 30

the data must survive a system failure

Answer 30

durable

Question 31

When considering the ACID principles, which of the following best support each other directly?

Answer 31

Durable, atomic

Question 32

These are the most common operations in a database application transaction.

Answer 32

read, write

Question 33

While a transaction was processing, an update to the servers caused a reset. However, the transaction was still committed. What best describes the component of ACID in this scenario?

Answer 33

Durable

Question 34

As a transaction is being performed, only part of it can be processed. Instead of saving only part of the data, the transaction is rolled back. What best describes the nature of the transaction?

Answer 34

atomic

Question 35

Consider a database application that updates stock prices. It has been written so that the stock price of a given stock is updated only if an unrelated stock is also changed. What component of ACID does this violate?

Answer 35

isolation

Question 36

The .NET framework consists mostly of what?

Answer 36

Classes (objects)

Question 37

.NET is meant to save a developer _____ on the mundane things.

Answer 37

Time and energy

Question 38

Why is it important to carefully select a database software?

Answer 38

To ensure that requirements of an organization are fulfilled

Question 39

Which one of the following database software options uses an object-relational model?

Answer 39

Oracle

Question 40

Why is .NET framework so important to Microsoft SQL Server 2017 installation?

Answer 40

software interoperability

Question 41

What is the minimum operating system requirement for installing Microsoft SQL Server 2017 Developer edition?

Answer 41

Windows 8 Enterprise

Question 42

What type of hard disk formatting is recommended for Microsoft SQL Server 2017 installation?

Answer 42

NTFS or ReFS

Question 43

What is the required speed of processor for installing Microsoft SQL Server 2017?

Answer 43

1.4 GHz

Question 44

On the license review screen of the Microsoft SQL Server 2017 installation wizard, which of these needs to be checked to proceed?

Answer 44

I accept the license terms

Question 45

We use the keyword '_____' to signify that there is more than one instruction in the trigger to be executed.

Answer 45

atomic

Question 46

A trigger is a set of instructions that are _____ by some specific event.

Answer 46

fired

Question 47

Triggers can be set to fire _____, _____, or _____ any of these commands.

Answer 47

before, after, instead of

Question 48

Triggers can help us maintain data _____ and _____ across the database by ensuring that the same data is entered, deleted, or updated in all related areas.

Answer 48

consistency, integrity

Question 49

Database triggers are most commonly applied to _____.

Answer 49

tables

Question 50

Uses for an SQL trigger

Answer 50

deriving information referential integrity event logging auditing replication security error handling

Question 51

Which SQL trigger use involves comparing recorded information with expected patterns?

Answer 51

auditing

Question 52

An SQL trigger provides the ability to _____ and _____ to an external event.

Answer 52

recognize and react

Question 53

SQL was released by _____ and created by _____.

Answer 53

Oracle, IBM

Question 54

An employee accessing a payroll database to find out how much others are paid would be an example of a violation of the principle of _____________.

Answer 54

confidentiality

Question 55

What is the main idea behind the principle of availability in information security?

Answer 55

People who are authorized to view data can do so when they need access

Question 56

_____ refers to the process of making sure only those who are entitled to information can access it?

Answer 56

information security

Question 57

The _____ ensures that people only have access to the information they need to do their jobs.

Answer 57

principle of least privilege

Question 58

CIA triads of data

Answer 58

confidentiality, integrity, availability

Question 59

How can data integrity be achieved?

Answer 59

encryption

Question 60

Ensuring data recoverability is done using?

Answer 60

backup and restore operations

Question 61

Why is database reliability important to organizations?

Answer 61

Ensures accuracy of business information

Question 62

Which one of the following is a component of data reliability?

Answer 62

integrity

Question 63

What term best describes the 'engine' behind AI tools like ChatGPT?

Answer 63

natural language processing

Question 64

After using an AI tool to generate a SQL statement for your project, what is your next step?

Answer 64

validate the statements

Question 65

By taking on tedious tasks, AI is a great fit for _____ to generate quick results

Answer 65

automation

Question 66

What is the ''notification'' practice in data warehouse administration?

Answer 66

When the raw data is not correctly supplied, the administrator is notified.

Question 67

What happens during data quality processes monitoring?

Answer 67

The administrator is notified about the correct and complete supply of data to the data warehouse.

Question 68

What specific goals is the security manager concerned with?

Answer 68

Authorization and authentication

Question 69

What does data warehouse administration resemble in many ways?

Answer 69

Database administration