Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CS 204 Database Programming > CS 303 > Flashcards

CS 303 Flashcards

1
Q

Dynamic storage

A

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

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

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

A

static storage

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

Magnetic storage

A

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

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

uses lasers and bumps on a plastic disk

A

optical storage

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

exclusively uses electronics, particularly flash memory

A

flash storage

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

remote storage

A

cloud storage

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

encodes information by punching holes in paper cards

A

paper storage

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

Three factors of storage:

A

speed, cost, evolution

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

a column in a database

A

tuple

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

functional dependencies

A

the relationship between a database attribute and another

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

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

A

key

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

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

A

decompose

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

Each tuple is reliant only on a ______________

A

primary key

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

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

A

unlimited

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

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

A

1

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

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

A

a single parent table

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

What rough shape does a hierarchical database take?

A

a pyramid

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

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

A

library database

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

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

A

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

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

_____________________ 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.

A

Batch processing

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

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

A

Printing out paychecks

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

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

A

priority

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

Jobs that run in a batch processing environment…

A

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

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

FIFO stands for _____.

A

first in, first out

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

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

A

in the background

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

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

A

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

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

only the whole transaction should be saved/processed

A

atomicity

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

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

A

consistent

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

separate from other transactions

A

isolated

30
Q

the data must survive a system failure

A

durable

31
Q

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

A

Durable, atomic

32
Q

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

A

read, write

33
Q

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?

A

Durable

34
Q

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?

A

atomic

35
Q

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?

A

isolation

36
Q

The .NET framework consists mostly of what?

A

Classes (objects)

37
Q

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

A

Time and energy

38
Q

Why is it important to carefully select a database software?

A

To ensure that requirements of an organization are fulfilled

39
Q

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

A

Oracle

40
Q

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

A

software interoperability

41
Q

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

A

Windows 8 Enterprise

42
Q

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

A

NTFS or ReFS

43
Q

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

A

1.4 GHz

44
Q

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

A

I accept the license terms

45
Q

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

A

atomic

46
Q

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

A

fired

47
Q

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

A

before, after, instead of

48
Q

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.

A

consistency, integrity

49
Q

Database triggers are most commonly applied to _____.

A

tables

50
Q

Uses for an SQL trigger

A

deriving information
referential integrity
event logging
auditing
replication
security
error handling

51
Q

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

A

auditing

52
Q

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

A

recognize and react

53
Q

SQL was released by _____ and created by _____.

A

Oracle, IBM

54
Q

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 _____________.

A

confidentiality

55
Q

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

A

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

56
Q

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

A

information security

57
Q

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

A

principle of least privilege

58
Q

CIA triads of data

A

confidentiality, integrity, availability

59
Q

How can data integrity be achieved?

A

encryption

60
Q

Ensuring data recoverability is done using?

A

backup and restore operations

61
Q

Why is database reliability important to organizations?

A

Ensures accuracy of business information

62
Q

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

A

integrity

63
Q

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

A

natural language processing

64
Q

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

A

validate the statements

65
Q

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

A

automation

66
Q

What is the ‘‘notification’’ practice in data warehouse administration?

A

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

67
Q

What happens during data quality processes monitoring?

A

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

68
Q

What specific goals is the security manager concerned with?

A

Authorization and authentication

69
Q

What does data warehouse administration resemble in many ways?

A

Database administration

70
Q
A

CS 204 Database Programming (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions