Database Concepts

Question 1

Are pieces of information. Data can be measured, collected, analyzed and reported.

Answer 1

Data

Question 2

It is an organized collection of information. The basic function of a database is to store data.

Answer 2

Database

Question 3

It is designed to handle complex relationships between various items of data, and is correctly referred to as a relational database management system (RDBMS).

Answer 3

Database Applications

Question 4

It is the standard language used to create and work with databases.

Answer 4

Structured Query Language (SQL)

Question 5

A standard programming interface for accessing a number of different databases, including Access, DB2, SQL Server, and MySQL.

Answer 5

Open Database Connectivity (ODBC)

Question 6

A standard programming interface for accessing Oracle databases, which run on the Java platform

Answer 6

Java Database Connectivity (JDBC)

Question 7

It is a set of programming building blocks that specify how software components should interact.

Answer 7

Application programming interface (API)

Question 8

Itis a Database Management System (DBMS) fromMicrosoftthat combines the relationalMicrosoftJet Database Engine with a graphical user interface and software development tools.

Answer 8

Microsoft Access

Question 9

It is a field (or a combination of fields) that uniquely identifies each record stored in a table.

Answer 9

Primary key

Question 10

It is equivalent to “unknown.” It is not the same thing as zero (0).

Answer 10

Null

Question 11

A primary key that is comprised of a combination of fields is called a BLANK

Answer 11

Composite Key

Question 12

It is a column (or combination of columns) in a table that references the primary key in another table.

Answer 12

Foreign key

Question 13

Note that the primary key to which a foreign key maps is also known as a parent key BLANK

Answer 13

Parent key

Question 14

There are three types of relationships that can be established between tables:

Answer 14

• One-to-One
• One-to-Many
• Many-to-Many

Question 15

A relationship in which each record in Table A can have only one matching record in Table B

Answer 15

One-to-One

Question 16

A relationship in which a record in Table A can have matching records in Table B, but a record in Table B has only one matching record in Table A

Answer 16

One-to-Many

Question 17

A relationship in which one record in Table A or Table B can be related to many matching records in the other table

Answer 17

Many-to-Many

Question 18

It represents a logical view of the entire database. It defines how the data is organized and how the tables within the database are related to one another.

Answer 18

Database schema

Question 19

Works by checking table fields for entries that meet the criteria that you specify.

Answer 19

Queries

Question 20

It can be strings of text, dates, or a number or range of numbers that you enter.

Answer 20

Criteria

Question 21

It is not a static snapshot of records, but a dynamic changing subset of records.

Answer 21

Result set or Dynaset (dynamic subset)

Question 22

Are tools that aid data entry and are user-friendly interfaces designed to help users enter specific data without becoming distracted or confused by other data that may be stored in a table.

Answer 22

Forms

Question 23

Two basic types of web pages

Answer 23

• Static
• Dynamic

Question 24

These types of pages display content that does not change (unless the web page developer edits what is on the page).

Answer 24

Static

Question 25

These pages change every time they are loaded in the browser window. They change their content based on user actions.

Answer 25

Dynamic