COSC Final Exam Study Guide 1
(14).webp "COSC Final Exam Study Guide 1 - Quiz")
Questions and Answers
- 1.
Which of the following is a reason for creating a list instead of creating a database
- A.
To organize data for simple tasks
- B.
To prevent data inconsistency
- C.
To prevent data redundancy
- D.
To make it easier to share data in a central location
Correct Answer
A. To organize data for simple tasksExplanation
Creating a list instead of a database is a suitable choice when the goal is to organize data for simple tasks. Lists are simpler and more straightforward compared to databases, making them ideal for handling basic data organization needs. They provide a simple and easy-to-use structure for storing and accessing information, making them suitable for tasks that don't require complex querying or extensive data manipulation.Rate this question:
-
- 2.
In a database, a field is a
- A.
category of information
- B.
Label
- C.
table of information
- D.
Group of related records
Correct Answer
A. category of informationExplanation
A field in a database refers to a specific category of information. It is used to organize and store data within a table. Each field represents a particular attribute or characteristic of the data being stored, such as name, age, or address. By categorizing data into fields, it becomes easier to search, sort, and analyze the information stored in the database.Rate this question:
-
- 3.
Data ________ means that the data contained in a database is accurate and reliable
- A.
Efficiency
- B.
Integrity
- C.
Redundancy
- D.
Consistency
Correct Answer
B. IntegrityExplanation
Integrity refers to the quality of data being accurate and reliable. It ensures that the data in a database is consistent, complete, and trustworthy. This means that the data has not been altered or tampered with, and it reflects the true and intended values. Maintaining data integrity is crucial for making informed decisions and ensuring the effectiveness of any database system.Rate this question:
-
- 4.
Which of the following is NOT a database component
- A.
Field
- B.
List
- C.
Record
- D.
Table
Correct Answer
B. ListExplanation
A list is not a database component because it is not a fundamental unit of organizing and storing data. In a database, data is typically organized into tables, where each table consists of records that contain specific information, such as fields. A field is a single piece of data within a record, while a record is a collection of related fields. Therefore, a list does not fit into the hierarchical structure of a database and is not considered a component.Rate this question:
-
- 5.
In a database, a video clip would be stored in a(n) ________ field
- A.
Text
- B.
Object
- C.
Memo
- D.
Hyperlink
Correct Answer
B. ObjectExplanation
A video clip would be stored in an "object" field in a database. This type of field is used to store multimedia files, such as images, audio, and video, which cannot be easily represented as text. Storing the video clip as an object allows for efficient storage and retrieval of the file within the database system.Rate this question:
-
- 6.
In a database, a text field capable of holding complete paragraphs is referred to as a ________ field
- A.
Memo
- B.
Document
- C.
Paragraph
- D.
Hypertext
Correct Answer
A. MemoExplanation
A text field capable of holding complete paragraphs in a database is referred to as a "memo" field. This type of field allows for the storage of lengthy text content, such as paragraphs, in a database record. It is commonly used when there is a need to store large amounts of textual information, such as notes, descriptions, or comments. The term "memo" is often used in the context of databases to describe this specific type of field.Rate this question:
-
- 7.
Which of the following is NOT a likely primary key?
- A.
A driver's license number
- B.
Street address
- C.
Student ID number
- D.
Social security number
Correct Answer
B. Street addressExplanation
A primary key is a unique identifier for each record in a database table. It must be unique and not null. In this case, a street address is not a likely primary key because it is not guaranteed to be unique for each record. Multiple people can have the same street address, especially in apartment buildings or shared housing situations. Therefore, a street address would not be a suitable primary key.Rate this question:
-
- 8.
Which type of database excels in the storage of structured (analytical) data?
- A.
Relational
- B.
hierarchical
- C.
Multidimensional
- D.
object-oriented
Correct Answer
A. RelationalExplanation
Relational databases excel in the storage of structured (analytical) data. This type of database organizes data into tables with rows and columns, allowing for efficient storage and retrieval of large amounts of structured data. Relational databases use structured query language (SQL) to manage and manipulate data, providing powerful capabilities for data analysis and reporting. They are widely used in various industries for applications such as financial analysis, customer relationship management, and inventory management.Rate this question:
-
- 9.
A ________ displays a subset of data from a table (or tables) based on the criteria specified.
- A.
Database query
- B.
Join query
- C.
Select query
- D.
Criteria query
Correct Answer
C. Select queryExplanation
A select query is a type of query that allows users to retrieve a subset of data from a table or multiple tables in a database based on specific criteria. It is used to filter and display only the desired information, making it easier to analyze and work with the data. With a select query, users can specify the columns they want to retrieve, as well as any conditions or criteria that need to be met for the data to be included in the result set.Rate this question:
-
- 10.
Which of the following statements about object-oriented databases is FALSE?
- A.
They are more complex than relational databases.
- B.
They use a query language to access and manage data.
- C.
They are good at handling unstructured data.
- D.
They store data in table format.
Correct Answer
D. They store data in table format.Explanation
Object-oriented databases do not store data in table format like relational databases. Instead, they store data in objects, which are instances of classes that contain both data and the methods to manipulate that data. This allows for more flexible and efficient storage and retrieval of complex data structures.Rate this question:
-
- 11.
Microsoft ________ is a database management system
- A.
Visio
- B.
Publisher
- C.
Access
- D.
Project
Correct Answer
C. AccessExplanation
Microsoft Access is a database management system developed by Microsoft. It allows users to create and manage databases, as well as perform various tasks such as data entry, querying, and reporting. Access is widely used for small to medium-sized databases and is known for its user-friendly interface and flexibility in designing and customizing databases.Rate this question:
-
- 12.
When creating a database with a DBMS, you must create a description of the data called the ________.
- A.
Data type
- B.
Data dictionary
- C.
Database dictionary
- D.
Database style guide
Correct Answer
B. Data dictionaryExplanation
When creating a database with a DBMS, you must create a description of the data called the data dictionary. This is a collection of metadata that provides information about the data in the database, such as the names and definitions of tables, columns, data types, constraints, and relationships. The data dictionary helps in organizing and managing the database by providing a centralized source of information for developers, administrators, and users. It ensures consistency and accuracy in data definitions and helps in maintaining data integrity and security.Rate this question:
-
- 13.
SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.
- A.
Boolean algebra
- B.
Relational algebra
- C.
primary keys
- D.
) foreign keys
Correct Answer
A. Boolean algebraExplanation
SQL uses Boolean algebra to extract records from a database by using English-like expressions that have variables and operations. Boolean algebra is a mathematical system that deals with logical expressions and operations, such as AND, OR, and NOT. In SQL, these Boolean operators are used to specify conditions for extracting specific records from a database. By using Boolean algebra, SQL allows users to perform complex queries and retrieve the desired information from a database based on logical conditions.Rate this question:
-
- 14.
In Access, the Simple Query Wizard uses SQL to create a query.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because the Simple Query Wizard in Access does use SQL (Structured Query Language) to create a query. SQL is a standard language used for managing and manipulating databases, and the Simple Query Wizard simplifies the process by generating SQL code based on user input and criteria. This allows users to easily create queries without needing to write complex SQL statements manually.Rate this question:
-
- 15.
A database formula instructs a database to search for particular pieces of data.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
A database formula does not instruct a database to search for particular pieces of data. Instead, it is used to perform calculations or manipulate data within the database. The primary purpose of a database formula is to perform mathematical or logical operations on the existing data, rather than searching for specific pieces of information. Therefore, the given statement is false.Rate this question:
-
- 16.
A ________ relationship indicates that for a record in one table, there can be many related records in another table.
- A.
Many-to-one
- B.
One-to-many
- C.
One-to-one
- D.
Single-to-many
Correct Answer
C. One-to-oneExplanation
A one-to-one relationship indicates that for a record in one table, there can be only one related record in another table. This means that each record in the first table is associated with a unique record in the second table, and vice versa. It is a strict and direct relationship where each record has a single corresponding record in the other table.Rate this question:
-
- 17.
A data mart is a large-scale electronic repository of data that contains and organizes all of an organization's data in one place.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because a data mart is not a large-scale electronic repository of data that contains and organizes all of an organization's data in one place. Instead, a data mart is a subset of a data warehouse that focuses on a specific department or area of an organization. It contains a condensed and summarized version of data that is relevant to a particular group of users.Rate this question:
-
- 18.
A(n) ________ is designed to improve communications and assist employees in accomplishing their daily tasks.
- A.
Office support system
- B.
Transaction-processing system
- C.
management information system
- D.
Decision support system
Correct Answer
A. Office support systemExplanation
An office support system is designed to improve communications and assist employees in accomplishing their daily tasks. This system provides tools and resources that help employees manage their work, such as email, document management, and scheduling software. It helps streamline communication within the office and ensures that employees have the necessary tools to efficiently complete their tasks.Rate this question:
-
- 19.
In a transaction-processing system, if transaction data is accumulated until a certain point and then many transactions are processed all at once, this is called batch processing.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because batch processing refers to the accumulation of transaction data until a certain point and then processing multiple transactions together. This approach is commonly used in transaction-processing systems to improve efficiency and reduce processing time. By processing transactions in batches, system resources can be utilized more effectively, and the overall system performance can be enhanced.Rate this question:
-
- 20.
Management information systems provide reports that show conditions that are unusual or need attention from users of the system. These reports are called detail reports.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Management information systems provide reports that show conditions that are unusual or need attention from users of the system. These reports are called exception reports, not detail reports. Detail reports provide comprehensive information about specific aspects of the system, whereas exception reports highlight deviations from normal conditions and focus on areas that require immediate attention. Therefore, the correct answer is False.Rate this question:
-
- 21.
An example of ________ would be customer demographic data purchased from third parties or statistics compiled by the federal government
- A.
internal data
- B.
External data
- C.
Imported data
- D.
Metadata
Correct Answer
B. External dataExplanation
External data refers to data that is sourced from outside the organization. In this case, customer demographic data purchased from third parties or statistics compiled by the federal government are examples of external data. This data is not generated or collected by the organization itself but is obtained from external sources. It can provide valuable insights and information that can be used for various purposes such as market research, analysis, and decision-making.Rate this question:
-
- 22.
The type of information system that uses model management systems is a(n) ________.
- A.
transaction-processing system
- B.
management information system
- C.
Decision support system
- D.
office support system
Correct Answer
C. Decision support systemExplanation
A decision support system is a type of information system that uses model management systems. This system helps in making decisions by providing the necessary data and tools to analyze and evaluate different options. It uses models to simulate various scenarios and predict the outcomes of different decisions. This helps in making informed decisions based on accurate and up-to-date information.Rate this question:
-
- 23.
Classification, affinity grouping, and estimation are artificial intelligence methods used by managers to make their data more meaningful.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Classification, affinity grouping, and estimation are not artificial intelligence methods used by managers to make their data more meaningful. While these techniques may be used in data analysis and decision-making processes, they are not exclusive to artificial intelligence. Managers can utilize these methods without the use of AI. Therefore, the statement is false.Rate this question:
-
- 24.
If a college keeps two lists, one for registration and one for overdue library books, both containing name and address information, this is an example of data _______
- A.
Intergity
- B.
Redundancy
- C.
Completeness
- D.
Normalization
Correct Answer
B. RedundancyExplanation
The given scenario of a college keeping two separate lists for registration and overdue library books, both containing name and address information, demonstrates data redundancy. Redundancy refers to the duplication of data in a database, where the same information is stored multiple times. In this case, the name and address information is duplicated in both lists, leading to data redundancy. This can be inefficient and can cause inconsistencies or discrepancies if the duplicated data is not properly synchronized or updated.Rate this question:
-
- 25.
An individual trained in the design and building of databases is called a database analyst.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given statement is false. An individual trained in the design and building of databases is called a database administrator, not a database analyst. A database analyst typically focuses on analyzing and interpreting data, while a database administrator is responsible for the design, implementation, and maintenance of databases.Rate this question:
-
- 26.
In a database table that stores name and address information, "State" would be an example of a(n) _______
- A.
Default value
- B.
Field name
- C.
Row heading
- D.
Object
Correct Answer
B. Field nameExplanation
In a database table that stores name and address information, "State" would be an example of a field name. Field names are used to label and identify the different columns or attributes in a database table. In this case, "State" is the field name that represents the column where the state information is stored.Rate this question:
-
- 27.
Natural language processing is the branch of computer science that deals with the attempt to create computers that think like humans.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because natural language processing (NLP) is not about creating computers that think like humans, but rather it focuses on enabling computers to understand, interpret, and generate human language. NLP involves tasks such as language translation, sentiment analysis, speech recognition, and text generation, among others. While NLP aims to make computers better at processing and understanding language, it does not involve replicating human thought processes.Rate this question:
-
- 28.
What does the acronym DBMS stand for?
- A.
Database modeling system
- B.
Database management system
- C.
Data building and modeling system
- D.
Data browsing and management system
Correct Answer
B. Database management systemExplanation
The acronym DBMS stands for "database management system." A database management system is a software that allows users to create, manipulate, and manage databases. It provides tools and functionalities to organize and store data efficiently, as well as retrieve and update information as needed. By using a DBMS, users can ensure data integrity, security, and consistency in their databases, making it an essential component in modern data-driven applications.Rate this question:
-
- 29.
Sorting is reordering records in a database
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given statement is true because sorting involves rearranging the records in a database in a specific order, such as ascending or descending. This process helps in organizing the data and makes it easier to search, analyze, and retrieve information from the database. By sorting the records, it becomes possible to locate specific data more efficiently and perform various operations on the database effectively.Rate this question:
-
- 30.
A group of related fields is call a(n) record
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A group of related fields is commonly referred to as a record. This term is widely used in the field of computer science and database management to describe a collection of data elements that are related or belong together. Records are typically organized and stored in databases, where each record represents a complete set of information about a particular entity or object. Therefore, the statement "A group of related fields is called a record" is true.Rate this question:
-
Back to top