Database Section 1 Quiz

What is the difference between "information" and "data"? -Information and data have no differences - they are two words for the same thing. -Information is held and understood only by users. -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.

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

A DBMS comprises of the following elements: (Choose 3) -Memory and Storage Management -Client -Data Dictionary -Query language

-Memory and Storage Management -Data Dictionary -Query language

In a hierarchical database model the data is stored as records that are connected to one another through ________. -links -primary keys -fields -databases

-links

Today, all industries have a need for database systems. True or False?

true

When completing the conceptual modeling process we must take into account the following: -Business Rules -Assumptions -Problems -All of the above

-All of the above

A database interacts with the data and provides the following facilities: -Retrieving data -Inserting data -Deleting data -All of the above.

-All of the above.

T/F: Information is the result of combining, comparing and performing calculations on data.

True

SQL *Plus is being used in the Oracle Academy courses to run SQL code. True or False?

false

The Oracle Academy courses are intended for self study. True or False?

false

Which of the following transformations in computing led to the increase in graphical user interface (GUI) applications? -Mainframe computing -Client/Server Computing -Grid Computing -Desktop computing

-Desktop computing

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

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

In a _______ database model the data is organized into a tree-like structure and to retrieve data the whole tree needs to be traversed starting from the root node. -Relational -Object Oriented -Hierarchical -Network

-Hierarchical

Business ______ are used to understand business processes, and the nature, role, and scope of the data. -Processes -Mission Statements -Rules -Goals

-Rules

Which is the first step in the Database Development Process ? -Build -Testing -Design -Strategy and Analysis

-Strategy and Analysis

Business rules are important because_________. -They can all be incorporated into the database design structure. -They can become outdated quickly. -They allow the developer to understand the relationship and constraints of the participating entities -They are complex and difficult to understand.

-They allow the developer to understand the relationship and constraints of the participating entities

Business rules help you understand the standardization procedure an organization follows when handling huge data. (t/f)

true

In the relational database model, each table name must be unique. The column names in the table must be unique too. You can have two different tables that have column names that are the same. (t/f)

true