Section 1 Quiz Database Design Oracle (2022)

Section 1 Quiz Database Design Oracle

Section 1 Quiz

(Answerall questions in this section)

1. Aspecialized type of software, which controls and manages the hardware in acomputer system. Mark forReview

(1) Points

OperatingSystem (*)

Hardware

Software

Client

2. Personalcomputers (PCs) have been in existence since 1950. True or False? Mark for Review

(1) Points

True

False(*)

3. Theoverall mission of the Oracle Corporation is to use the internet and fastprocessing servers to build its own network. Mark for Review

(1) Points

True

False(*)

4. Userscould directly interact with which of the following software to accessessential business applications? (Choose three) Mark for Review

(1) Points

(Chooseall correct answers)

GUIsoftware (*)

InternetBrowser software (*)

OperatingSystem software (*)

Serversoftware

5. Softwarecannot operate without Hardware. True or False? Mark for Review

(1) Points

True(*)

False

6. Consideryour school library. It will have a database with transaction details of thebooks that are borrowed by students. Is the total number of books out on loanin one given month considered Data or Information? Mark for Review

(1) Points

Data

Information(*)

Both

Neither

7. Informationwhich was gained from data is the same as: (Choose Two) Mark for Review

(1) Points

(Chooseall correct answers)

Intelligence(*)

Thereis no difference between data and information.

RawMaterials

Knowledge(*)

8. Consideryour school library. It will have a database with transaction details of thebooks that are borrowed by students. Is a detail of one student borrowing onebook considered Data or Information? Mark for Review

(1) Points

Data(*)

Information

Both

Neither

9. Databasesare used in most countries and by most governments. Life, as we know it, wouldchange drastically if we no longer had access to databases. True or False? Mark for Review

(1) Points

True(*)

False

10. Thework of E.F. Codd in the early 1970s led to the development of Relationaldatabases. True or False? Mark for Review

(1) Points

True(*)

False

11. SQLbecame the most commonly used query language in the 1980s. True or False? Mark for Review

(1) Points

True(*)

False

12. Whichof the following represents the correct sequence of steps in the DatabaseDevelopment Process? Markfor Review

(1) Points

Design,Build, Analyze

Analyze,Build, Design

Analyze,Design, Build (*)

Build,Analyze, Design

13. Themarket for IT professionals is still increasing and will continue to do so inthe future as the world gets ever more dependent on computer systems. True orFalse? Mark for Review

(1) Points

True(*)

False

14. Themain subject areas taught by the Oracle Academy are: Mark for Review

(1) Points

Systemsprogramming and computer architecture

Databaseperformance tuning

ComputerRepairs

DataModeling, SQL, and PL/SQL (*)

15. Thedemand for Information Technology professionals in today's market isincreasing. True or False? Mark forReview

(1) Points

True(*)

(Video) Oracle Academy DFO Section 1 Quiz ( Database Course) Database Foundation SECTION 1 #IT #Unversity

False

1. Thedemand for Information Technology professionals in today's market isincreasing. True or False? Mark forReview

(1) Points

True(*)

False

2. Themarket for IT professionals is still increasing and will continue to do so inthe future as the world gets ever more dependent on computer systems. True orFalse? Mark for Review

(1) Points

True(*)

False

3. Onceyou have learned how to write programs and build systems, you no longer needany input or involvement from any users as you are perfectly capable ofdelivering the systems that businesses need and want. Mark for Review

(1) Points

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

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

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

4. In thegrid computing model, resources are pooled together for efficiency. True orFalse? Mark for Review

(1) Points

True(*)

False

(1) Points

(Chooseall correct answers)

OperatingSystem software (*)

Serversoftware

GUIsoftware (*)

InternetBrowser software (*)

6. Aspecialized type of software, which controls and manages the hardware in acomputer system. Mark forReview

Software

Hardware

OperatingSystem (*)

Client

7. Softwarecannot operate without Hardware. True or False? Mark for Review

(1) Points

True(*)

False

8. Theoverall mission of the Oracle Corporation is to use the internet and fastprocessing servers to build its own network. Mark for Review

(1) Points

True

False(*)

9. Informationwhich was gained from data is the same as: (Choose Two) Mark for Review

(1) Points

(Chooseall correct answers)

Knowledge(*)

Thereis no difference between data and information.

Intelligence(*)

RawMaterials

10. Consider your school library. It willhave a database with transaction details of the books that are borrowed bystudents. Is a detail of one student borrowing one book considered Data orInformation? Mark for Review

(1) Points

Data(*)

Information

Both

Neither

11. Consider your school library. It willhave a database with transaction details of the books that are borrowed bystudents. Is the total number of books out on loan in one given monthconsidered Data or Information? Mark for Review

(1) Points

Data

Information(*)

Both

Neither

12. Every time you shop online, it is likelyyou 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 1970sled to the development of Relational databases. True or False? Mark for Review

True(*)

False

14. Databases are used in most countries andby most governments. Life, as we know it, would change drastically if we nolonger had access to databases. True or False? Mark for Review

(1) Points

True(*)

False

15. SQL became the most commonly used querylanguage in the 1980s. True or False? Mark for Review

(1) Points

True(*)

False

1. DataModeling is the last step in the database development process. True or False? Mark for Review

(1) Points

True

False(*)

2. Everytime you shop online, it is likely you will be accessing a database. True orFalse? Mark for Review

(Video) live taking quiz database design (dd)01 on oracle academy | subathon ap programming

(1) Points

True(*)

False

3. Thework of E.F. Codd in the early 1970s led to the development of Relationaldatabases. True or False? Mark for Review

(1) Points

True(*)

False

4. Oraclewas one of the first relational database systems available commercially. Trueor False? Mark for Review

(1) Points

True(*)

False

5. Onceyou have learned how to write programs and build systems, you no longer needany input or involvement from any users as you are perfectly capable ofdelivering 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 theprofessionals.

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

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

6. Themain subject areas taught by the Oracle Academy are: Mark for Review

(1) Points

DataModeling, SQL, and PL/SQL (*)

Systemsprogramming and computer architecture

ComputerRepairs

Databaseperformance tuning

7. Thedemand for Information Technology professionals in today's market isincreasing. True or False? Mark forReview

(1) Points

True(*)

False

8. Whichterm describes the physical components of a computer system? Mark for Review

(1) Points

Hardware(*)

OperatingSystem

Software

Client

9. Changesin computing have affected many of our day-to-day activities. Are all of thefollowing activities examples of this change? Yes or No?

In the past you used to use the phone system to calldirectory assistance to get a phone number. Today you can use your PC to lookup a phone number online.

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

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

Mark for Review

(1) Points

Yes(*)

10. Which of the following are examples ofe-businesses that use database software? Mark for Review

(1) Points

(Chooseall correct answers)

Onlineresearch paper

Onlineclothing store (*)

Onlinepersonal web page

Onlinebook store (*)

Onlinepersonal shopping service (*)

11. Personal computers (PCs) have been inexistence since 1950. True or False? Mark for Review

(1) Points

True

False(*)

12. Businesses involved in any of thefollowing 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

Informationis held and understood only by users.

Datais held and understood only by users.

Informationand data have no differences - they are two words for the same thing.

Dataturns into useful information. It is stored in a database and accessed bysystems and users. (*)

14. Consider your school library. It willhave a database with transaction details of the books that are borrowed bystudents. Is the total number of books out on loan in one given monthconsidered Data or Information? Mark for Review

(1) Points

Data

Information(*)

Both

Neither

15. Information which was gained from datais the same as: (Choose Two) Mark forReview

(1) Points

(Chooseall correct answers)

Knowledge(*)

Thereis no difference between data and information.

Intelligence(*)

RawMaterials

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

(1) Points

ComputerRepairs

(Video) Tutorial Mengerjakan Quiz & Test di Oracle Academy - Database Programming

Systemsprogramming and computer architecture

Databaseperformance tuning

DataModeling, SQL, and PL/SQL (*)

2. Onceyou have learned how to write programs and build systems, you no longer needany input or involvement from any users as you are perfectly capable ofdelivering 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 theprofessionals.

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

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

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

3. Thedemand for Information Technology professionals in today's market isincreasing. True or False? Mark forReview

(1) Points

True(*)

False

4. Consideryour school library. It will have a database with transaction details of thebooks that are borrowed by students. Is a detail of one student borrowing onebook considered Data or Information? Mark for Review

(1) Points

Data(*)

Information

Both

Neither

5. Whichof 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. Whatis the difference between "information" and "data"? Mark for Review

(1) Points

Informationand data have no differences - they are two words for the same thing.

Datais held and understood only by users.

Dataturns into useful information. It is stored in a database and accessed bysystems and users. (*)

Informationis held and understood only by users.

7. Whichof the following represents the correct sequence of steps in the DatabaseDevelopment Process? Markfor Review

(1) Points

Analyze,Build, Design

Design,Build, Analyze

Build,Analyze, Design

Analyze,Design, Build (*)

8. Entitiesare transformed into Tables during the Database Design process. True or False? Mark for Review

(1) Points

True(*)

False

9. Everytime you shop online, it is likely you will be accessing a database. True orFalse? Mark for Review

(1) Points

True(*)

False

10. Databases are used in most countries andby most governments. Life, as we know it, would change drastically if we nolonger had access to databases. True or False? Mark for Review

(1) Points

True(*)

False

11. Personal computers (PCs) have been inexistence since 1950. True or False? Mark for Review

(1) Points

True

False(*)

12. Software cannot operate withoutHardware. True or False? Mark forReview

(1) Points

True(*)

False

13. In the grid computing model, resourcesare pooled together for efficiency. True or False? Mark for Review

(1) Points

True(*)

False

14. Which of the following are examples ofe-businesses that use database software? Mark for Review

(1) Points

(Chooseall correct answers)

Onlinepersonal shopping service (*)

Onlinepersonal web page

Onlineclothing store (*)

Onlineresearch paper

Onlinebook store (*)

15. Users could directly interact with whichof the following software to access essential business applications? (Choosethree) Mark for Review

(1) Points

(Chooseall correct answers)

InternetBrowser software (*)

Serversoftware

GUIsoftware (*)

OperatingSystem software (*)

1. Whatis the difference between "information" and "data"? Mark for Review

(Video) DD Database Design Final Exam on oracle academy

(1) Points

Informationis held and understood only by users.

Dataturns into useful information. It is stored in a database and accessed bysystems and users. (*)

Datais held and understood only by users.

Informationand data have no differences - they are two words for the same thing.

2. How doyou turn "data" into "information"? Mark for Review

(1) Points

Bytesting it

Bystoring it on a server

Bystoring it in a database

Byquerying it or accessing it (*)

3. Whichof 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. Databasesare used in most countries and by most governments. Life, as we know it, wouldchange drastically if we no longer had access to databases. True or False? Mark for Review

(1) Points

True(*)

False

5. Everytime you shop online, it is likely you will be accessing a database. True orFalse? Mark for Review

(1) Points

True(*)

False

6. Oraclewas one of the first relational database systems available commercially. Trueor False? Mark for Review

(1) Points

True(*)

False

7. Mostof the well known Internet search engines use databases to store data. True orFalse? Mark for Review

(1) Points

True(*)

False

8. Onceyou have learned how to write programs and build systems, you no longer needany input or involvement from any users as you are perfectly capable ofdelivering 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 newrequirements.

False.Business requirements can and will change. For instance new legal requirementsmay 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 theprofessionals.

9. Themain subject areas taught by the Oracle Academy are: Mark for Review

(1) Points

DataModeling, SQL, and PL/SQL (*)

Databaseperformance tuning

ComputerRepairs

Systemsprogramming and computer architecture

10. The market for IT professionals is stillincreasing and will continue to do so in the future as the world gets ever moredependent on computer systems. True or False? Mark for Review

(1) Points

True(*)

False

11. Changes in computing have affected manyof our day-to-day activities. Are all of the following activities examples ofthis change? Yes or No?

In the past you used to use the phone system to calldirectory assistance to get a phone number. Today you can use your PC to lookup a phone number online.

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

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

Mark for Review

(1) Points

No

Yes(*)

12. In the grid computing model, resourcesare pooled together for efficiency. True or False? Mark for Review

(1) Points

True(*)

False

13. Which of the following are examples ofe-businesses that use database software? Mark for Review

(1) Points

(Chooseall correct answers)

Onlinepersonal web page

Onlineclothing store (*)

Onlinepersonal shopping service (*)

Onlineresearch paper

Onlinebook store (*)

14. Software cannot operate withoutHardware. True or False? Mark forReview

(1) Points

True(*)

False

15. The overall mission of the OracleCorporation is to use the internet and fast processing servers to build its ownnetwork. Mark for Review

(1) Points

True


FAQs

What is the difference between information and data Oracle answer? ›

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

Which is the first step in the database development process Oracle? ›

The first step is requirements gathering. During this step, the database designers have to interview the customers (database users) to understand the proposed system and obtain and document the data and functional requirements.

Which is the first step in the database development process testing build design strategy and analysis? ›

  1. Planning/Preliminary Investigation: This is the first phase of the systems development process. ...
  2. Systems Analysis and Requirements. The system analysis includes a review of the existing procedures and information flow. ...
  3. Systems Design: ...
  4. Implementation: ...
  5. Testing & Integration: ...
  6. Maintenance:

How do you turn data into information Oracle Academy? ›

How do you turn "data" into "information"? By querying it or accessing it. Consider an example where an Oracle database works "behind the scenes" for common internet activity.

What are the 4 types of database? ›

A relational database management system is one of four common types of systems you can use to manage your business data.
...
The other three include:
  • hierarchical database systems.
  • network database systems.
  • object-oriented database systems.

Why is Oracle Database so popular? ›

The high market share and the top position of the Oracle Database are because it runs on most major platforms and supports multiple operating systems. Some major platforms where you can run Oracle DB include UNIX, Linux, Windows, and macOS.

Videos

1. Exam Management System Database Design Tutorial
(Thesis and Capstone Helper)
2. CS281 - Lab 5 - Section 1 - Spring 2021
(sina5an)
3. CS405 Database Programming Using Oracle Quiz No 1
(Danish Kada)
4. Oracle Academy DFo Section 2 Quiz ( Database Course) Database Foundation SECTION 2 #IT #Unversity
(J got Da idea;)
5. Databases: Quiz database design
(Roel Van de Paar)
6. ORACLE Databases for Developers: Foundations: Module 11 Week 11 Quiz 1-4 solution (DEV GYM)
(Learning With COURSERA)

Top Articles

Latest Posts

Article information

Author: Prof. Nancy Dach

Last Updated: 11/15/2022

Views: 6569

Rating: 4.7 / 5 (57 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Prof. Nancy Dach

Birthday: 1993-08-23

Address: 569 Waelchi Ports, South Blainebury, LA 11589

Phone: +9958996486049

Job: Sales Manager

Hobby: Web surfing, Scuba diving, Mountaineering, Writing, Sailing, Dance, Blacksmithing

Introduction: My name is Prof. Nancy Dach, I am a lively, joyous, courageous, lovely, tender, charming, open person who loves writing and wants to share my knowledge and understanding with you.