Which of the following is used to create and maintain the physical database? Dat

Question

Which of the following is used to create and maintain the physical database?

Data mining

Database Management System (DBMS)

E-R Model

Systems Development Life Cycle (SDLC)

Which of the following terms is considered the basic unit of data in a database?

            A) Character

            B)   Field

            C)   Record

            D) File

Which of the following is a characteristic of databases?

            A) Many users can use the same database at the same time

            B)   Data redundancy control

            C)   Multiple data views. Each view contains only the data that a user/users group needs to access.

            D) All of the above

Use the following to answer questions 4 - 5:

A database table consists of the following columns: employee's name, SS#, job-title, hiring-date, years-in-job, base-salary. A bonus calculation program, a personnel promotion application program, and a payroll application program all use this table. To implement a policy change in personnel promotion, the following column is added to the table: highest-college-degree. This new column is not used by the payroll program or by the bonus calculation program.

The following application program will be modified to accommodate the change to the database table:

            A) The bonus calculation program

            B)   The payroll application program

            C)   The personnel promotion application program

            D) All of the above

The ability to add the new column without requiring changes to all of the application programs strongly relates to the following feature of modern database systems:

            A) Nonprocedural programming

            B)   Transaction processing

            C)   Data sharing

            D) Data independence

Entity Relationship Diagrams are input to the following phase of Database Development:

            A) Logical Database Design

            B)   Conceptual Data Modeling

            C)   Physical Database Design

            D) Distributed Database Design

The multi-step process used when creating a new system is referred to as ____.

            A) The Systems Development Life Cycle

            B)   Data mining

            C)   E-R Modeling

            D) SQL

Explanation / Answer

1)Database Management System (DBMS)

2)Character

3)All of the above

4)The personnel promotion application program

5)Data independence

6)Logical Database Design

7) The Systems Development Life Cycle

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.