Brainscape's Knowledge GenomeTM

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


See full index

C182 > Acronym 4 C182 > Flashcards

Acronym 4 C182 Flashcards

1
Q

Database applications have two major layers

A

Application Layer

Database Management Layer

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

Communicates with the end user and can be fairly complex

A

Application Layer

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

DBMS

A

Database Management System

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

The act of analyzing and converting data into information that can be used in decision-making

A

Database research

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

Types of Data

A

Integers
Floating Point Numbers
Characters
Character Strings

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

What type of data?

31068

A

Integers

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

What type of Data?

4.82

A

Floating Point Numbers

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

What type of data?

  • Y
  • #
  • @
A

Characters

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

What type of data?

  • FggsJ43!(08
  • Mmfds59^;3#23edoO
  • G2nS88^9(#@
A

Character Strings

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

What represents a truth value; that is, TRUE or FALSE

A

Boolean Value

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

What stores data in a plain text file? Each line of the text file holds one record.

A

Flat-File Database

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

Data is organized in a tree structure

A 
Hierarchical Database
(one of the oldest database models)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Contains database tables that can be joined together in logical ways

A

Relational Databases

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

What is a Primary Key?

A

A records unique identifier on a relational database

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

What is a Foreign Key?

A

A primary key of one table that appears as an attribute in another table

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

An activity through which users and applications access and manipulate data in relational databases

A

Database Operation

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

Queries

A

When a user or application sends a request to a database

18
Q

SQL

A

Structured Query Language

19
Q

Take rows from one table and create a new table.

A

Selection Operation

20
Q

Combines distinct fields from multiple tables that have the same set of attributes and data types

A

Union Operation

21
Q

Creating a result table that includes all of the attributes from the two tables; each row of the second table is added to each row of the first table

A

Product Operation

22
Q

Combines two tables, but records are only appended when a matching criterion is met

A

Join Operation

23
Q

Stores complex data and relationships between data directly without using inter-table relations.

Optimized to work in a cloud environment

A

Object-Oriented Database

24
Q

Systems of data stored in raw format

A

Data Lakes

25
Q

What is an example of structured data

A

Tables

26
Q

What is an example of unstructured data?

A

Audio and Video recordings

27
Q

Consists of data residing on different machines

A

Distributed Databases

28
Q

DBA

A

Database Administrator

29
Q

(Database Administration (DBA) responsibilities)

Ensuring that only authorized users have access to the database and fortifying it against unauthorized access

A

Database Security

30
Q

(Database Administration (DBA) responsibilities)

Optimizing performance of database systems

A

Database tuning

31
Q

(Database Administration (DBA) responsibilities)

Making replicas of databases available from various locations

A

High Availability

32
Q

(Database Administration (DBA) responsibilities)

Continuing core business operations effectively, even with the disruption of some auxiliary services

A

Business Continuity

33
Q

(Database Administration (DBA) responsibilities)

Write complex queries and generating reports for users

A

Reporting

34
Q

(Database Administration (DBA) responsibilities)

Writing code to interact with the database resources

A

Designing and Developing Database Applications

35
Q

(Database Administration (DBA) responsibilities)

The translation of raw data into something useful.

Analyzing specific categories of historical information and making decisions based on that information.

A

Business Intelligence

36
Q

BI

A

Business Intelligence

37
Q

NoSQL

A

Not Only SQL

38
Q

A domain-specified language used in programming and designed for managing data

A

SQL

39
Q

SQL

A

Structured Query Langauge

40
Q

Databases that can accommodate a wide variety of data models.
An alternative to traditional relational databases.
Useful for working with large sets of distributed data.

A

NoSQL

41
Q

Databases optimized to work in a cloud environment

A

Cloud Databases

C182 (7 decks)

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