Database Quiz 1

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Stmonicas
S
Stmonicas
Community Contributor
Quizzes Created: 8 | Total Attempts: 46,558
| Attempts: 3,793
SettingsSettings
Please wait...
  • 1/10 Questions

    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
Please wait...
About This Quiz

This is a simple introduction to database question series that test your common knowledge. Gearing you up for CSEC IT.

Database Quiz 1 - Quiz

Quiz Preview

  • 2. 

    A database program replaces what piece of office equipment?

    • Typewriter

    • Photocopier

    • FAX machine

    • Filing cabinet

    Correct Answer
    A. Filing cabinet
    Explanation
    Ans: D Filing Cabinet – used by traditional means of storing central documents

    Rate this question:

  • 3. 
    The following search was performed: “Country” = USSR or “Country” = USA How many records matched? - ProProfs

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

    • 9

    • 6

    • 7

    • 8

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

    Rate this question:

  • 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

    Correct Answer
    A. 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."

    Rate this question:

  • 5. 

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

    • Field

    • Entry

    • Record

    • Fills

    Correct Answer
    A. Record
    Explanation
    Ans: C Record – this is a group of matching fields.

    Rate this question:

  • 6. 

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

    • Moscow

    • Beirut

    • Paris

    • Bogota

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

    Rate this question:

  • 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

    Correct Answer
    A. Foreign Key
    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.

    Rate this question:

  • 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

    Correct Answer
    A. Collection of country music CDs
    Explanation
    Music CDs are not electronic.

    Rate this question:

  • 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

    Correct Answer
    A. Data can be added or deleted easily
    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.

    Rate this question:

  • 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

    Correct Answer
    A. They can be viewed in different formats.
    Explanation
    Ans: A - they were referring to data and not database management system in this case

    Rate this question:

Quiz Review Timeline (Updated): Dec 16, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 16, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 11, 2011
    Quiz Created by
    Stmonicas
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.