Database basics_X_21_22

Database basics_quiz1_2021_22

Lets revise the basic database concept covered so far

Multiple Choice

What is the primary key in this database?

• Emp_Id
• Last Name
• Gender
• Title

Multiple Choice

What is database?

• Collection of organized data that allows access, retrieval of  that data.
• Collection of organized data that allows access, retrieval, and use of  that data.
• Collection of organized data that allows retrieval, and use of  that data.

Multiple Choice

Which software is used to store and manage database?

• OpenOffice Writer

• OpenOffice Calc

• OpenOffice Database

• None of the above

Multiple Choice

"In a college database, each department that need the students' information accesses it from the same set of data."

This statement is referring to __________________ concept.

• data integrity

• data redundancy

• normalization

• data centralization

Multiple Choice

Two students take the same course, but two different course names appear in a database that refers to the same course. This mistake is known as ______________.

• data integrity

• data redundancy

• data inconsistency

• data centralization

Multiple Choice

What are the two views that you can use when putting data in Access?

• Datasheet View and Design View
• Column View and Row View
• Field View and Record View

Multiple Choice

The restrictions or conditions applied on data are known as ______________

• Constraints

• Key word

• Scheme

• Term

Multiple Choice

What is data integrity

• It is the data contained in database that is not redundant

• It is the data contained in database that is accurate and consistant

• It is the data contained in database that is secured

• It is the data contained in database that is shared

Multiple Choice

What is refined data

• Knowledge

• Information

• Statistics

• None

Multiple Choice

A relational database developer refers to a record as

• Criteria

• a relation

• a tuple

• an attribute

Multiple Select

Characteristics of a flat file database( Mark 3 options)

• Records stored in one place

• High possibility for redundancy

• Performs complex queries

• Easy to update

• Better for small amount of data

Multiple Choice

How many records are shown here?

• 5

• 7

• 11

• 35

Multiple Choice

How many fields are shown here?

• 5

• 7

• 11

• 35

Multiple Choice

A RDBMS is responsible for

• creating tables and linking them together

• adding data inside the database

• Modify or delete existing data

• all of the listed answers

Multiple Choice

When Using Paper Manual Database

• Paper Files Can get lost

• You can easily Find the file you are looking for

• you can easily sort file alphabetically

• you can make easily make changes

Multiple Choice

An advantage of a computerized database is that

• You can query it and obtain specific data that is relevant to your requirements

• You can enter lots and lots of data and never run out of space

• Anybody can access the data and use it

• It's easy to use and you never need to worry about it again

Multiple Choice

Primary key is

• A field that uniquely identifies each
  field in a file.
• A field that uniquely identifies each
  record in a file.
• A record that uniquely identifies each
  record in a file.
• A record that uniquely identifies each
  field in a file.

Multiple Choice

 Juan needs to create a database of all his friends. In a table, what is all the information about one friend considered?   

•   Field 
•  Record
•  Table
•   Entry

Multiple Choice

Robert needs to create a database of all his friends. In a table, is what last name considered?

• Field

• Record

• Table

• Cell Address

Multiple Choice

Repetition of data is called data ..............

• dependance

• redundancy

• inconsistency

• isolation