Oracle Database Quiz Section 1 Quiz Answer
Image Source : dqindia.com |
- A specialized type of software, which
controls and manages the hardware in a computer system.
Operating System (*)
Hardware
Software
Client
- Personal computers (PCs) have been in
existence since 1950. True or False?
True
False (*)
- The overall mission of the Oracle
Corporation is to use the internet and fast processing servers to build
its own network.
True
False (*)
- 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
- Software cannot operate without Hardware.
True or False?
True (*)
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 was gained from data is
the same as: (Choose Two)
Intelligence (*)
There is no difference between data and information.
Raw Materials
Knowledge (*)
- 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
- 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 (*)
False
- The work of E.F. Codd in the early 1970s led
to the development of Relational databases.
True (*)
False
- SQL became the most commonly used query
language in the 1980s. True or False?
True (*)
False
- 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
- 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 (*)
False
- 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 (*)
- The demand for Information Technology
professionals in today's market is increasing.
True (*)
False
1. The demand for Information
Technology professionals in today's market is increasing.
True (*)
False
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 (*)
False
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.
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. (*)
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?
True (*)
False
True (*)
False
5. Users could directly interact
with which of the following software to access essential business applications?
(Choose three)
Operating System software (*)
Server software
GUI software (*)
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.
Software
Hardware
Operating System (*)
Client
Software
Hardware
Operating System (*)
Client
7. Software cannot operate without
Hardware. True or False?
True (*)
False
True (*)
False
8. The overall mission of the
Oracle Corporation is to use the internet and fast processing servers to build
its own network.
True
False (*)
True
False (*)
9. Information which was gained
from data is the same as: (Choose Two)
Knowledge (*)
There is no difference between data and information.
Intelligence (*)
Raw Materials
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?
Data (*)
Information
Both
Neither
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?
Data
Information (*)
Both
Neither
Data
Information (*)
Both
Neither
12. Every time you shop online, it
is likely you will be accessing a database. True or False?
True (*)
False
True (*)
False
13. The work of E.F. Codd in the
early 1970s led to the development of Relational databases. True or False?
True (*)
False
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?
True (*)
False
True (*)
False
15. SQL became the most commonly
used query language in the 1980s. True or False?
True (*)
False
True (*)
False
1.
Data
Modeling is the last step in the database development process. True or False?
True
False (*)
True
False (*)
2.
Every
time you shop online, it is likely you will be accessing a database. True or
False?
True (*)
False
True (*)
False
3.
The
work of E.F. Codd in the early 1970s led to the development of Relational databases.
True or False?
True (*)
False
True (*)
False
4.
Oracle
was one of the first relational database systems available commercially. True
or False?
True (*)
False
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.
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.
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:
Data Modeling, SQL, and PL/SQL (*)
Systems programming and computer architecture
Computer Repairs
Database performance tuning
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?
True (*)
False
True (*)
False
8.
Which
term describes the physical components of a computer system?
Hardware (*)
Operating System
Software
Client
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.
No
Yes (*)
10.
Which
of the following are examples of e-businesses that use database
software? (Choose all correct answers)
Online research paper
Online clothing store (*)
Online personal web page
Online book store (*)
Online personal shopping service (*)
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?
True
False (*)
True
False (*)
12.
Businesses
involved in any of the following typically use databases to handle their data:
Finance, Logistics, Commerce, Procurement, and Distribution?
True (*)
False
True (*)
False
13.
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. (*)
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?
Data
Information (*)
Both
Neither
Data
Information (*)
Both
Neither
15.
Information
which was gained from data is the same as: (Choose Two) (Choose all
correct answers)
Knowledge (*)
There is no difference between data and information.
Intelligence (*)
Raw Materials
Knowledge (*)
There is no difference between data and information.
Intelligence (*)
Raw Materials
1.
The
main subject areas taught by the Oracle Academy are:
Computer Repairs
Systems programming and computer architecture
Database performance tuning
Data Modeling, SQL, and PL/SQL (*)
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.
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.
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?
True (*)
False
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?
Data (*)
Information
Both
Neither
Data (*)
Information
Both
Neither
5.
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 (*)
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"?
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.
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?
Analyze, Build, Design
Design, Build, Analyze
Build, Analyze, Design
Analyze, Design, Build (*)
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?
True (*)
False
True (*)
False
9.
Every
time you shop online, it is likely you will be accessing a database. True or
False?
True (*)
False
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?
True (*)
False
True (*)
False
11.
Personal
computers (PCs) have been in existence since 1950. True or False?
True
False (*)
True
False (*)
12.
Software
cannot operate without Hardware. True or False?
True (*)
False
True (*)
False
13.
In the
grid computing model, resources are pooled together for efficiency. True or
False?
True (*)
False
True (*)
False
14.
Which
of the following are examples of e-businesses that use database
software? (Choose all correct answers)
Online personal shopping service (*)
Online personal web page
Online clothing store (*)
Online research paper
Online book store (*)
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) (Choose all correct
answers)
Internet Browser software (*)
Server software
GUI software (*)
Operating System software (*)
Internet Browser software (*)
Server software
GUI software (*)
Operating System software (*)
1.
What is
the difference between "information" and "data"?
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.
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"?
By testing it
By storing it on a server
By storing it in a database
By querying it or accessing it (*)
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:
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 (*)
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?
True (*)
False
True (*)
False
5.
Every
time you shop online, it is likely you will be accessing a database. True or
False?
True (*)
False
True (*)
False
6.
Oracle
was one of the first relational database systems available commercially. True
or False?
True (*)
False
True (*)
False
7.
Most of
the well known Internet search engines use databases to store data. True or
False?
True (*)
False
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.
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.
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:
Data Modeling, SQL, and PL/SQL (*)
Database performance tuning
Computer Repairs
Systems programming and computer architecture
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 (*)
False
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.
No
Yes (*)
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.
No
Yes (*)
12.
In the
grid computing model, resources are pooled together for efficiency. True or
False?
True (*)
False
True (*)
False
13.
Which
of the following are examples of e-businesses that use database
software?(Choose all correct answers)
Online personal web page
Online clothing store (*)
Online personal shopping service (*)
Online research paper
Online book store (*)
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?
True (*)
False
True (*)
False
15.
The
overall mission of the Oracle Corporation is to use the internet and fast
processing servers to build its own network.
True
False (*)
True
False (*)