DATABASE MANAGEMENT FINAL
QUESTIONS & ANSWERS!!
What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server?
- ANSWERDBMSs
Which of the following is called a field or column in many database systems? -
ANSWERattribute
What tool can you use to visually represent and analyze a database? -
ANSWERentity-relationship diagram
Redundancy makes changing data more cumbersome and time-consuming. -
ANSWERTrue
Which of the following is NOT true about a relation in a two-dimensional table? -
ANSWERTwo or more columns can share the same name.
The attributes of an entity become the fields or columns in a table. - ANSWERTrue
What should an administrator use to more easily assign database access
permissions to multiple users? - ANSWERGroups
Which of the following are screen objects used to maintain, view, and print data from
a database? - ANSWERForms
Redundancy wastes space because you are storing multiple copies of the same
data. - ANSWERTrue
In database terms, what is the analogy to an ordinary paper file you might keep in a
file cabinet or an accounting ledger? - ANSWERdata file
Which term can be described as the duplication of data and storing it in multiple
locations? - ANSWERredundancy
Which database term is a person, place, object, event, or idea for which you want to
store and process data? - ANSWERentity
Which advantage of database processing makes it easier to make a change in the
database structure? - ANSWERdata independence
How are multiple entities stored in a database? - ANSWEReach entity is stored as a
table
, In a relation, the order of rows is important. - ANSWERFalse
Which operation will allow you to extract data from more than one table? -
ANSWERJoin
Which command contains all rows that are common in two tables? -
ANSWERINTERSECT
In relational algebra, what command causes only certain columns to be included in
the new table? - ANSWERPROJECT
What uniquely identifies a row in a table? - ANSWERprimary key
Based on the table below, which command lists all information from the table
concerning the customer with CustomerNum 260?
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode) -
ANSWERSELECT Customer WHERE CustomerNum=260 GIVING Answer
If you are sorting records by more than one field, which field is the more important
field? - ANSWERprimary sort key
In relational database shorthand, the structure of a relational database is written with
the name of the table followed by the columns in the table listed within parentheses.
- ANSWERTrue
What command do you use to make changes to existing data in a table? -
ANSWERUPDATE
In Access SQL, which character is used as a wildcard to represent any individual
character? - ANSWERquestion mark (?)
What clause do you use in a query to save the results of the query as a table? -
ANSWERINTO
What command do you use to add new data to a table? - ANSWERINSERT
Based on the code shown, which query lists the descriptions of all items that are
located in Storehouse3 and for which there are more than 20 units on hand?
Item (ItemNum, Description, OnHand, Category, Storehouse, Price ) -
ANSWERSELECT Description FROM Item WHERE Storehouse='3' AND
OnHand>20 ;
Which function calculates the number of entries in a table? - ANSWERCOUNT
When used after the word SELECT, which symbol indicates that you want to include
all fields in the query results in the order in which you described them to the DBMS
when you created the table? - ANSWER*
QUESTIONS & ANSWERS!!
What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server?
- ANSWERDBMSs
Which of the following is called a field or column in many database systems? -
ANSWERattribute
What tool can you use to visually represent and analyze a database? -
ANSWERentity-relationship diagram
Redundancy makes changing data more cumbersome and time-consuming. -
ANSWERTrue
Which of the following is NOT true about a relation in a two-dimensional table? -
ANSWERTwo or more columns can share the same name.
The attributes of an entity become the fields or columns in a table. - ANSWERTrue
What should an administrator use to more easily assign database access
permissions to multiple users? - ANSWERGroups
Which of the following are screen objects used to maintain, view, and print data from
a database? - ANSWERForms
Redundancy wastes space because you are storing multiple copies of the same
data. - ANSWERTrue
In database terms, what is the analogy to an ordinary paper file you might keep in a
file cabinet or an accounting ledger? - ANSWERdata file
Which term can be described as the duplication of data and storing it in multiple
locations? - ANSWERredundancy
Which database term is a person, place, object, event, or idea for which you want to
store and process data? - ANSWERentity
Which advantage of database processing makes it easier to make a change in the
database structure? - ANSWERdata independence
How are multiple entities stored in a database? - ANSWEReach entity is stored as a
table
, In a relation, the order of rows is important. - ANSWERFalse
Which operation will allow you to extract data from more than one table? -
ANSWERJoin
Which command contains all rows that are common in two tables? -
ANSWERINTERSECT
In relational algebra, what command causes only certain columns to be included in
the new table? - ANSWERPROJECT
What uniquely identifies a row in a table? - ANSWERprimary key
Based on the table below, which command lists all information from the table
concerning the customer with CustomerNum 260?
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode) -
ANSWERSELECT Customer WHERE CustomerNum=260 GIVING Answer
If you are sorting records by more than one field, which field is the more important
field? - ANSWERprimary sort key
In relational database shorthand, the structure of a relational database is written with
the name of the table followed by the columns in the table listed within parentheses.
- ANSWERTrue
What command do you use to make changes to existing data in a table? -
ANSWERUPDATE
In Access SQL, which character is used as a wildcard to represent any individual
character? - ANSWERquestion mark (?)
What clause do you use in a query to save the results of the query as a table? -
ANSWERINTO
What command do you use to add new data to a table? - ANSWERINSERT
Based on the code shown, which query lists the descriptions of all items that are
located in Storehouse3 and for which there are more than 20 units on hand?
Item (ItemNum, Description, OnHand, Category, Storehouse, Price ) -
ANSWERSELECT Description FROM Item WHERE Storehouse='3' AND
OnHand>20 ;
Which function calculates the number of entries in a table? - ANSWERCOUNT
When used after the word SELECT, which symbol indicates that you want to include
all fields in the query results in the order in which you described them to the DBMS
when you created the table? - ANSWER*
