Database Quiz 1
This is a simple introduction to database question series that test your common knowledge. Gearing you up for CSEC IT.
- 1.
If a student sorted the following in descending order, which international capital would be first?
- A.
Moscow
- B.
Beirut
- C.
Paris
- D.
Bogota
Correct Answer
C. ParisExplanation
Ans: Paris – because it has the largest letters of the alphabet sort bottom to top.Rate this question:
-
- 2.
In a database program, a set of related Information is called a:
- A.
Field
- B.
Entry
- C.
Record
- D.
Fills
Correct Answer
C. RecordExplanation
Ans: C Record – this is a group of matching fields.Rate this question:
-
- 3.
A database program replaces what piece of office equipment?
- A.
Typewriter
- B.
Photocopier
- C.
FAX machine
- D.
Filing cabinet
Correct Answer
D. Filing cabinetExplanation
Ans: D Filing Cabinet – used by traditional means of storing central documentsRate this question:
-
- 4.
An advantage of a database program is:
- A.
Office correspondence can be handled
- B.
All fields can be printed in a one page report
- C.
Data can be added or deleted easily
- D.
All records can be displayed at one time
Correct Answer
C. Data can be added or deleted easilyExplanation
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:
-
- 5.
Which of the following is not true of database programs?
- A.
They can be viewed in different formats.
- B.
They can be used to retrieve information quickly.
- C.
They are limited to the amount of information they can hold.
- D.
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 caseRate this question:
-
- 6.
Searching a database of North Carolina counties by using the statement, “all counties with a population of greater than two million” will include:
- A.
Counties with exactly two million people
- B.
Counties with two million or more
- C.
Counties with more than two million
- D.
Counties with less than two million
Correct Answer
C. Counties with more than two millionExplanation
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:
-
- 7.
All of the following are examples of electronic databases except which one?
- A.
Collection of country music CDs
- B.
A CD-Rom encyclopedia
- C.
Computerized student information
- D.
Electronic Card Catalog
Correct Answer
A. Collection of country music CDsExplanation
Music CDs are not electronic.Rate this question:
-
- 8.
How would you find the phone number of one student from 500 names and addresses of students enrolled at your school?
- A.
Perform a search of all boys in the database
- B.
Perform a search using the student’s name as the criteria
- C.
Sort the database and scroll all records
- D.
Sort the database in descending order
Correct Answer
B. Perform a search using the student’s name as the criteriaExplanation
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.Rate this question:
-
- 9.
The following search was performed: “Country” = USSR or “Country” = USA How many records matched?
- A.
9
- B.
6
- C.
7
- D.
8
Correct Answer
C. 7Explanation
Ans: 7, there are seven records because the logical “or” gave a true value on querying both USA and USSR.Rate this question:
-
- 10.
A field in a table that appears as a match of the primary key in another table is called a
- A.
Candidate key
- B.
Secondary Key
- C.
Foreign Key
- D.
Composite Key
Correct Answer
C. Foreign KeyExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Dec 16, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 11, 2011Quiz Created by
Stmonicas
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top