Question 1

What's the difference between data and information

Accepted Answer

Information is organized data

Answer

Information is official, data unofficial

Answer

They are the same

Answer

Data is the information use in computers

Question 2

What is a database?

Accepted Answer

A structured repository of indexed information

Answer

Data put together

Answer

Another thing

Answer

A base of data

Question 3

An entity is...

Accepted Answer

... an object of the real world

Answer

... an information

Answer

... a database

Answer

... a corporation, like Microsoft or IBM

Question 4

An attribute is...

Accepted Answer

... a property of an entity

Answer

... a value

Answer

... an entity

Answer

... a property of a value

Question 5

What's the difference between a class and an object?

Accepted Answer

A class is abstract, an object is specific

Answer

An object is abstract, a class is specific

Answer

They are synonyms

Answer

A class may be inside an object

Question 6

In database context, what is a key?

Accepted Answer

An identifying attribute

Answer

A special entity

Answer

Something to encrypt data

Answer

A specific value

Question 7

The NULL value...

Accepted Answer

...means lack of information

Answer

...is not valid

Answer

...equals 0 or blank depending on the data type

Answer

...can be directly compared like in x = NULL

Question 8

Which is true?

Accepted Answer

An entity is represented by a table

Answer

A table only represents an entity

Answer

A table represents an attribute

Answer

Columns represent tables and Rows represent attributes

Question 9

Sort (chronologically) the models of DBMS

Accepted Answer

Hierarchical/Network/Relational/Object-Oriented

Answer

Relational/Network/Hierarchical/Object-Oriented

Answer

Hierarchical/Network/Object-Oriented/Relational

Answer

Network/Hierarchical/Relational/Object-Oriented

Question 10

Which is not a function of a DBA (database administrator)?

Accepted Answer

Design the database structures

Answer

Do periodical backups

Answer

Control the available disk space

Answer

Monitor data integrity

Question 11

Talking about database models, which is true?

Accepted Answer

The relational model has been the most used

Answer

The relational model has the structure of a tree with some relationships between nodes

Answer

The hierarchical model is no more in use

Answer

The network model is previous to the hierarchical model

Question 12

Talking about data centralization/distribution, which is not true?

Accepted Answer

The centralized model is the most used nowadays

Answer

There are many different ways of distributing data

Answer

Using Internet, distribution models use to be the bests

Answer

The client-server model may be quite similar to the centralized model

Question 13

Talking about transactions, the A of ACID stands for...

Accepted Answer

... Atomicity

Answer

... Allowance

Answer

... Affordability

Answer

... Availability

Question 14

Which are the two consequences of data distribution?

Accepted Answer

Duplication and Fragmentation

Answer

Cost and Fragmentation

Answer

Duplication and Cost

Answer

Cost and Performance

Question 15

What does DML mean?

Accepted Answer

Data Manipulation Language

Answer

Data Modeling Language

Answer

Data Minimizing Language

Answer

Data Maximizing Language

Related quizzes

Related quizzes