Brainscape's Knowledge GenomeTM

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


See full index

CompTIA Exams > Data and Database Fundamentals > Flashcards

Data and Database Fundamentals Flashcards

1
Q

What data formats are commonly used in document databases?

A

JSON and XML

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

What is a primary key in a database?

A

A unique identifier for each record

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

Why is it important to back up personal data files?

A

They are difficult or impossible to recreate

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

What is non-structured data?

A

Data that doesn’t have a clear order or pattern

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

In a one-to-one relationship, how many records in one table are associated with records in another table?

A

One record in one table is associated with only one record in another table

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

What does a system backup usually involve?

A

Creating a fully bootable disk image

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

What is the main purpose of a physical data model?

A

To show how to set up a database using a specific database management system

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

What is a database schema?

A

The architecture of how a database is structured and organized

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

What is a report in a database?

A

A summary of data

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

Which type of data model includes primary keys and foreign keys?

A

Logical Data Model

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

Which type of database allows users to access it over the Internet?

A

Online database

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

What do we call the vertical columns in a database?

A

Fields

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

What should you do to test if your backups are working properly?

A

Check the backup media for errors

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

What is one downside of cloud backups?

A

They require a lot of network bandwidth.

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

What does RDBMS stand for?

A

Relational Database Management System

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

What does scalability in a database mean?

A

The ability to handle a large amount of data efficiently

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

What is a query in a database?

A

A request for data

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

What is a flat file system?

A

Another name for a spreadsheet.

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

What does a NOT NULL constraint do?

A

Ensures a field must have a value

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

What is a document database?

A

A type of non-relational database

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

What is a database schema?

A

The architecture of how a database is structured and organized

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

What data formats are commonly used in document databases?

A

JSON and XML

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

What does a conceptual data model focus on?

A

High-level ideas

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

What is the main purpose of a physical data model?

A

To show how to set up a database using a specific database management system

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

What is a key-value database?

A

A type of non-relational database

26
Q

What is the name of the backup tool built into Apple’s operating system?

A

Time Machine

27
Q

What is a good practice when performing a test restore of your backups?

A

Save the data to a different folder

28
Q

What is a key benefit of using offline databases?

A

They reduce the risk of cyber attacks.

29
Q

What type of database works best with semi-structured data?

A

Key/value pair database

30
Q

What is Carbonite primarily used for in businesses?

A

Backing up files and folders automatically

31
Q

What are data brokers?

A

Companies that collect and sell data

32
Q

What is one advantage of databases in terms of data recovery?

A

Databases back up information within seconds.

33
Q

Which of the following correctly defines a database record?

A

A collection of related fields in a row

34
Q

What does a relationship in a database do?

A

Connects two entities

35
Q

What is targeted marketing?

A

A method where companies show ads for things they think you’ll like based on the data they collect about you

36
Q

Which type of database allows users to access it over the Internet?

A

Online database

37
Q

What is an incremental backup?

A

A backup that saves only the files that have changed since the last backup

38
Q

What is a common mistake people make when they think they are backing up their files?

A

Moving files instead of copying them

39
Q

What type of relationship has one record with a primary key associated with multiple records in other tables with foreign keys?

A

B) One-to-many relationship

40
Q

What is the main purpose of backing up data?

A

To have a copy of your data in case of an emergency

41
Q

Which type of database is best for organizing semi-structured and unstructured data?

A

Non-relational Database

42
Q

What type of files can a document database store?

A

Many different types of files

43
Q

What is Carbonite primarily used for in businesses?

A

Backing up files and folders automatically

44
Q

What can the value in a key-value pair be?

A

Any type of data

45
Q

What does scalability in a database mean?

A

The ability to handle a large amount of data efficiently

46
Q

Which backup tool is built into the Windows operating system?

A

Windows Backup

47
Q

What is a key benefit of using offline databases?

A

They reduce the risk of cyber attacks.

48
Q

Why is it easier to reinstall programs now compared to the past?

A

Programs are available online

49
Q

What is another term for rows in a database?

A

Records

50
Q

What is cloud storage?

A

Using space on another computer through the Internet

51
Q

What is a report in a database?

A

A summary of data

52
Q

What is the main purpose of a physical data model?

A

To show how to set up a database using a specific database management system

53
Q

What happens when you delete an application from within Settings on a Windows computer?

A

It is permanently deleted.

54
Q

What is a flat file system?

A

Another name for a spreadsheet.

55
Q

What type of data is divided into clear, separate categories?

A

Structured data

56
Q

Which type of database is best for organizing semi-structured and unstructured data?

A

Non-relational Database

57
Q

Which type of data model includes primary keys and foreign keys?

A

Logical Data Model

58
Q

What is a database?

A

A highly organized, multi-table digital storage system

59
Q

Which type of data model is the simplest?

A

Conceptual Data Model

60
Q

What type of data falls between organized and unorganized?

A

Semi-structured data

61
Q

What is a relational database?

A

A database that keeps data in several connected tables.

62
Q

Which type of data is best stored in a relational database?

A

Structured data

CompTIA Exams (28 decks)

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