Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

CompTIA Exams > Data and Database Fundamentals > Flashcards

Data and Database Fundamentals Flashcards

(62 cards)

Start Studying
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
What is a key-value database?
A type of non-relational database
26
What is the name of the backup tool built into Apple's operating system?
Time Machine
27
What is a good practice when performing a test restore of your backups?
Save the data to a different folder
28
What is a key benefit of using offline databases?
They reduce the risk of cyber attacks.
29
What type of database works best with semi-structured data?
Key/value pair database
30
What is Carbonite primarily used for in businesses?
Backing up files and folders automatically
31
What are data brokers?
Companies that collect and sell data
32
What is one advantage of databases in terms of data recovery?
Databases back up information within seconds.
33
Which of the following correctly defines a database record?
A collection of related fields in a row
34
What does a relationship in a database do?
Connects two entities
35
What is targeted marketing?
A method where companies show ads for things they think you'll like based on the data they collect about you
36
Which type of database allows users to access it over the Internet?
Online database
37
What is an incremental backup?
A backup that saves only the files that have changed since the last backup
38
What is a common mistake people make when they think they are backing up their files?
Moving files instead of copying them
39
What type of relationship has one record with a primary key associated with multiple records in other tables with foreign keys?
B) One-to-many relationship
40
What is the main purpose of backing up data?
To have a copy of your data in case of an emergency
41
Which type of database is best for organizing semi-structured and unstructured data?
Non-relational Database
42
What type of files can a document database store?
Many different types of files
43
What is Carbonite primarily used for in businesses?
Backing up files and folders automatically
44
What can the value in a key-value pair be?
Any type of data
45
What does scalability in a database mean?
The ability to handle a large amount of data efficiently
46
Which backup tool is built into the Windows operating system?
Windows Backup
47
What is a key benefit of using offline databases?
They reduce the risk of cyber attacks.
48
Why is it easier to reinstall programs now compared to the past?
Programs are available online
49
What is another term for rows in a database?
Records
50
What is cloud storage?
Using space on another computer through the Internet
51
What is a report in a database?
A summary of data
52
What is the main purpose of a physical data model?
To show how to set up a database using a specific database management system
53
What happens when you delete an application from within Settings on a Windows computer?
It is permanently deleted.
54
What is a flat file system?
Another name for a spreadsheet.
55
What type of data is divided into clear, separate categories?
Structured data
56
Which type of database is best for organizing semi-structured and unstructured data?
Non-relational Database
57
Which type of data model includes primary keys and foreign keys?
Logical Data Model
58
What is a database?
A highly organized, multi-table digital storage system
59
Which type of data model is the simplest?
Conceptual Data Model
60
What type of data falls between organized and unorganized?
Semi-structured data
61
What is a relational database?
A database that keeps data in several connected tables.
62
Which type of data is best stored in a relational database?
Structured data

CompTIA Exams (19 decks)

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