Which of the following data storage methods is most widely used in business today?
C. Relational database system
What is metadata?
B. Data about data
Which component of a data-driven software application communicates directly with the database?
B. the database management system
Which of the following is an advantage of hierarchical database system?
D. High performance
What data sublanguage is used around the world to communicate with relational databases?
A. Java
B. CODASYL
C Visual Basic
D. SQL
D. SQL
What system component translates user requests into operating system commands that access data on disk?
C. The DBMS
In which phase of the System Development Life Cycle should a project's scope be determined?
B. The Definition Phase
What do business rules do?
D. Restrict what can be included in a database
What is the best course of action if your client's standard DBMS is not adequate for the project under consideration?
D. Tell the client why their standard DBMS will not work, and suggest one that will work
Which of the following four actions is most important in a database development project?
C. Keeping the client informed of what you are doing at every phase of the SLDC
You should make your data entry forms as similar to the forms used by the system you are replacing, to make things more comfortable for which group of stakeholders?
C. The Users
After you have interviewed all the stakeholders in a project, you should write a proposal for submission to the decision maker. What should you propose?
B. Make three proposals: a high cost one that includes everything everyone wants, a medium cost one that includes everything the stakeholders agree is important, and a low cost one that includes only those features that are unquestionably needed
In a model of company's personnel system, what would EMPLOYEE be?
C. An entity class
What is a non-unique identifier good for in a database model?
C. You can use it to identify a group records that share a common characteristic
What is the maximum cardinality of the relationship between the Web site entity class and the Web surfer entity class?
C. Many-to-many
When you are developing a system for a large industrial client, who is most likely to have an opinion on which DBMS you should use?
B. The IT Department
If you are replacing an existing system with an upgraded one, how should the new user interface look and act?
A. Very much like the old system, but with changes that make the application easier to understand and use
If a prospective client needs a new system, the development of which would require expertise that you do not have, what should you do?
B. Accept the job, then hire a subcontractor who has the required expertise
How much capacity should any system you produce possess?
D. Enough capacity to meet the client's current needs plus expanded capacity based on a best estimate of changes in the client's business that could occur
What can you ignore when calculating a project's scope?
A. The identities of the stakeholders
B. The development tools you will need for the project
C. The time it will take to complete the project
D. What it will cost
