• Author / Uploaded
• Evi Lindra

Citation preview

Test: DFo Section 1 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1 (Answer all questions in this section)

1. The main subject areas taught by the Oracle Academy are: Mark for Review

(1) Points Computer Repairs Database performance tuning Data Modeling, SQL, and PL/SQL (*) Systems programming and computer architecture Correct 2. The technical software requirements for this course include all of the following except: Mark for Review

(1) Points Oracle SQL Developer Data Modeler Microsoft Access (*) Oracle APEX application All are requirements. Correct 3. A network database comprises of a collection of records connected to one another through links. Mark for Review

(1) Points True (*) False Correct

4. The advantages of an object-oriented data model are: Mark for Review

(1) Points Reduced Maintenance Real-World Modeling Both A and B. (*) Neither A or B. Correct 5. In the relational database model, each table name must be unique. The column names in the table must be unique too. You can have two different tables that have column names that are the same. Mark for Review

(1) Points True (*) False Correct

Section 1 (Answer all questions in this section)

6. In a hierarchical database model the data is stored as records that are connected to one another through ________. Mark for Review

(1) Points fields primary keys databases links (*) Correct 7. The reason or drive for using databases rather than files has been … (Choose 3) Mark for Review

(1) Points Reduced redundancy of data(*) Integration of data for easier access and modification for complex transactions (*) Availability of data to a diverse set of users(*) Use of blocks

Correct

8. If information requirements are clearly communicated during conceptual modeling the following will result: Mark for Review

(1) Points Delays due to reworking model caused by incorrect assumptions A well designed conceptual model (*) Some business rules may not be taken into account A conceptual model that does not fully reflect the business will be created. Correct 9. Business rules are important because_________. Mark for Review

(1) Points They can all be incorporated into the database design structure. They are complex and difficult to understand. They allow the developer to understand the relationship and constraints of the participating entities (*) They can become outdated quickly. Correct 10. When completing the conceptual modeling process we must take into account the following: Mark for Review

(1) Points Business Rules

Assumptions Problems All of the above (*) Correct

Section 1 (Answer all questions in this section)

11. Using a database solution instead of a flat file eliminates all of the following issues except: Mark for Review

(1) Points Inconsistency Redundancy Data entry anomalies Incorrect data (*) Correct 12. What is the difference between "information" and "data"? Mark for Review

(1) Points Data is held and understood only by users. Information and data have no differences - they are two words for the same thing. Data turns into useful information. It is stored in a database and accessed by systems and users. (*) Information is held and understood only by users. Correct 13. The transformations that have occurred in the computing world progressing in this order: Mark for Review

(1) Points

Mainframe Computing, Desktop Computing, Grid Computing, Client/Server Computing. Grid Computing, Desktop Computing, Mainfram Computing, Client/Server Computing Desktop computing, Grid computing, Client/Server computing, Mainframe computing. Mainframe computing, Desktop computing, Client/Server Computing, Grid computing. (*) Correct 14. A DBMS comprises of the following elements: (Choose 3) Mark for Review

(1) Points Query language(*) Data Dictionary(*) Client Memory and Storage Management(*)

Correct

15. Which of the following transformations in computing led to the increase in graphical user interface (GUI) applications? Mark for Review

(1) Points Grid Computing Desktop computing (*) Client/Server Computing Mainframe computing Correct