ISTM 210 (TAMU)- Exam 5 Questions &
Answers (Grade A+)
is a well thought-out collection of computer files, the most
important of which are called tables. -
correct answer ✅database software
Tables consist of ___________ (rows) separated by ________
(columns) that can be ____________ (questioned) to produce
subsets of information. -
correct answer ✅records, fields, queried
Databases are created using software systems known as -
correct answer ✅database management systems (DBMS)
Business databases are _____________ ________________ on a
computer network for multiple users. -
correct answer ✅always distributed
first database management systems were -
correct answer ✅filing cabinets
display database information on screen or on paper -
correct answer ✅reports
,ISTM 210 (TAMU)- Exam 5 Questions &
Answers (Grade A+)
used to find specific populations (subsets) within databases -
correct answer ✅saved query files
that overlay data tables and queries for more specific views of data
-
correct answer ✅forms
is a database-modeling method used to construct a theoretical and
conceptual representation of data to produce a schema
is a picture of a database's tables and how they relate to each other
-
correct answer ✅Entity relationship modeling (ERM)
is a "map" of data tables and their relationships to one another -
correct answer ✅schema
Database designers need to _______ __ _________________ &
what the ____________________ are of its DBMS -
correct answer ✅know a business, expectations
,ISTM 210 (TAMU)- Exam 5 Questions &
Answers (Grade A+)
another name for fields? -
correct answer ✅attributes
help to ensure the data's integrity -
correct answer ✅data validation rules
The nature and structure of a well thought-out database
management system helps a business avoid _______
________________. -
correct answer ✅data redundancy
is the most widely used standard computer language for relational
databases as it allows a programmer to manipulate and query data.
-
correct answer ✅Structured Query Language (SQL)
Data is __________ because it changes all the time. -
correct answer ✅fluid
some SQL statements? -
correct answer ✅APPEND, DELETE, UPDATE
SELECT, FROM, WHERE, ORDER
, ISTM 210 (TAMU)- Exam 5 Questions &
Answers (Grade A+)
restricts data input -
correct answer ✅field mask
the ability to add a filter to a data table that would only display
specific information -
correct answer ✅filtering
Insuring a field is populated with usable data -
correct answer ✅data validation
the most widely used database in the world -
correct answer ✅oracle
is anything about which the organization wishes to store data.
the thing you want to track
At your college or university, one of these would be the student. -
correct answer ✅entity
Answers (Grade A+)
is a well thought-out collection of computer files, the most
important of which are called tables. -
correct answer ✅database software
Tables consist of ___________ (rows) separated by ________
(columns) that can be ____________ (questioned) to produce
subsets of information. -
correct answer ✅records, fields, queried
Databases are created using software systems known as -
correct answer ✅database management systems (DBMS)
Business databases are _____________ ________________ on a
computer network for multiple users. -
correct answer ✅always distributed
first database management systems were -
correct answer ✅filing cabinets
display database information on screen or on paper -
correct answer ✅reports
,ISTM 210 (TAMU)- Exam 5 Questions &
Answers (Grade A+)
used to find specific populations (subsets) within databases -
correct answer ✅saved query files
that overlay data tables and queries for more specific views of data
-
correct answer ✅forms
is a database-modeling method used to construct a theoretical and
conceptual representation of data to produce a schema
is a picture of a database's tables and how they relate to each other
-
correct answer ✅Entity relationship modeling (ERM)
is a "map" of data tables and their relationships to one another -
correct answer ✅schema
Database designers need to _______ __ _________________ &
what the ____________________ are of its DBMS -
correct answer ✅know a business, expectations
,ISTM 210 (TAMU)- Exam 5 Questions &
Answers (Grade A+)
another name for fields? -
correct answer ✅attributes
help to ensure the data's integrity -
correct answer ✅data validation rules
The nature and structure of a well thought-out database
management system helps a business avoid _______
________________. -
correct answer ✅data redundancy
is the most widely used standard computer language for relational
databases as it allows a programmer to manipulate and query data.
-
correct answer ✅Structured Query Language (SQL)
Data is __________ because it changes all the time. -
correct answer ✅fluid
some SQL statements? -
correct answer ✅APPEND, DELETE, UPDATE
SELECT, FROM, WHERE, ORDER
, ISTM 210 (TAMU)- Exam 5 Questions &
Answers (Grade A+)
restricts data input -
correct answer ✅field mask
the ability to add a filter to a data table that would only display
specific information -
correct answer ✅filtering
Insuring a field is populated with usable data -
correct answer ✅data validation
the most widely used database in the world -
correct answer ✅oracle
is anything about which the organization wishes to store data.
the thing you want to track
At your college or university, one of these would be the student. -
correct answer ✅entity
