Brainscape's Knowledge GenomeTM

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


See full index

Computing Fundamentals > Module 3 Unit 4: Using Databases > Flashcards

Module 3 Unit 4: Using Databases Flashcards

1
Q

An organized collection of information. The information is stored in a structured manner for easier access.

It is used both to store information securely and to report on the information it contains.

A

Database

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

A database typically consists of tables of information that are organized into what?

A

Columns and Rows

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

Each row represents a separate _________ in the database, while each column represents a single __________within a record.

A

Row - Record
Column - Field

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

Database usage involves the following processes and tools:

A

Creation
Import/Input
Storage (data persistence)
Queries
Reports

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

This step in the database processes/tools that involves defining what information the database will store, where it will be hosted, and how it will be accessed by clients.

A

Creation

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

This step in the database processes/tools that involves populating the database with data records, which can be updated manually using some type of form or can also be from another source, or both.

A

Import/Input

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

This step in the database processes/tools that represents a way for an application to store data persistently.

A

Storage

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

This step in the database processes/tools that is used to extract information more efficiently and allows the user to specify criteria to match values in one or more fields and choose which fields to display in the results so that only information of interest is selected.

A

Query

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

This step in the database processes/tools that functions a means of formatting and summarizing the records returned by a query so that the information is easy to read and interpret.

A

Reports

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

Two examples of a flat file systems

A

Spreadsheets (Excel)
Plain text file with delimiters for each column (CSV)

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

A type of file that uses commas to identify the end of a column and a line feed for each row

A

Comma Separated Values (CSV)

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

What are the advantages of databases over flat file systems?

A

Databases can enforce data types for each column and validate information entered as fields and records.

Databases can manage multiple tables and link the fields in different tables to create complex connections

Databases can support tens, hundreds or thousands, or even millions of users

Databases are also more scalable

Databases provide access controls and backup/replication tools

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

A highly structured type of database. Information is organized in tables (known as relations).

A

Relational Database

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

A table in a relational database is defined with a number of ________ represented by table columns and can be a particular data type.

Each row entered into the table represents a data ________.

A

Fields
Record

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 Systems

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

The type of language that RDBMS use to maintain and query data in the database. (Microsoft SQL Server, Oracle Database, MySQL, Microsoft Office Access).

A

Structured Query Language (SQL)

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

Is used to define the relationship between one table and another table in the database. Each record in this field should have a unique value

A

Primary key

18
Q

When a primary key in one table is referenced in another table, then in the secondary table, that column is referred to as what?

A

Foreign key

19
Q

Refers to the structure of the database in terms of the fields defined in each table and the relations between primary and foreign keys

A

Schema

20
Q

One of the functions of an RDBMS is to address this concept.

It is very important that the values entered into fields conform are consistent with what information the field is supposed to store.

A

Garbage In, Garbage Out (GIGO)

21
Q

When defining the properties of each field, as well as enforcing a data type, you can impose this on the values that can be input into each field. (Ex: Primary key)

This can be applied at different levels. As well as applying rules to fields, they can be used at the table and schema levels too.

A

Constraints

22
Q

Database that provides no rigid formatting of the data. The data in this database is typically much easier to create than structured data. (Ex: Images and text files, Word documents and PowerPoint presentations)

A

Unstructured Database

23
Q

Sits somewhere between a structured and nonstructured database.

The data lacks the structure of formal database architecture. But in addition to the raw unstructured data, there is associated information that helps identify the data.

A

Semi-structured database

24
Q

Associated information that helps identify the data in a semi-structured data.

A

Metadata

25
Q

An example of a semi-structured database.

Rather than define tables and fields, the database grows by adding documents to it. The documents can use the same structure or be of different types.

A

Document database

26
Q

Markup language that documents in a document database would very commonly use

A

XML (eXtensible Markup Language)

27
Q

A means of storing the properties of object without predetermining the fields used to define an object.

A

Key/Value pair database

28
Q

Why are document databases and key/value pair databases are non-relational?

A

There are no formal structures to link the different data objects and files

29
Q

A widely used key/value format

A

JavaScript Object Notation (JSON)

30
Q

Database engines dealing with a mixture of structured, unstructured, and semi-structured data

A

NoSQL databases (No SQL/Not only SQL)

31
Q

The processes used to add/update information to and extract (or view) information from the database.

A

Database interfaces

32
Q

Refers to SQL commands that add to or modify the structure of the database. (CREATE, ALTER TABLE/DATABASE, DROP, CREATE INDEX)

A

Data Definition Language (DDL)

33
Q

A DDL command that can be used to add a new database on the RDBMS server

A

CREATE

34
Q

A DDL command that allows you to add, remove (drop), and modify table columns (fields), change a primary key and/or foreign key.

A

ALTER TABLE

35
Q

A DDL command used to delete a table or database

A

DROP (DROP TABLE/DROP DATABASE)

36
Q

A DDL command that speeds up queries. The tradeoff is that updates are slowed down

A

CREATE INDEX

37
Q

Refers to SQL commands that allow you to insert or update records and extract information from records for viewing (a query)

A

Data Manipulation Methods

38
Q

A DML command that adds a new row in a table

A

INSERT INTO TableName

39
Q

A DML command that changes the value of one or more table.

This can be used with a WHERE statement to filter the records that will be updated

A

UPDATE TableName

40
Q

A DML command that deletes records from the table.

A

DELETE FROM TableName

41
Q

A DML command that enables you to define a query to retrieve data from a table

A

SELECT

Computing Fundamentals (7 decks)

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