CM1603 DB Quiz

Limitations of the file-based data processing approach are ..............

• Data redundancy

• Separation and isolation of data

• Cost effectiveness

• Data independence

A file is simply a collection of …..…........ which contains …..…........ data.

A file based system is a collection of …..…........ that performs services for the …..…........ such as the production reports.

• records, logically related, application programs, end-users

• attributes, distributed, database applications, application developers

• data, non-related, application programs, database designers

• records, distributed, software programs, end-users

Which statement is FALSE regarding File-based Data Processing?

• Does not have program data independence

• Easier to combine data from multiple sources or files with high data quality

• Data abstraction is less common compared to database processing

• File structure dependents on the application program

A database is a …..…........ collection of …..…........ related data and a description of this data, designed to meet the …..…........ needs of an organization.

• random, physically, technical

• simple, graphically, data

• shared, logically, information

• complex, internally, operational

Give the correct terms for A, B, C and D respectively.

• Database system, DBMS, Operational data, Meta data

• Database system, DBMS, Meta data, Operational data

• DBMS, Database system, Meta data, Operational data

• DBMS, Database system, Operational data, Meta data

DBMS separates the data descriptions from the applications, thereby making application immune to changes is called data ………….

• redundancy

• manipulation

• integrity

• independence

Which acts as the bridge (X) between the machine components and the human components in a DBMS?

Which part of the DBMS interacts with the user?

• Front-end

• Back-end

• Client-end

• User-end

Procedures refer to the instructions and rules that govern the design and the use of the

database. The following are few instructions on how procedures work,

A - Log on to the DBMS

B - Log out of the DBMS

C - Start and stop the DBMS

D - Make backup copies of the DB

Which are INCORRECT database procedures?

• A & B

• C & D

• All the above

• None of the above

Which end user category thoroughly familiarize themselves with DBMS to implement their own applications to meet their requirements?

• Standalone users

• Sophisticated users

• Naive or parametric user

• Casual users