Question 1

​____ are screen objects used to maintain,view,and print data from a database.
A) ​Fields
B) ​Forms
C) ​Data files
D) ​Entities

Accepted Answer

Forms are screen objects used to maintain, view, and print data from a database. Fields refer to individual pieces of data within a database, data files refer to the actual files that contain the database data, and entities are typically used in data modeling to represent a concept or object within a system.

Question 2

In an E-R diagram,____________________ represent entities.​

Accepted Answer

The answer of In an E-R diagram,____________________ represent entities.​...

Question 3

During the ____ process,a database expert determines the structure of the required database.​
A) data security​
B) ​database integrity
C) ​database design
D) ​database selection

Accepted Answer

During the database design process, a database expert determines the structure of the required database, including selecting data types, defining data relationships, and establishing security measures. Data security, database integrity, and database selection are important considerations throughout the entire database development process, but they do not specifically involve determining the database structure.

Question 4

​Unlike a typical data file,a database can store information about multiple ____.
A) ​attributes
B) ​bytes
C) ​entities
D) ​characters

Accepted Answer

A database is designed to store information about multiple entities, such as customers, products, or sales. It allows for efficient organization and management of large amounts of related data. Attributes, bytes, and characters are all components of data within a database.

Question 5

​A(n)____ frees programmers who write database access programs from having to engage in mundane data manipulation activities,such as adding new data and deleting existing data.
A) ​E-R diagram
B) ​DBA
C) ​entity
D) ​DBMS

Accepted Answer

A DBMS (Database Management System) is designed to handle data manipulation tasks, such as adding, deleting, and modifying data. This frees programmers from having to perform these tasks manually, allowing them to focus on more complex programming tasks. E-R diagrams, entities, and DBAs (Database Administrators) are all related to databases but do not directly address the issue of automating data manipulation.

Question 6

In an E-R diagram,the ____________________ at the end of a line indicates the "many" part of the one-to-many relationship between two entities.

Accepted Answer

The answer of In an E-R diagram,the ____________________ at the...

Question 7

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.​
A) ​database administrator
B) ​DBA
C) ​E-R diagram
D) ​DBMS

Accepted Answer

A DBMS (Database Management System) is designed to allow users to define, create, maintain, and control access to the database, including the ability to incorporate integrity constraints.

Question 8

In a(n)____________________ relationship between two entities,each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.​

Accepted Answer

The answer of In a(n)____________________ relationship between two entities,each occurrence...

Question 9

____ is the prevention of unauthorized access to the database.​
A) ​Data independence
B) ​Integrity constraint
C) ​Redundancy
D) ​Security

Accepted Answer

Security is the practice of preventing unauthorized access to the database, protecting against data theft or damage, and ensuring the privacy of sensitive information. It includes various techniques such as encryption, access controls, and authentication mechanisms to secure the database from external and internal threats. Data independence (A) refers to the ability to modify the database schema without affecting the applications that use it. Integrity constraint (B) is a rule that restricts the values in a table to ensure data consistency. Redundancy (C) refers to the duplication of data in a database, which can lead to data inconsistencies and inefficiencies.

Question 10

In an E-R diagram,____________________ represent relationships between connected entities.​

Accepted Answer

The answer of In an E-R diagram,____________________ represent relationships between...

Question 11

One disadvantage of a database system is ____.​
A) ​a larger file size
B) ​data dependence
C) ​reduced integrity
D) ​reduced productivity

Accepted Answer

Database systems often require more storage space due to the complexity and additional features they provide, leading to larger file sizes.

Question 12

A person who is in charge of a database within an organization is often called the database ____.​
A) writer​
B) ​designer
C) ​administrator
D) ​controller

Accepted Answer

The person responsible for managing and maintaining a database within an organization is typically referred to as a database administrator (DBA). They are responsible for tasks such as setting up the database, configuring access and security, monitoring system performance, and troubleshooting issues. A database writer may refer to someone who creates or updates content within the database, while a database designer typically focuses on developing the overall database structure and schema. A database controller is not a commonly used term in this context.

Question 13

A database has ____ if the data in it satisfies all established integrity constraints.​
A) ​redundancy
B) ​integrity
C) ​data independence
D) ​database design

Accepted Answer

Integrity constraints are rules that dictate what values are allowed to be entered in a database. When all the data in a database satisfies these rules, the database is considered to have integrity. Redundancy refers to unnecessary duplication of data, data independence refers to the ability to change underlying data structures without affecting applications, and database design refers to the process of organizing data in a database.

Question 14

​A visual way to represent a database is with a(n)____.
A) ​spreadsheet
B) ​DBMS
C) ​entity-relationship diagram
D) ​DBA

Accepted Answer

An entity-relationship diagram (ERD) is a visual way to represent a database. It shows the entities or objects within the system and the relationships between them. ERDs are commonly used in database design to clarify the structure of a database and ensure that all data is properly organized and stored. Spreadsheets are not typically used to represent databases, and a DBMS (database management system) is software used to manage the storage, retrieval, and updating of data in a database. A DBA (database administrator) is a person who manages a database system, but is not a visual representation of the database itself.

Question 15

Popular ____ include Access,Oracle,DB2,MySQL,and SQL Server.​
A) ​E-R diagrams
B) ​DBAs
C) ​data files
D) ​DBMSs

Accepted Answer

The given options refer to database related terms. Out of these, the term that specifically matches the given description is DBMSs, which stands for Database Management Systems. Access, Oracle, DB2, MySQL, and SQL Server are all examples of popular DBMSs used for managing databases. E-R diagrams refer to a type of diagram used to represent entities and their relationships in a database. DBAs, or Database Administrators, are individuals responsible for the maintenance, security, and management of databases. Data files refer to the actual files containing the data stored in a database. Therefore, the best choice in this case is D - DBMSs.

Question 16

​Which of the following statements is correct?​
A) ​In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.
B) ​User data cannot be combined and shared among authorized users.
C) Database users should not have access to the same information.​
D) The elimination of redundancy is always possible.​

Accepted Answer

This statement accurately describes how data is typically stored and managed in a nondatabase, file-oriented environment. Data is often spread across multiple systems and stored in separate files.

Option B is not correct because sharing and combining data is one of the primary advantages of using a database system.

Option C is incorrect because the whole purpose of a database system is to provide access to the same information to multiple users.

Option D is incorrect because it may not always be possible to eliminate redundancy, especially in complex data models.

Question 17

​____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.
A) ​Database design
B) ​Data independence
C) ​Integrity constraint
D) ​Data dependence

Accepted Answer

Data independence is the property that allows you to make changes to the database structure without affecting the programs that access the database. The other options, such as database design, integrity constraints, and data dependence, are related to the database structure but do not specifically refer to the ability to make changes without impacting programs.

Question 18

A DBMS lets you assign users to ____.​
A) ​groups
B) ​classes
C) ​attributes
D) ​clusters

Accepted Answer

A DBMS (Database Management System) lets you assign users to groups. This allows you to manage access permissions and restrict access to data based on user roles or functions within an organization. It also makes it easier to manage user accounts and revoke access when necessary. Classes, attributes, and clusters are also database-related terms, but they are not directly related to user management in a DBMS.

Question 19

​An integrity constraint is a rule that ____.
A) ​is kept in an external file
B) ​data must follow in the database
C) ​can be accessed only by authorized users
D) ​can unintentionally be accessed by unauthorized users

Accepted Answer

An integrity constraint is a rule that data must follow in the database to ensure data integrity and consistency. It is not usually stored in an external file, and may be enforced for all users of the system, including authorized and unauthorized users.

Question 20

A program,or collection of programs,through which users interact with a database is known as a(n)_________________________.​

Accepted Answer

The answer of A program,or collection of programs,through which users...

Quiz 1: Introduction to Database Management

____ are screen objects used to maintain,view,and print data from a database.

In an E-R diagram,____________________ represent entities.

During the ____ process,a database expert determines the structure of the required database.

Unlike a typical data file,a database can store information about multiple ____.

A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities,such as adding new data and deleting existing data.

In an E-R diagram,the ____________________ at the end of a line indicates the "many" part of the one-to-many relationship between two entities.

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.

In a(n)____________________ relationship between two entities,each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.

____ is the prevention of unauthorized access to the database.

In an E-R diagram,____________________ represent relationships between connected entities.

One disadvantage of a database system is ____.

A person who is in charge of a database within an organization is often called the database ____.

A database has ____ if the data in it satisfies all established integrity constraints.

A visual way to represent a database is with a(n) ____.

Popular ____ include Access,Oracle,DB2,MySQL,and SQL Server.

Which of the following statements is correct?

____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.

A DBMS lets you assign users to ____.

An integrity constraint is a rule that ____.

A program,or collection of programs,through which users interact with a database is known as a(n)_________________________.

Quiz 1: Introduction to Database Management

​____ are screen objects used to maintain,view,and print data from a database.

In an E-R diagram,____________________ represent entities.​

During the ____ process,a database expert determines the structure of the required database.​

​Unlike a typical data file,a database can store information about multiple ____.

​A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities,such as adding new data and deleting existing data.

In an E-R diagram,the ____________________ at the end of a line indicates the "many" part of the one-to-many relationship between two entities.

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.​

In a(n)____________________ relationship between two entities,each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.​

____ is the prevention of unauthorized access to the database.​

In an E-R diagram,____________________ represent relationships between connected entities.​

One disadvantage of a database system is ____.​

A person who is in charge of a database within an organization is often called the database ____.​

A database has ____ if the data in it satisfies all established integrity constraints.​

​A visual way to represent a database is with a(n) ____.

Popular ____ include Access,Oracle,DB2,MySQL,and SQL Server.​

​Which of the following statements is correct?​

​____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.

A DBMS lets you assign users to ____.​

​An integrity constraint is a rule that ____.

A program,or collection of programs,through which users interact with a database is known as a(n)_________________________.​

____ are screen objects used to maintain,view,and print data from a database.

In an E-R diagram,____________________ represent entities.

During the ____ process,a database expert determines the structure of the required database.

Unlike a typical data file,a database can store information about multiple ____.

A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities,such as adding new data and deleting existing data.

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.

In a(n)____________________ relationship between two entities,each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.

____ is the prevention of unauthorized access to the database.

In an E-R diagram,____________________ represent relationships between connected entities.

One disadvantage of a database system is ____.

A person who is in charge of a database within an organization is often called the database ____.

A database has ____ if the data in it satisfies all established integrity constraints.

A visual way to represent a database is with a(n) ____.

Popular ____ include Access,Oracle,DB2,MySQL,and SQL Server.

Which of the following statements is correct?

____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.

A DBMS lets you assign users to ____.

An integrity constraint is a rule that ____.

A program,or collection of programs,through which users interact with a database is known as a(n)_________________________.