Practice Test 1

Question 1

Connected fields in a table that complete a row

Answer 1

Record

Question 2

dbms does many things like integrity, storage, and security management but it doesnt

Answer 2

create data reports

Question 3

An example of unstructured data would be

Answer 3

A video but if you had fields describing a video then it could be

Question 4

what is data classified as

Answer 4

raw facts. Only processed data can be considered information

Question 5

Intersection data

Answer 5

This would be when tables that do not share common fields are connected using fields that they do have in common

Question 6

Unary or Binary

Answer 6

Unary is when theres a relationship with the same entity (itself) employee to employee while binary is a relationship between two different entities (student / course)

Question 7

Database Models are….

Answer 7

They are conceptual frameworks for database systems

Question 8

Modality

Answer 8

Means whether something must participate in the relationship. 1 means yes 0 means no

Question 9

Entity Integrity

Answer 9

Requires all primary keys to be unique

Question 10

Referential Integrity

Answer 10

Foreign Keys must refer to a valid primary key from another table

Question 11

A table is perceived as…

Answer 11

two-dimensional structure

Question 12

another term for relation

Answer 12

Table Name

Question 13

Distinct filter

Answer 13

modifies presentation of query results

Question 14

Primary Key

Answer 14

Always needs to be unique

Question 15

Common Attribute

Answer 15

Properties or characteristics shared between two or more tables

Question 16

Allows you to combine information from two or more tables

Answer 16

SELECT operation

Question 17

Primary key will appear as a foreign keys in related tables

Question 18

When designing a new database…..

Answer 18

you want to reduce data redundancy

Question 19

SuperKey

Answer 19

Any numbers of columns that can uniquely identify a row. (ex. Table has Studentid, email, class for columns and the super key could be all 3)

Question 20

Candidate key

Answer 20

The least amount of columns that could be used to uniquely identify a row. essentially a simple super key. (ex. Table has Studentid, email, class for columns and StudentId is enough to identify the row then that would be considered a candidate key)

Question 21

Foreign keys must match…..

Answer 21

the primary keys value in the related field

Question 22

A Entity Relationship Diagram (ERD)

Answer 22

Graphically represents the concepts of a DataBase model

Question 23

Derived attribute

Answer 23

This attribute doesnt actually store its data in a table but actually gets it from two or more values in a table/tables. Think of it as a calculated value.

Question 24

Composite Key

Answer 24

more than one attribute

Question 24

Relationship is between

Answer 24

entities

Question 25

Atomic attribute

Answer 25

cannot be subdivided. Ex: Fullname could be divided to first and last but FirstName cant be divided an smaller.

Question 26

Independent Entity

Answer 26

Entities that do not depend on any other entity in the model for identification

Question 27

Dependent Entity

Answer 27

entity that depends on the foreign key attribute for uniqueness

Question 28

Ternary

Answer 28

when 3 or more entities have a relationship

Question 29

Domain

Answer 29

set of possible values

Question 30

1N

Answer 30

The table only has 1 value or atomic value and their all unique

Question 31

2N

Answer 31

all non-key attributes must be fully dependent on the primary key.

Question 32

3N

Answer 32

table must be in 2NF, and all attributes must be directly dependent on the primary key, not on other non-key attributes (eliminating transitive dependency).

Question 33

Data reduncy

Answer 33

Causes slower lookups

Question 34

Partial dependencies

Answer 34

Dependency on only a part of the composite key

Question 35

INSERT

Answer 35

Lets you insert Data into a table

Question 36

Update

Answer 36

Lets you make changes to data in a table

Question 37

SELECT

Answer 37

Lets you select and list all the content of a table

Question 38

Delete

Answer 38

Removes a row from the table

Question 39

LIKE

Answer 39

Checks for similar character strings

Question 40

DROP

Answer 40

Will delete a whole table from the database

Question 41

Full Outer Join

Answer 41

Returns rows with matching values and unmatching

Question 42

Extract, transform, load (ETL)

Answer 42

used in data warehousing to extract data from various sources, transform it into a format suitable for loading into a data warehouse, and then load it into the warehouse

Question 43

Extract

Answer 43

extract data from various sources such as transactional systems, spreadsheets, and flat files

Question 44

Transform

Answer 44

extracted data is transformed into a format that is suitable for loading into the data warehouse. This may involve cleaning and validating the data, converting data types, combining data from multiple sources, and creating new data fields

Question 45

Load

Answer 45

This step involves creating the physical data structures and loading the data into the warehouse (Important to monitor volume and frequency that data is being loaded into warehouse)

Question 46

Structured Data

Answer 46

Standardized format can be processed to generate information

Question 47

Modality

Answer 47

Min number of values on one side of the relationship