DATABASE DESIGN ENGLISH SECTION 1 QUIZ

1. Data Modeling is the last step in the database development process. True or False? Mark for Review
(1) Points


True


False (*)



Incorrect Incorrect. Refer to Section 1 Lesson 3.


2. Oracle was one of the first relational database systems available commercially. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


3. SQL became the most commonly used query language in the 1980s. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


4. Which of the following represents the correct sequence of steps in the Database Development Process? Mark for Review
(1) Points


Analyze, Build, Design


Design, Build, Analyze


Build, Analyze, Design


Analyze, Design, Build (*)



Correct Correct


5. Which term describes the physical components of a computer system? Mark for Review
(1) Points


Client


Operating System


Software


Hardware (*)



Correct Correct
6. The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network. Mark for Review
(1) Points


True


False (*)



Correct Correct


7. Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review
(1) Points

(Choose all correct answers)


Internet Browser software (*)


GUI software (*)


Operating System software (*)


Server software



Correct Correct


8. Which of the following are examples of e-businesses that use database software? Mark for Review
(1) Points

(Choose all correct answers)


Online research paper


Online personal shopping service (*)


Online book store (*)


Online personal web page


Online clothing store (*)



Correct Correct


9. Personal computers (PCs) have been in existence since 1950. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


10. Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information? Mark for Review
(1) Points


Data


Information (*)


Both


Neither



Incorrect Incorrect. Refer to Section 1 Lesson 2.
11. Which of the following are examples of data becoming information: Mark for Review
(1) Points


A. Student age -> average age of all students in class


B. Bank deposit amount -> total account balance


C. Winning time for a race -> length of race


D. Price of a computer -> total sales of all computers for a company


E. A, B, and D (*)



Correct 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.


Information is held and understood only by users.


Data turns into useful information. It is stored in a database and accessed by systems and users. (*)



Correct Correct


13. The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


14. Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want. Mark for Review
(1) Points


False. Business requirements can and will change. For instance new legal requirements may arise. (*)


True. Users delay the delivery of a system by changing their minds and adding new requirements.


True. Users never know what they want anyway, so building systems is best left to the professionals.


True. The only requirement for creating a perfect system is a perfect programmer.



Correct Correct


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


Database performance tuning


Systems programming and computer architecture


Computer Repairs


Data Modeling, SQL, and PL/SQL (*)



Correct Correct