Upgrade to remove ads
DATA2 - Test 1
Terms in this set (50)
The database management system's onscreen form for supplying a file's contents is called a
A database management system is basically a
collection of software.
collection of hardware.
type of data-mining program.
consumer-oriented multimedia system program.
_________ 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.
e.Vulnerability to failure
Languages such as COBOL, when used in a database environment, are called
data definition languages.
Many database systems allow users to place a temporary "lock" on certain blocks of data while they are using them to prevent
unauthorized access by teenaged hackers.
access by other authorized users.
The process of setting up a database prior to entering data into it is known as _____.
Which of the following is an example of a server-oriented DBMS?
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.
Another name for query is
programming language interface.
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.
By putting data into a single occurrence of a template, a user creates a(n)
The process of setting up the database prior to entering data into it is called data
A database management system is a software package designed to integrate data and provide easy access to them.
A prelabeled onscreen form that requires the operator to fill in only a limited number of entries is called a template.
Distributed database systems generally store data at a single, central location and make those data available to users at multiple sites.
File maintenance refers to such activities as updating records.
The terms "database" and "data warehouse" mean exactly the same thing.
SQL refers to a mainframe-oriented hierarchical database management system.
A database's query facility is useful only to those who can program in a host language.
The acronym QBE stands for query before extraction.
Relational database management systems are commonly used on PCs.
Object-oriented databases store data by organizing them into records and fields.
Relational database management systems are so named because they relate data in different files by common fields In those files.
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.
A file is a collection of related _____________________________________________.
A record is comprised of related ___________________________________________.
DBMS stands for ________________________________________________________.
database management system
Data are placed into records with a database management system by using an onscreen form called a(n) _____.
The _________ is the person or group of people in charge of setting up and managing hierarchical and network databases.
Using data to prepare reports and queries and to perform file maintenance is known as data _____.
The DBMS feature that enables users to extract information and data records easily is the _____ facility.
SQL is an acronym for _____.
Structured Query Language
A(n) _____ is a collection of information about the records of a file, including the names, lengths, and types of the fields.
Updating database data by adding, deleting, and modifying records is called file _____.
Database management systems contain _____ programs such as a data dictionary facility and a help facility.
A disadvantage to database processing is its initial _____.
A collection of related records is called a ___________.
_____ A standard language for information retrieval in relational DBMSs.
structured query language (SQL)
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 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
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 meant by Systems Developement Life Cycle (SDLC)
Provides a big picture within the database design
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 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
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 DML language as it it use used to describe database data.
data manipulation language (DML)
What is meant by DDL language used to describe database data.
data definition language (DDL)
For what sorts of purposes is a data dictionary used?
stores metadata-- data about data
What is meant by "data integrity?"
a condition where all entities comply with referential integrity constraints
THIS SET IS OFTEN IN FOLDERS WITH...
DATA2 Review Quiz 1
DATA2 Review Quiz 3
Database Competency 4.2
PL/SQL Competency 2 Exam Review - Chapters 1, 2, 3
YOU MIGHT ALSO LIKE...
Data Management Foundation C175 WGU
C175 Data Management - Terms
ch 15 databases
OTHER SETS BY THIS CREATOR
Database Competency 4.3
Database Competency 4.1