Database Design Section 1 Quiz

Which of the following are examples of data becoming information: 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

E. A, B, and D

Software cannot operate without Hardware. True or False?

True

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?

True

The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False?

True

The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network. True or False?

False

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? - Data - Information - Both - Neither

Information

Which of the following are examples of e-businesses that use database software? - Online research paper - Online clothing store - Online personal web page - Online book store - Online personal shopping service

Online clothing store Online book store Online personal shopping service

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

Operating System

A specialized type of software, which controls and manages the hardware in a computer system. - Software - Hardware - Operating System - Client

Operating system

How do you turn "data" into "information"? - By testing it - By storing it on a server - By storing it in a database - By querying it or accessing it

By querying it or accessing it

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? - Data - Information - Both - Neither

Data

The main subject areas taught by the Oracle Academy are: - Systems programming and computer architecture - Database performance tuning - Computer Repairs - Data Modeling, SQL, and PL/SQL

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

What is the difference between "information" and "data"? - 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.

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

Which term describes the physical components of a computer system? - Hardware - Operating System - Software - Client

Hardware

Most of the well known Internet search engines use databases to store data. True or False?

True

Oracle was one of the first relational database systems available commercially. True or False?

True

SQL became the most commonly used query language in the 1980s. True or False?

True

The demand for Information Technology professionals in today's market is increasing. True or False?

True

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

Yes

Which of the following represents the correct sequence of steps in the Database Development Process? - Design, Build, Analyze - Analyze, Build, Design - Analyze, Design, Build - Build, Analyze, Design

- Analyze, Design, Build

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

- False. Business requirements can and will change. For instance, new legal requirements may arise.

Users could directly interact with which of the following software to access essential business applications? (Choose three) - GUI software - Internet Browser software - Operating System software - Server software

- GUI software - Internet Browser software - Operating System software

Information which was gained from data is the same as: (Choose Two) - Intelligence - There is no difference between data and information. - Raw Materials - Knowledge

- Intelligence - Knowledge

Data Modeling is the last step in the database development process. True or False?

False

Personal computers (PCs) have been in existence since 1950. True or False?

False

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

True

Businesses involved in any of the following typically use databases to handle their data: Finance, Logistics, Commerce, Procurement, and Distribution? True or False?

True

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?

True

Entities are transformed into Tables during the Database Design process. True or False?

True

Every time you shop online, it is likely you will be accessing a database. True or False?

True