CIS CHAPTER EXAM (Latest 2024)|Which one of the
following statements does not apply to the database
approach? a. Database systems have data independence;
that is, the data and the programs are maintained
separately, except during processing
CIS CHAPTER EXAM
Which one of the following statements does not apply to the database
approach? - ANSWER>>>
c. The database administrator is the part of the software package that
instructs the operating aspects of the program when data are
retrieved.
a. Database systems have data independence; that is, the data and
the programs are maintained separately, except during processing.
b. Database management systems employ a data definition language
that helps describe each schema and subschema.
c. The database administrator is the part of the software package that
instructs the operating aspects of the program when data are
retrieved.
d. A primary goal of database systems is to minimize data
redundancy.
e. Database systems are based on the philoso- phy of data
ownership.
Database tables should be normalized. This means- ANSWER>>>
a. each attribute in a row should be dependent on the primary key
and independent of other attributes in the table.
a. each attribute in a row should be dependent on the primary key and
independent of other attributes in the table.
b. each attribute in a row should be indepen- dent of the primary key
and dependent on other attributes in the table.
, c. each attribute in a row should contain a unique in its value
d. the value of each attribute should fall within a normal range of
values predetermined for that attribute.
e. both a and d are correct.
a. User views limit access to the database. - ANSWER>>> Which of
the following is a characteristic of a relational database system?
a. User views limit access to the database.
b. Database navigation follows explicit links
that are contained within the records.
c. All users share all the data to achieve integration of functions.
d. No two users share the same user view.
c. read-only access is needed at each site. - ANSWER>>> Replicated
databases are most effective when
a. users in the system do not need to share common data.
b. primary users of the data are clearly identifiable.
c. read-only access is needed at each site.
d. all of the above.
d. database design, database implementation, and database planning.
- ANSWER>>> The functions of a database administrator are
a. database planning, data input preparation, and database design.
b. data input preparation, database design, and database operation.
c. database design, database operation, and equipment operations.
d. database design, database implementation, and database planning.
e. database operations, database maintenance, and data input
preparation.
d. user view. - ANSWER>>> The data attributes that a particular user
has per- mission to access are defined by the
a. operating system view.
b. systems design view.
c. database schema.
d. user view.
e. application program
following statements does not apply to the database
approach? a. Database systems have data independence;
that is, the data and the programs are maintained
separately, except during processing
CIS CHAPTER EXAM
Which one of the following statements does not apply to the database
approach? - ANSWER>>>
c. The database administrator is the part of the software package that
instructs the operating aspects of the program when data are
retrieved.
a. Database systems have data independence; that is, the data and
the programs are maintained separately, except during processing.
b. Database management systems employ a data definition language
that helps describe each schema and subschema.
c. The database administrator is the part of the software package that
instructs the operating aspects of the program when data are
retrieved.
d. A primary goal of database systems is to minimize data
redundancy.
e. Database systems are based on the philoso- phy of data
ownership.
Database tables should be normalized. This means- ANSWER>>>
a. each attribute in a row should be dependent on the primary key
and independent of other attributes in the table.
a. each attribute in a row should be dependent on the primary key and
independent of other attributes in the table.
b. each attribute in a row should be indepen- dent of the primary key
and dependent on other attributes in the table.
, c. each attribute in a row should contain a unique in its value
d. the value of each attribute should fall within a normal range of
values predetermined for that attribute.
e. both a and d are correct.
a. User views limit access to the database. - ANSWER>>> Which of
the following is a characteristic of a relational database system?
a. User views limit access to the database.
b. Database navigation follows explicit links
that are contained within the records.
c. All users share all the data to achieve integration of functions.
d. No two users share the same user view.
c. read-only access is needed at each site. - ANSWER>>> Replicated
databases are most effective when
a. users in the system do not need to share common data.
b. primary users of the data are clearly identifiable.
c. read-only access is needed at each site.
d. all of the above.
d. database design, database implementation, and database planning.
- ANSWER>>> The functions of a database administrator are
a. database planning, data input preparation, and database design.
b. data input preparation, database design, and database operation.
c. database design, database operation, and equipment operations.
d. database design, database implementation, and database planning.
e. database operations, database maintenance, and data input
preparation.
d. user view. - ANSWER>>> The data attributes that a particular user
has per- mission to access are defined by the
a. operating system view.
b. systems design view.
c. database schema.
d. user view.
e. application program
