Answer Oracle Design Quiz Section 1

Section 1 Quiz
                (Answer all questions in this section)

1.            A specialized type of software, which controls and manages the hardware in a computer system.             Mark for Review
(1) Points
                Operating System (*)
                Hardware
                Software
                Client

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

3.            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 (*)

4.            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)    
                GUI software (*)
                Internet Browser software (*)
                Operating System software (*)
                Server software

5.            Software cannot operate without Hardware. True or False?        Mark for Review
(1) Points
                True (*)
                False

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

7.            Information which was gained from data is the same as: (Choose Two)  Mark for Review
(1) Points
                                                (Choose all correct answers)    
                Intelligence (*)
                There is no difference between data and information.
                Raw Materials
                Knowledge (*)

8.            Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information?      Mark for Review
(1) Points
                Data (*)
                Information
                Both
                Neither

9.            Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?            Mark for Review
(1) Points
                True (*)
                False

10.          The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False?                Mark for Review
(1) Points
                True (*)
                False

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

12.          Which of the following represents the correct sequence of steps in the Database Development Process?                Mark for Review
(1) Points
                Design, Build, Analyze
                Analyze, Build, Design
                Analyze, Design, Build (*)
                Build, Analyze, Design

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

14.          The main subject areas taught by the Oracle Academy are:          Mark for Review
(1) Points
                Systems programming and computer architecture
                Database performance tuning
                Computer Repairs
                Data Modeling, SQL, and PL/SQL (*)

15.          The demand for Information Technology professionals in today's market is increasing. True or False?      Mark for Review
(1) Points
                True (*)
                False

1.            The demand for Information Technology professionals in today's market is increasing. True or False?      Mark for Review
(1) Points
                True (*)
                False

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

3.            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. The only requirement for creating a perfect system is a perfect programmer.

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

4.            In the grid computing model, resources are pooled together for efficiency. True or False?            Mark for Review
(1) Points
                True (*)
                False

5.            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)    
                Operating System software (*)
                Server software
                GUI software (*)
                Internet Browser software (*)

6.            A specialized type of software, which controls and manages the hardware in a computer system.             Mark for Review
                Software
                Hardware
                Operating System (*)
                Client

7.            Software cannot operate without Hardware. True or False?        Mark for Review
(1) Points
                True (*)
                False

8.            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 (*)

9.            Information which was gained from data is the same as: (Choose Two)  Mark for Review
(1) Points
                                                (Choose all correct answers)    
                Knowledge (*)
                There is no difference between data and information.
                Intelligence (*)
                Raw Materials

10.          Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information?      Mark for Review
(1) Points
                Data (*)
                Information
                Both
                Neither

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

12.          Every time you shop online, it is likely you will be accessing a database. True or False?    Mark for Review
(1) Points
                True (*)
                False

13.          The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False?                Mark for Review
                True (*)
                False

14.          Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?            Mark for Review
(1) Points
                True (*)
                False

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

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

2.            Every time you shop online, it is likely you will be accessing a database. True or False?    Mark for Review
(1) Points
                True (*)
                False

3.            The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False?                Mark for Review
(1) Points
                True (*)
                False

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

5.            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
                True. The only requirement for creating a perfect system is a perfect programmer.

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

                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.

6.            The main subject areas taught by the Oracle Academy are:          Mark for Review
(1) Points
                Data Modeling, SQL, and PL/SQL (*)
                Systems programming and computer architecture
                Computer Repairs
                Database performance tuning

7.            The demand for Information Technology professionals in today's market is increasing. True or False?      Mark for Review
(1) Points
                True (*)
                False

8.            Which term describes the physical components of a computer system? Mark for Review
(1) Points
                Hardware (*)
                Operating System
                Software
                Client

9.            Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No?
In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online.

In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online.

In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message.

 Mark for Review
(1) Points
                No
                Yes (*)

10.          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 clothing store (*)
                Online personal web page
                Online book store (*)
                Online personal shopping service (*)

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

12.          Businesses involved in any of the following typically use databases to handle their data: Finance, Logistics, Commerce, Procurement, and Distribution? True or False?          Mark for Review
(1) Points
                True (*)
                False

13.          What is the difference between "information" and "data"?         Mark for Review
(1) Points
                Information is held and understood only by users.
                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. (*)

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

15.          Information which was gained from data is the same as: (Choose Two)  Mark for Review
(1) Points
                                                (Choose all correct answers)    
                Knowledge (*)
                There is no difference between data and information.
                Intelligence (*)
                Raw Materials

1.            The main subject areas taught by the Oracle Academy are:          Mark for Review
(1) Points
                Computer Repairs
                Systems programming and computer architecture
                Database performance tuning
                Data Modeling, SQL, and PL/SQL (*)

2.            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
                True. Users never know what they want anyway, so building systems is best left to the professionals.

                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. The only requirement for creating a perfect system is a perfect programmer.

3.            The demand for Information Technology professionals in today's market is increasing. True or False?      Mark for Review
(1) Points
                True (*)
                False

4.            Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information?      Mark for Review
(1) Points
                Data (*)
                Information
                Both
                Neither

5.            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 (*)

6.            What is the difference between "information" and "data"?         Mark for Review
(1) Points
                Information and data have no differences - they are two words for the same thing.
                Data is held and understood only by users.

                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.

7.            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 (*)

8.            Entities are transformed into Tables during the Database Design process. True or False?                Mark for Review
(1) Points
                True (*)
                False

9.            Every time you shop online, it is likely you will be accessing a database. True or False?    Mark for Review
(1) Points
                True (*)
                False

10.          Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?            Mark for Review
(1) Points
                True (*)
                False

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

12.          Software cannot operate without Hardware. True or False?        Mark for Review
(1) Points
                True (*)
                False

13.          In the grid computing model, resources are pooled together for efficiency. True or False?            Mark for Review
(1) Points
                True (*)
                False

14.          Which of the following are examples of e-businesses that use database software?          Mark for Review
(1) Points
                                                (Choose all correct answers)    
                Online personal shopping service (*)
                Online personal web page
                Online clothing store (*)
                Online research paper
                Online book store (*)

15.          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 (*)
                Server software
                GUI software (*)
                Operating System software (*)

1.            What is the difference between "information" and "data"?         Mark for Review
(1) Points
                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. (*)

                Data is held and understood only by users.
                Information and data have no differences - they are two words for the same thing.

2.            How do you turn "data" into "information"?        Mark for Review
(1) Points
                By testing it
                By storing it on a server
                By storing it in a database
                By querying it or accessing it (*)

3.            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 (*)

4.            Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?            Mark for Review
(1) Points
                True (*)
                False

5.            Every time you shop online, it is likely you will be accessing a database. True or False?    Mark for Review
(1) Points
                True (*)
                False

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

7.            Most of the well known Internet search engines use databases to store data. True or False?       Mark for Review
(1) Points
                True (*)
                False

8.            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
                True. Users delay the delivery of a system by changing their minds and adding new requirements.

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

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

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

9.            The main subject areas taught by the Oracle Academy are:          Mark for Review
(1) Points
                Data Modeling, SQL, and PL/SQL (*)
                Database performance tuning
                Computer Repairs
                Systems programming and computer architecture

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

11.          Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No?
In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online.

In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online.

In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message.

 Mark for Review
(1) Points
                No
                Yes (*)

12.          In the grid computing model, resources are pooled together for efficiency. True or False?            Mark for Review
(1) Points
                True (*)
                False

13.          Which of the following are examples of e-businesses that use database software?          Mark for Review
(1) Points
                                                (Choose all correct answers)    
                Online personal web page
                Online clothing store (*)
                Online personal shopping service (*)
                Online research paper
                Online book store (*)

14.          Software cannot operate without Hardware. True or False?        Mark for Review
(1) Points
                True (*)
                False

15.          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 (*)

1. There is a big increase in demand for Information Technology professionals in today’s market. True or False?
True
False

2. Why is it important to identify the business requirements before beginning to program a new system?
It is not important to have a blueprint for database design and programs. You should just start coding as soon as possible, so you can meet your deadlines.
It clarifies what a business wants to accomplish, so that you can get your database design and coding started correctly.
It allows application development to be conducted without having to consider database design.
It keeps businesses honest.

3. What are the major content areas covered in the Oracle Academy?
Database programming and Computer repair.
Database configuration and performance tuning.
Data Modeling, SQL, and PL/SQL
Data Modeling, PJava and C+

Test: Quiz: Data vs Information
1. How do you turn “data” into “information”
By testing it
By querying it or accessing it
By storing it on a server
By storing it in a database

2. Which of the following are examples of data vs. information.
A. Student age vs. average age of all students in class
B. Bank deposit amount vs. total account balance
C. Winning time for a race vs. length of race
D. Price of computer vs. total sales of all computers for a company
E. Both A and B

3. Consider an example where an Oracle database works “behind the scenes” for common internet activity. Which of the following best describes a database transaction?
A person searching an airline website to find all available fares for a flight.
A business identifies what processes it uses for purchasing inventory.
A student places a link to their homepage from the school’s website.
A person looking in the newspaper for good internet sites.

4. What are the results of having all your data in one central location?
Improved performance
Easier access to data
Updates are harder to execute
Decreased performance

Test: Quiz: History of the Database
1. Oracle was one of the first relational database systems available commercially? True or False?
True
False

2. Which of the following is the correct order for the Database Development Process?
Strategy, Analysis, Design, Build
Analysis, Strategy, Design, Build
Build, Strategy, Analysis, Design
Design, Build, Strategy, Analysis

3. Data Modeling is the last stage in the development of a database. True or False?
True
False

Test: Quiz: Major Transformations in Computing
1. Personal computers (PCs) have been in existence since 1950. True or False?
True
False

2. Which of the following is NOT a type of database?
Hierarchical
Relational
SQL
Network

3. Databases function more efficiently as:
Multiple applications on multiple client-servers
Integrated software on fast processing servers
Client-based software on client-servers
Client-based software on personal computers

4. Users would use which of the following software to access essential business applications?
GUI Interface
Internet Browser
Server
Operating System

5. In the grid computing model, resources are pooled together for efficiency. True or False?
True
False