DATA2 - Test 1

Define a One-to-One (1:1) relationship

A 1:1 relationship means that each instance of an entity x (for example, a student) can have at most one related entity y (for example, a student ID). (2/2) only one value in a table is associated with a single value in another table

What is a Crow foot notation?

Crow's foot notation is a method of drawing an entity-relationship diagram to show the cardinality of the relationships between entities. an entity relationship diagram used to represent a "many" sides relationship

Which of the following is an example of a server-oriented DBMS? Access Microsoft Windows Oracle Paradox COBOL

c

_________ means that fewer errors are made in a database environment than in a traditional file system because updates on data items shared by several files are made only once. Program-data independence Data manipulation Data integrity Concurrent access e.Vulnerability to failure

c

A disadvantage to database processing is its initial _____.

cost

A database's query facility is useful only to those who can program in a host language. True False

f

Distributed database systems generally store data at a single, central location and make those data available to users at multiple sites. True False

f

Object-oriented databases store data by organizing them into records and fields. True False

f

SQL refers to a mainframe-oriented hierarchical database management system. True False

f

The acronym QBE stands for query before extraction. True False

f

The terms "database" and "data warehouse" mean exactly the same thing. True False

f

A record is comprised of related ___________________________________________.

fields

A(n) _____ is a collection of information about the records of a file, including the names, lengths, and types of the fields.

file structure

Using data to prepare reports and queries and to perform file maintenance is known as data _____.

manipulation

A file is a collection of related _____________________________________________.

records

For what sorts of purposes is a data dictionary used?

stores metadata-- data about data

A database management system is a software package designed to integrate data and provide easy access to them. True False

t

File maintenance refers to such activities as updating records. True False

t

Relational database management systems are so named because they relate data in different files by common fields In those files. True False

t

The _________ is the person or group of people in charge of setting up and managing hierarchical and network databases.

database administrator

What is a "Left Outer Join" query?

A left outer join query will return all the records in the "left" table, even if the join condition does not find a matching record in the "right" table. yields all the rows in the left table and those wirh no matching values in the second table

What is meant by data mining

Data mining is the process of looking for patterns or relationships in large sets of data with the goal of being able to make predictions based on that information. to analyze data in a data warehouse

What is meant by Locking with respect to database queries.

Locking is used to prevent corruption of data by only allowing one write operation on a given piece of data, and preventing others from reading the data until the modifications have been completed. (2/2) used to assure unique use of data

What is Normalization ?

Normalization is the process of refining the database structure to make sure the data dependencies make sense, and minimize redundancy. 1F -- 2NF-- 3NF BCNF

What is meant by ODBC?

Open Database Connectivity

What is meant by Systems Developement Life Cycle (SDLC)

Provides a big picture within the database design

SQL is an acronym for _____.

Structured Query Language

A database management system is basically a collection of software. collection of hardware. type of data-mining program. consumer-oriented multimedia system program. spreadsheet.

a

The database management system's onscreen form for supplying a file's contents is called a template data structure host processor precompiler database

a

What is meant by "data integrity?"

a condition where all entities comply with referential integrity constraints

Another name for query is information overload. information retrieval. data structuring. programming language interface. data mining.

b

The process of setting up the database prior to entering data into it is called data development. definition. manipulation. creation. application. True/False

b

An index distributes databases to multiple locations. is used to filter records. describes how records are to be arranged on output. is a type of file-folder-tab menu. relates fields to records.

c

By putting data into a single occurrence of a template, a user creates a(n) data warehouse. field. record. program. database.

c

Relational database management systems are so called because they are related to file managers. are related to mainframe database management systems. relate data in various files through common fields. relate security to specific data fields. require relational disks for storing data.

c

The process of setting up a database prior to entering data into it is known as _____. data structure QBE data definition data manipulation precompiling

c

Languages such as COBOL, when used in a database environment, are called data dictionaries. clients. retrieval/update facilities. host languages. data definition languages.

d

What is meant by DDL language used to describe database data.

data definition language (DDL)

What is meant by DML language as it it use used to describe database data.

data manipulation language (DML)

DBMS stands for ________________________________________________________.

database management system

Many database systems allow users to place a temporary "lock" on certain blocks of data while they are using them to prevent aliasing. unauthorized access by teenaged hackers. hardware failures. data mining. access by other authorized users.

e

Updating database data by adding, deleting, and modifying records is called file _____.

maintenance

The DBMS feature that enables users to extract information and data records easily is the _____ facility.

retrieval/update

_____ A standard language for information retrieval in relational DBMSs.

structured query language (SQL)

A distributed DBMS may be able to retrieve data from several files concurrently without the user needing to know from which files the data originated. True False

t

A prelabeled onscreen form that requires the operator to fill in only a limited number of entries is called a template. True False

t

Relational database management systems are commonly used on PCs. True False

t

A collection of related records is called a ___________.

table

Data are placed into records with a database management system by using an onscreen form called a(n) _____.

template

Database management systems contain _____ programs such as a data dictionary facility and a help facility.

utility