Database Quiz 1

1. How would you find the phone number of one student from 500 names and addresses of students enrolled at your school?

Perform a search of all boys in the database

Perform a search using the student’s name as the criteria

Sort the database and scroll all records

Sort the database in descending order

Performing a search using the student's name as the criteria would be the most efficient way to find the phone number of one student from the 500 names and addresses database. This method allows for a targeted search by inputting the specific student's name, which would quickly retrieve the corresponding phone number without the need to scroll through or sort the entire database.

Explanation

Performing a search using the student's name as the criteria would be the most efficient way to find the phone number of one student from the 500 names and addresses database. This method allows for a targeted search by inputting the specific student's name, which would quickly retrieve the corresponding phone number without the need to scroll through or sort the entire database.

2. A database program replaces what piece of office equipment?

Typewriter

Photocopier

FAX machine

Filing cabinet

Ans: D Filing Cabinet – used by traditional means of storing central documents

Explanation

Ans: D Filing Cabinet – used by traditional means of storing central documents

3.

The following search was performed: "Country" = USSR or "Country" = USA How many records matched?

9

6

7

8

Ans: 7, there are seven records because the logical “or” gave a true value on querying both USA and USSR.

Explanation

Ans: 7, there are seven records because the logical “or” gave a true value on querying both USA and USSR.

4. Searching a database of North Carolina counties by using the statement, “all counties with a population of greater than two million” will include:

Counties with exactly two million people

Counties with two million or more

Counties with more than two million

Counties with less than two million

When searching a database of North Carolina counties with the statement "all counties with a population of greater than two million," it will include counties with more than two million people. This means that counties with a population of exactly two million will not be included, as they are not greater than two million. Similarly, counties with a population of less than two million will also not be included, as they do not meet the criteria of being greater than two million. Therefore, the correct answer is "Counties with more than two million."

Explanation

When searching a database of North Carolina counties with the statement "all counties with a population of greater than two million," it will include counties with more than two million people. This means that counties with a population of exactly two million will not be included, as they are not greater than two million. Similarly, counties with a population of less than two million will also not be included, as they do not meet the criteria of being greater than two million. Therefore, the correct answer is "Counties with more than two million."

5. In a database program, a set of related Information is called a:

Field

Entry

Record

Fills

Ans: C Record – this is a group of matching fields.

Explanation

Ans: C Record – this is a group of matching fields.

6. If a student sorted the following in descending order, which international capital would be first?

Moscow

Beirut

Paris

Bogota

Ans: Paris – because it has the largest letters of the alphabet sort bottom to top.

Explanation

Ans: Paris – because it has the largest letters of the alphabet sort bottom to top.

7. A field in a table that appears as a match of the primary key in another table is called a

Candidate key

Secondary Key

Foreign Key

Composite Key

A field in a table that appears as a match of the primary key in another table is called a foreign key. This is because it establishes a relationship between two tables by referencing the primary key of one table in another table. The foreign key ensures data integrity and allows for the creation of relationships between tables in a database.

Explanation

A field in a table that appears as a match of the primary key in another table is called a foreign key. This is because it establishes a relationship between two tables by referencing the primary key of one table in another table. The foreign key ensures data integrity and allows for the creation of relationships between tables in a database.

8. All of the following are examples of electronic databases except which one?

Collection of country music CDs

A CD-Rom encyclopedia

Computerized student information

Electronic Card Catalog

Music CDs are not electronic.

Explanation

Music CDs are not electronic.

9. An advantage of a database program is:

Office correspondence can be handled

All fields can be printed in a one page report

Data can be added or deleted easily

All records can be displayed at one time

A key feature of database programs is their ability to efficiently manage and manipulate data. Users can easily add new records, update existing information, and delete records as needed. This flexibility in data management is one of the fundamental advantages of using a database program.

Explanation

A key feature of database programs is their ability to efficiently manage and manipulate data. Users can easily add new records, update existing information, and delete records as needed. This flexibility in data management is one of the fundamental advantages of using a database program.

10. Which of the following is not true of database programs?

They can be viewed in different formats.

They can be used to retrieve information quickly.

They are limited to the amount of information they can hold.

They can be used by just about anybody

Ans: A - they were referring to data and not database management system in this case

Explanation

Ans: A - they were referring to data and not database management system in this case