Reference no: EM132152724

1. The _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

a.data manipulation b.data generation c.data administration d.data definition

2-In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

a.aggregation b.transformation c.optimization d.extraction

3-In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

a.insert operation b.join operation c.find operation d.select operation

4- is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

a.Integrity rules b.Data structure c.File procedure d.Schema diagrams

5-To begin designing a relational database, you must define the _____ by defining each table and the fields in it.

a.primary key b.logical structure c.physical structure d.foreign key

6. Static Web sites are useful for e-commerce sites that need frequent updates.

True

False

7-Which of the following statements is true of a flat file system?

a.Same data can be stored in more than one file

b.Programs and data are independent.

c.Complex requests can be handled easily.

d.It requires very less storage space.

8-Disks are sequential access devices, whereas tapes are random access devices.

True

False

9-The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

a.data warehouse

b.data dictionary

c.data model

d.data mart

10 Which of the following statements is true of a database?

a.It comprises data that cannot be linked

b.It allows more than one program to use the same data.

c.It is a crucial tool for managing overseas subsidiaries.

d.It consists of a segregated set of files.