1-
|
Select the incorrect option:
|
|
A -
|
In a database processing system, all data is stored in a single repository called a database rather than in separate files.
|
|
B -
|
In a database processing system, bussiness users interact directly with the DBMS, which directly accesses the database data
|
|
C -
|
In a database processing system, bussiness users can not interact directly with the DBMS, which directly accesses the database data
|
|
D -
|
One advantage to using a database processing system is that the data of various users can be combined and among authorized users
|
2-
|
Select the right option:
|
|
A -
|
Database can not combined with Internet technologies to receive data on the Web
|
|
B -
|
Database can be combined with Internet technologies to receive data on the Web
|
|
C -
|
Database can not combined with Internet technologies to publish database data on the Web
|
|
D -
|
Database can be combined with Internet technologies to publish datbase data on the Web
|
3-
|
Select the incorrect option:
|
|
A -
|
In Database Processing System: data is integrated into a central database with common format
|
|
B -
|
In database processing systems, bussiness users interact directly with database applications, which directly access the database data
|
|
C -
|
In database processing systems, bussiness users can not be interact directly with database applications, which directly access the database data
|
|
D -
|
All of these answers
|
4-
|
Select the incorrect option:
|
|
A -
|
In database processing system, forms can not be processed by the user
|
|
B -
|
In database processing, files are relating to data and always updated. Moreover, the application program does not depend on the data structures
|
|
C -
|
In a database processing system, forms are processed by the user
|
|
D -
|
None of these answers
|
5-
|
SQL is a(n) ____.
|
|
A -
|
All of the other answer
|
|
B -
|
combination of a data definition language and a data manipulation language
|
|
C -
|
national standard
|
|
D -
|
data sublanguage
|
6-
|
The following Relational Algebra Operations require that both tables (or virtual tables) involved
have # exact same attributes/datatypes.
|
|
A -
|
Union, Intersection, Minus
|
|
B -
|
Minus, Multiplication, Intersection
|
|
C -
|
Multiplication and Division
|
|
D -
|
Join, Projection, Restriction
|
7-
|
The catalog is maintained by
|
|
A -
|
the author of the tables in the database
|
|
B -
|
the database administrator
|
|
C -
|
the user
|
|
D -
|
the DBMS
|
8-
|
The following table and functional dependencies exhibits what type of dependency?
Table (A, B, C)
A -> C
A -> B
B -> C
|
|
A -
|
A and B
|
|
B -
|
Full Dependence
|
|
C -
|
Partial Dependence
|
|
D -
|
Transitive Dependence
|
9-
|
The component of a databse that makes it self-describing is the:
|
|
A -
|
related tables
|
|
B -
|
metadata
|
|
C -
|
library
|
|
D -
|
data set
|
10-
|
For which task in SQL would you use an IN clause
|
|
A -
|
To query the database for a character pattern
|
|
B -
|
To query the database for a range of value
|
|
C -
|
To query the database for unknown values
|
|
D -
|
To query the database for values in a specified list
|