Question 1

Business intelligence (BI) has been ranked as one of the top nine "key areas" of current developments in business information technology.

Accepted Answer

Business intelligence has been recognized as a key area of current developments in business information technology.

Question 2

The DELETE command is the method used to delete a tuple from a relation.

Accepted Answer

The DELETE command in SQL is used to delete a tuple or row from a relation. Therefore, the statement "The DELETE command is the method used to delete a tuple from a relation" is true.

Question 3

A(n) ____ is an item of data that characterizes an entity or relationship.
A) agent
B) composite attribute
C) attribute
D) instance

Accepted Answer

An attribute is a characteristic or property of an entity or a relationship between entities. It describes the entity's or relationship's properties, features, or traits, and it represents a specific piece of information that can be stored in a database. Examples of attributes might include the name, age, address, or phone number of a person or the price, quantity, or description of a product.

Question 4

SQL is a powerful database language that can be used to define database systems, query the database for information, generate reports from the database, and access databases from within programs using embedded commands.

Accepted Answer

SQL (Structured Query Language) is a powerful language commonly used for managing and manipulating data in relational database systems. It can be used to create and modify database structures, insert, update, and delete data, and retrieve data using various types of queries. SQL also provides features for designing and implementing data security and access controls, as well as for optimizing and tuning the database system for optimal performance. Additionally, SQL can be used within application code to interact with database systems, making it a versatile language for managing data in a variety of contexts.

Question 5

Which of the following is the entity or agent?
A) Client
B) client number
C) client name
D) client street address

Accepted Answer

The entity or agent in this context is the "Client," as it represents the primary object or subject that interacts with or is managed within a system, whereas the other options (client number, client name, client street address) are attributes or properties of that entity.

Question 6

The secondary key is specified to uniquely identity each tuple in the relation.

Accepted Answer

The primary key is specified to uniquely identify each tuple in the relation. The secondary key is used for other purposes such as indexing or searching.

Question 7

A(n) ____ of an entity is one specific thing of the type defined by the entity.
A) agent
B) composite attribute
C) attribute
D) instance

Accepted Answer

An instance of an entity is one specific thing of the type defined by the entity. It represents a unique occurrence of the entity within the system being modeled. Options A, B, and C represent different concepts in database management but do not specifically reference a unique occurrence of an entity.

Question 8

Spreadsheets that are kept offline to an organization's enterprise systems can improve internal control.

Accepted Answer

Spreadsheets that are kept offline to an organization's enterprise systems may actually increase the risk of errors or fraud, as they are not subject to the same levels of security and monitoring as the larger enterprise systems. Integration with enterprise systems can improve internal control by automating processes, reducing manual input, and providing better oversight and auditing capabilities.

Question 9

A relation in an ER model is the same as an entity in the REA model.

Accepted Answer

A relation in an ER model represents a connection between entities, while an entity in the REA model represents a specific type of resource, event, or agent involved in a business process. They are not interchangeable concepts.

Question 10

Which of the following is the key attribute?
A) Client
B) client number
C) client name
D) client street address

Accepted Answer

The key attribute should be unique for each record and should not contain any null values. While client and client name can have duplicate values and client street address can have null values, client number is a unique identifier for each client record, making it the most appropriate key attribute.

Question 11

The DELETE command is used when we want to change one or more attribute values.

Accepted Answer

The DELETE command is used to delete data or records from a database, not to change attribute values. The UPDATE command is used to change attribute values.

Question 12

An entity can be classified as all of the following except:
A) resource
B) event
C) tuple
D) agent

Accepted Answer

A tuple is not a classification of an entity. It is a collection of related data stored in a database. Resources, events, agents are all classifications of entities.

Question 13

Queries of a database are driven by SELECT commands.

Accepted Answer

SELECT commands are used to retrieve data from a database through queries, therefore database queries are indeed driven by SELECT commands.

Question 14

The INSERT command is used to add a single tuple to an existing relation.

Accepted Answer

The INSERT command is indeed used to add a single tuple (i.e., a single row) to an existing relation (i.e., a table).

Question 15

The UPDATE command demonstrates one of the weaknesses in most forms of SQL.

Accepted Answer

The UPDATE command is a standard SQL operation used to modify existing data in a database. It does not inherently demonstrate a weakness in SQL; rather, it is a fundamental feature for data manipulation. SQL weaknesses typically relate to security, efficiency, or complexity in handling certain types of data or operations, not to basic commands like UPDATE.

Question 16

A missing value is called a non-null.

Accepted Answer

A missing value is called a null, not a non-null.

Question 17

Most DBMS available today that include SQL also include mechanisms within the DBMS itself for establishing and enforcing referential integrity.

Accepted Answer

Most modern DBMS that utilize SQL (Structured Query Language) indeed incorporate built-in mechanisms to establish and enforce referential integrity, such as foreign keys and constraints, ensuring data consistency and accuracy across related tables.

Question 18

Relational integrity specifies that for every attribute value in one relation that has been specified to allow reference to another relation, the tuple being referenced must remain intact.

Accepted Answer

Relational integrity ensures that referential constraints are maintained between related tables in a database, meaning that the referenced tuples must remain unchanged for the referencing tuples to be valid.

Question 19

Knowledge management uses state-of-the art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

Accepted Answer

The answer of Knowledge management uses state-of-the art information technologies...

Question 20

Composite attributes consist of multiple subattributes.

Accepted Answer

Composite attributes are those attributes which have subattributes. For example, an address attribute may have subattributes like street, city, state, and zip code.

Quiz 6: Relational Databases and SQL