Click Here To View The Answer
Answer: Option: A
A collection of raw facts and figure is called Data.
Q1. A collection of raw facts and figure is called:
- A: Data
- B: Information
- C: Processing
- D: None
Q2. The processed data is called:
- A: Input
- B: Information
- C: Data
- D: None
Click Here To View The Answer
Answer: Option: B
The processed data is called Information
Q3. Which of the following is an example of a database?
- A: Phone book
- B: Library catalog
- C: Student records
- D: All of these
Click Here To View The Answer
Answer: Option: D
Phone book, Library catalog, Student records is an example of a database.
Q4. A database file is
- A: A: Record of a person or thing
- B: Text document describing the database
- C: Collection of related information
- D: Both a and b
Click Here To View The Answer
Answer: Option: C
A database file is Collection of related information.
Q5. A software that controls the organization, storage, retrieval, security and integrity of data in a database is called:
- A: File processing
- B: Record
- C: Operating system
- D: DBMS
Click Here To View The Answer
Answer: Option: D
A software that controls the organization, storage, retrieval, security and integrity of data in a database is called DBMS.
Q6. Which of the following is not database management system?
- A: Oracle
- B: MS Access
- C: Visual Basic
- D: Sybase
Click Here To View The Answer
Answer: Option: C
Sybase is not database management system.
Q7. Which of the following is handled by the DBMS?
- A: Data integrity
- B: Data security
- C: Data independence
- D: All of these
Click Here To View The Answer
Answer: Option: D
Data integrity, Data security, Data independence are handled by the DBMS.
Q8. Asking the user to type the password twice is an example of a(n):
- A: Numeric check
- B: Range check
- C: Consistency checks
- D: Alphabetic check.
Click Here To View The Answer
Answer: Option: C
Asking the user to type the password twice is an example of a Consistency checks.
Q9. Choose the item that represents bad design in a database:
- A: Data security
- B: Data redundancy
- C: Data independence
- D: Data maintenance
Click Here To View The Answer
Answer: Option: B
Data redundancy represents bad design in a database:
Q10. A database may contain:
- A: Only one table
- B: At most two tables
- C: At most three tables
- D: Any number of tables
Click Here To View The Answer
Answer: Option: D
A database may contain any number of tables.
Q11. Consistency constrains means:
- A: Data can be checked for various conditions
- B: Redundancy of data
- C: Data can be accessed easily and efficiently
- D: Stored data occupies as little space as possible.
Click Here To View The Answer
Answer: Option: A
Consistency constrains means data can be checked for various conditions.
Q12. Data redundancy means:
- A: Duplication of data
- B: Automatically capitalizes the first letter of any words
- C: Data integrity
- D: Automatically capitalizes the first letter of any words
Click Here To View The Answer
Answer: Option: A
Data redundancy means duplication of data.
Q13. Data atomicity means:
- A: Data is either entered as a whole or it is not entered at all
- B: Data can be checked for various conditions
- C: Duplication of data
- D: Data can be accessed easily and efficiently
Click Here To View The Answer
Answer: Option: A
Data atomicity means data is either entered as a whole or it is not entered at all.
Q14. A field is
- A: Unique identifier.
- B: Table of information.
- C: Group of related records.
- D: Unit of information.
Click Here To View The Answer
Answer: Option: D
A field is unit of information.
Q15. If you wanted to record a person's last name, you would put it into a(n):
- A: Memo
- B: object
- C: name
- D: Memo
Click Here To View The Answer
Answer: Option: D
If you wanted to record a person's last name, you would put it into a text.
Q16. A group of related fields is called
- A: Table.
- B: Database.
- C: Record.
- D: hyperlink.
Click Here To View The Answer
Answer: Option: C
A group of related fields is called
Q17. The purpose of the primary key is to:
- A: Unlock the database.
- B: Uniquely identify a recorD:
- C: Provide a map of the datA:
- D: Provide a map of the datA:
Click Here To View The Answer
Answer: Option: B
The purpose of the primary key is to uniquely identify a record
Q18. The logical links between tables in a relational database are accomplished via
- A: Keys.
- B: hyperlinks.
- C: Data fields.
- D: Computational fields.
Click Here To View The Answer
Answer: Option: A
The logical links between tables in a relational database are accomplished via Keys.
Q19. Support for methods in a database framework can be found in:
- A: Object-oriented databases.
- B: Web-based databases.
- C: Relational databases.
- D: Method-oriented databases.
Click Here To View The Answer
Answer: Option: A
Support for methods in a database framework can be found in object-oriented databases.
Q20. Object-oriented databases are best used for:
- A: Representing primary and foreign key links between tables.
- B: Organizing structured business datA:
- C: Representing data and processing in a single entity.
- D: Storing simple lists of tasks.
Click Here To View The Answer
Answer: Option: C
Object-oriented databases are best used for representing data and processing in a single entity.
Q21. Which of the following is not a common function for a DBMS?
- A: Creating databases and entering data
- B: Identifying disk sector addresses of data
- C: Extracting (or querying) data
- D: Viewing (browsing)
Click Here To View The Answer
Answer: Option: B
Identifying disk sector addresses of data is not a common function for a DBMS.
Q22. A _______ is a large database.
- A: Database program
- B: Data warehouse
- C: Record
- D: Information system
Click Here To View The Answer
Answer: Option: B
A data warehouse is a large database.
Q23. Text, numbers, and dates are examples of:
- A: Data types
- B: Data integrity
- C: Fields.
- D: Characters.
Click Here To View The Answer
Answer: Option: A
Text, numbers, and dates are examples of data types.
Q24. A person's account, car, and house are considered:
- A: Memos.
- B: Fields.
- C: Objects.
- D: Defaults.
Click Here To View The Answer
Answer: Option: C
A person's account, car, and house are considered Objects.
Q25. Checking that the person's age is between 0 and 150 is a(n):
- A: Range check.
- B: Numeric check.
- C: Consistency check.
- D: Completeness check.
Click Here To View The Answer
Answer: Option: A
Checking that the person's age is between 0 and 150 is a range check.
Q26. The most popular type of DBMS is a(n):
- A: Network database.
- B: Object-oriented database.
- C: Hierarchical database.
- D: Relational database.
Click Here To View The Answer
Answer: Option: D
The most popular type of DBMS is a relational database.
Q27. The purpose of a validation rule is to ensure that:
- A: The field properties entered by the database designer are valid.
- B: Only authorized personnel gain access to the data in the database.
- C: Tables in the database maintain correct relationships between themselves.
- D: The data entered by a user satisfies specified constraints.
Click Here To View The Answer
Answer: Option: D
The purpose of a validation rule is to ensure that the data entered by a user satisfies specified constraints.
Q28. A consistency check:
- A: Ensures that the data entered is consistent with the required field type.
- B: Compares the value of two fields in a record to ensure that they are reasonable together.
- C: Relates the primary key of one record against the foreign key of another to make sure they match.
- D: Validates that the data entered satisfies field constraints.
Click Here To View The Answer
Answer: Option: B
A consistency check compares the value of two fields in a record to ensure that they are reasonable together.
Q29. Proper database design dictates that data about each individual topic or theme is located in the same distinct:
- A: Relationship
- B: Query
- C: Table.
- D: Property
Click Here To View The Answer
Answer: Option: C
Proper database design dictates that data about each individual topic or theme is located in the same distinct Table.
Q30. Which of the following is not allowed for primary keys?
- A: Duplication of primary keys within a table
- B: Primary key with a non-numeric value
- C: Primary key value matching a foreign key of a related table
- D: Primary key value not matching any foreign key of a related table
Click Here To View The Answer
Answer: Option: A
Duplication of primary keys within a table is not allowed for primary keys.
Q31. A relation is considered
- A: Column
- B: 1-dimensional table
- C: 2-dimensional table
- D: 3-dimensional table
Click Here To View The Answer
Answer: Option: C
A relation is considered 2-dimensional table.
Q32. A relation is analogous to
- A: Table
- B: Field
- C: Record
- D: Row
Click Here To View The Answer
Answer: Option: A
A relation is analogous to Table.
Q33. Who presented the concept of relational databases?
- A: Dr. E.F. Codd
- B: Von-Neuman
- C: Charles Babbage
- D: Bill Gates
Click Here To View The Answer
Answer: Option: A
Dr. E.F. Codd presented the concept of relational databases.
Q34. Which of the following is not database system ?
- A: Hierarchical
- B: Network
- C: Inverted List
- D: File Structure
Click Here To View The Answer
Answer: Option: D
File Structure is not database system .
Q35. Which of the following is true about degree?
- A: The number of attribute in a relation
- B: The number of tuples in a relation
- C: The number of relation in table
- D: All of these
Click Here To View The Answer
Answer: Option: A
The number of attribute in a relation is true about degree.
Q36. Which of the following is true about cardinality?
- A: The number of attribute in a relation
- B: The number of tuples in a relation
- C: The number of relation in table
- D: All of these
Click Here To View The Answer
Answer: Option: B
The number of tuples in a relation is true about cardinality.
Q37. MS Access is referred to as:
- A: RBDMS
- B: RDBMS
- C: RMDBS
- D: RDMBS
Click Here To View The Answer
Answer: Option: D
MS Access is referred to as RDMBS.
Q38. What is the advantage to enforcing referential integrity?
- A: Ability to create a query using two tables
- B: Using sub datasheet in a table
- C: Prevents orphan records between tables
- D: All of the above
Click Here To View The Answer
Answer: Option: C
Prevents orphan records between tables is the advantage to enforcing referential integrity.
Q39. Which of the following describes a select query?
- A: Limits the records shown
- B: Limits the fields shown
- C: Selects records based on specific criteria
- D: All of the above
Click Here To View The Answer
Answer: Option: D
Limits the records shown, Limits the fields shown, Selects records based on specific criteria describes a select query.
Q40. A primary key to foreign key linkage constitutes a(n):
- A: Table.
- B: Relationship.
- C: database.
- D: Intersection.
Click Here To View The Answer
Answer: Option: B
A primary key to foreign key linkage constitutes a Relationship.
Q41. Which of the following is a characteristic of valuable information?
- A: Economical
- B: Verifiable
- C: Secure
- D: All of the above
Click Here To View The Answer
Answer: Option: D
Economical, Verifiable, Secure is a characteristic of valuable information.
Q42. Referential integrity dictates that:
- A: Data is not duplicated in order to guarantee that there are no inconsistencies.
- B: Foreign key values match with primary key values in a relationship.
- C: References in the table are consistent with those in the field.
- D: Constraints are placed on allowable values of a field.
Click Here To View The Answer
Answer: Option: B
Referential integrity dictates that foreign key values match with primary key values in a relationship.
Q43. A data warehouse contains:
- A: Operational data
- B: Time-invariant data
- C: Inventory data
- D: Archival data
Click Here To View The Answer
Answer: Option: D
A data warehouse contains archival data.
Q44. OLAP is a(n):
- A: Sophisticated query and analytic software tool for data warehouses.
- B: Object-oriented design methodology for object-relational databases.
- C: Data mining technique for analyzing customer buying behavior.
- D: System designed to support day-to-day organizational and communications tasks.
Click Here To View The Answer
Answer: Option: A
OLAP is a sophisticated query and analytic software tool for data warehouses.
Q45. Spreadsheets, word processing, and e-mail systems all fall under the general category of:
- A: Office support systems.
- B: Transaction processing systems.
- C: Management information systems.
- D: None of these
Click Here To View The Answer
Answer: Option: A
Spreadsheets, word processing, and e-mail systems all fall under the general category of office support systems.
Q46. In a distributed database, the data is:
- A: On a large computer, typically a supercomputer
- B: On a server at a central location
- C: Spread across several computers
- D: Maintained in batch mode
Click Here To View The Answer
Answer: Option: C
In a distributed database, the data is spread across several computers
Q47. The newer database model that is becoming an alternative to the relational model is the model.
- A: Object-oriented
- B: Structured
- C: Pyramid
- D: Pointer-based
Click Here To View The Answer
Answer: Option: A
The newer database model that is becoming an alternative to the relational model is the model object-oriented.
Q48. An object-oriented database:
- A: is based on hardware systems rather than software
- B: Stores software objects
- C: Stores records ir, tables
- D: Both a and c
Click Here To View The Answer
Answer: Option: B
An object-oriented database Stores software objects.
Q49. Multimedia databases may contain:
- A: Video clips
- B: Sound files
- C: Maps
- D: All of the above
Click Here To View The Answer
Answer: Option: D
Multimedia databases may contain Video clips, Sound files, Maps.
Q50. A multimedia database for video clips:
- A: Serves as an index to the separately stored files.
- B: Uses removable disks to hold the massive files.
- C: Uses tape cartridges to hold the massive files.
- D: Both a and b are correct.
Click Here To View The Answer
Answer: Option: A
A multimedia database for video clips serves as an index to the separately stored files.
Q51. How many primary keys can a table have?
- A: One
- B: At least one, but not more than two
- C: Between 1 and 5
- D: No limit
Click Here To View The Answer
Answer: Option: A
One primary keys can a table have.
Q52. Which of the following would not be a good primary key?
- A: Social security number
- B: Order number
- C: Zip code
- D: Student ID number
Click Here To View The Answer
Answer: Option: C
Zip code would not be a good primary key.
Share
