When a properly constructed database is constructed by breaking a list into an appropriate group
of pieces, of the problems associated with lists are solved.
A -
All except the data addition problem
B -
All except the data inconsistency problem
C -
All except the data deletion problem
D -
Many
2-
Which of the following terms is synonymous with "tuple"?
A -
Row
B -
Field
C -
Table
D -
Attribute
3-
Which of the following is a problem of lists that is solved by using a database?
A -
All of other answer
B -
missing data
C -
data inconsistencies
D -
problems adding, deleting data
4-
Which of the following symbols are used to list all of the fields in a SELECT query?
A -
#
B -
*
C -
&
D -
@
5-
Which of the following is not usually part of the responsibilities of a database administrator? *
A -
Approving structual changes to the database
B -
Monitoring the performance of the system
C -
Designing data entry screens
D -
Ensuring that adequate back-up regime is in place
6-
Which of the following is not true about a relation?
A -
The order of the rows of a relation is insignificant
B -
A relation may have duplicate column names
C -
A relation may not have duplicate rows
D -
A relation is a two-dimensional table
7-
Which of the following problems associated with storing data in a list is avoided by storing data in
a relational database
A -
Duplication of data items
B -
All of the above
C -
Maitaining the data many require changing the same data value in many locations
D -
Incosistency when a data item is used multiple times
8-
Which of the following SELECT statements will return only the product names in the products
table with a total value greater than $1000? Assumne the field UnitsInStock is the total number of unit in the
inventory and UnitPrice is the prince per unit.
A -
SELECT ProductName FrROM products WHERE UnitslnStock * UniPrice > 1000
B -
SELECT ProductName FrROM products IF UnitslnStock * UniPrice > 1000
C -
SELECT ProductName FrROM products IF UnitslnStock AND UniPrice > 1000
D -
SELECT ProductName FrROM products WHERE UnitslnStock * UniPrice < 1000
9-
Which of the following functions does a database application program perform?
A -
All of the above
B -
Delete data
C -
Retrieve data
D -
Create data
10-
Which of the following databases # database backups performed?
