Every foreign key value has a matching primary key value in another table or tables, or is null
B -
No related tables can be deleted
C -
Every primary key value will have a matching foreign key value in another table or tables
D -
No attributes have a null value
2-
Relational DBMS products are designde to store and manipulate tables. Most products also store
the metadata in the form of tables (and are therefor "seft describing"), in MS Access called:
A -
Application metadata
B -
System tables
C -
Design tools
D -
Application programs
3-
Relations may be unnormalized or de-normalized to:
A -
improve database performance
B -
improve data management
C -
decrease database performance
D -
None of these answers
4-
Select the right option:
A -
(II) Database processing systems are classified by how well they fulfill the basic requirements.
B -
(I) and (II)
C -
(I) databse processing systems, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data
D -
In database processing systems, bussiness users can not interact directly with database applications that interact with the DBMS, which directly accesses the database data.
5-
Select the incorrect option:
A -
None of these answers
B -
Database processing systems are classified by how well they fulfill the basic requirements.
C -
In database processing systems, bussiness users can not be interact directly with the DBMS, which directly accesses the database data.
D -
In database processing systems, bussiness users interact directly with the DBMS, which directly accesses the database data
6-
Select the right option: *
A -
(II) The major purpose of a database system is to provide users an. abstract view. of the system
B -
(I) The purpose of a database is to help people keep track of things
C -
None of these answers
D -
(I) and (II)
7-
Select the incorrect option
A -
Northwind is a sample database
B -
A database is called "seft-describing" because it reduces data duplication
C -
None of these answer
D -
A database is a collection of information that’s related to a particular function or purpose
8-
Select the incorrect option:
A -
In database processing systems, bussiness users interact directly with database applications, which directly access the database data
B -
After enctyption, the query is managed and completed through a compiler-database processing system
C -
None of these answer
D -
A database processing system for analyzing a query issued to a database to generate a corresponding execution procedure for performing database processing in accordance therewith
9-
Select the right option:
Multi-user databases are more complicated than single-user database because:
A -
they must prevent multi-user work from interfeing with another’s
B -
they must prevent one uer’s work from interfeing with another’s
C -
they grant permission to multi-user
D -
None of these answers
10-
Select the incorrect option: *
A -
Normalization is the process of breaking up the data into several tables, so as to minimize the number of times we have to repeat the same data.
B -
None of these answers
C -
Realization is the process of breaking up the data into several tables, so 0as to minimize the number of times we have to repeat the same data
D -
Realization is not the process of breaking up the data into several tables, so as to minimize the number of times we have to repeat the same data
