SBI SO: computer Knowledge Quiz

Q1. Which of the following is a reason for creating a list instead of creating a database?
A. to prevent data inconsistency
B. to prevent data redundancy
C. to make it easier to share data in a central location
D. to organize data for simple tasks


Q2. Which of the following is NOT an effect of data redundancy in a database?
A. increased loss of data
B. wasted time entering data
C. increased likelihood of a mistake
D. inconsistent data

Q3. When data changes in multiple lists and all lists are not updated, this causes:
A. data redundancy.
B. information overload.
C. duplicate data.
D. data inconsistency.

Q4.  ____________ means that the data contained in a database is accurate and reliable.
A. Data redundancy
B. Data integrity
C. Data reliability
D. Data consistency

Q5. All of the following are advantages of using a database, EXCEPT:
A. data redundancy.
B. data integrity.
C. flexible use of data.
D. information sharing.

Q6. In a database, a field is a:
A. label.
B. table of information.
C. group of related records.
D. category of information.

Q7. Each field in a database is identified by a:
A. field name.
B. key name.
C. field type.
D. field code.

Q8. In a database, ____________ fields store numbers used to perform calculations.
A. next
B. numeric
C. key
D. alphanumeric

Q9. A telephone number would be stored in a____________ field in a database.
A. text
B. memo
C. computed
D. date

Q10. A picture would be stored in a(n)____________ field in a database.
A. text
B. memo
C. object
D. hyperlink

Q11. To record a person’s last name, use a(n) ____________ field in a database.
A. memo
B. object
C. name
D. text

Q12. To store text data that may be very long, use a ____________ field in a database.
A. memo
B. text
C. data
D. long

Q13. A group of related fields in a database is called a(n):
A. record.
B. object.
C. memo.
D. table.

Q14. A group of related records in a database is called a(n):
A. column.
B. object.
C. key.
D. table.

Q15. The purpose of the primary key in a database is to:
A. unlock the database.
B. uniquely identify a record.
C. provide a map of the data.
D. establish constraints on database operations.

Q16. A good candidate for a primary key in a database would be a(n):
A. last name.
B. birth date.
C. employee position title.
D. student identification number.

Q17. All of the following are types of databases, EXCEPT:
A. relational.
B. relation-oriented.
C. object-oriented.
D. multidimensional.

Q18. A relational database organizes data by logically grouping similar data into ____________, or tables that contain related data.
A. keys
B. relations
C. fields
D. records

Q19. In a relational database, tables are logically linked to each other by a:
A. key.
B. hyperlink.
C. field type.
D. field size.

Q20. A(n) ____________ database stores data in objects, not in tables.
A. object-oriented
B. relational
C. multidimensional
D. object-relational

Q21. Which of the following statements concerning object-oriented databases is FALSE?
A. Objects in an object-oriented database contain not only data but also methods for processing the data.
B. Object-oriented databases store computational instructions in the same place as the data.
C. Object-oriented databases are more adept at handling structured (analytical) data than relational databases.
D. Object-oriented databases store more types of data than relational databases and access that data faster.

Q22. Which of the following would NOT ordinarily be considered unstructured data?
A. text
B. video
C. audio clips
D. MP3 files

Q23. Oracle 10g is an example of a(n):
A. relational database.
B. object-oriented database.
C. multidimensional database.
D. Web-based database.

Q24. Which of the following is NOT one of the four main functions of a database management system (DBMS)?
A. creating databases and entering data
B. viewing and indexing data
C. querying data
D. programming data

Q25. The ____________ contains data descriptions and defines the name, data type, and length of each field in the database.
A. data dictionary
B. data table
C. data record
D. data field

ANSWERS:
1. D                                  11. D                               21. C
2. A                                  12. A                               22. A
3. D                                  13. A                               23. C
4. B                                  14. D                               24. D
5. A                                  15. B                               25. A
6. D                                  16. D
7. A                                  17. B
8. B                                  18. B
9. A                                  19. A
10. C                                20. A