FINAL EXAM

What is a DBMS? Select the best answer from the following.

A DBMS is a collection of programs enabling users to access databases, manipulate data, and present data.

What is a legacy database? Select the best answer from the following.

A database that predates the relational model or any system that predates current technology.

What is true of foreign keys. Select the best answer from the following.

A foreign key is a column or columns that is the same as the primary key of some table in the database.

What is an "ERD"? Select the best answer from the following.

An ERD is an Entity-Relationship diagram.

What is an "attribute"? Select the best answer from the following.

An attribute represents one of the columns in an individual table.

What is an "entity"? Select the best answer from the following.

An entity, for our purposes, is the same as a table in the database.

What is a relational database? Select the best answer from the following.

An organized collection of structured data, and information about relationships.

How should the components within Service Oriented Architecture be viewed? Select the best answer from the following.

Custom developed software.

The keywords within a T-SQL statement must always be in upper case. (True or False).

False

When joining tables in a Select statement there must exist a common column in both tables and it is a technical requirement that this column have the same name in each table. This statement is . . . Select the best answer from the following.

False

Which of the following are open source relational databases. Select all answers that apply.

Microsoft SQL Server. Oracle. DynamoDB.

Which of the following are tools are used in conducting needs assessments? Select all answers that apply.

Observation. Interviews. Questionnaires.

What is the most common relationship within a relational database? Select the best answer from the following.

One-To-Many relationship.

Relational Databases are designed for what specific kind of processing? Select the best answer from the following.

Online Transaction Processing (OLTP)

Which of the following is true when using an inner join? Select the best answer from the following.

Only rows that have related rows on both sides of the join are returned.

What is "Referential Integrity"? Select the best answer from the following.

Referential integrity is a constraint enforced by the DBMS that ensures consistency of the cross-references between and among tables.

Insert the correct commands for a basic select command that returns all rows and all columns specifying the proper selection, location, filter and sort keywords:

SELECT * FROM table name WHERE condition value(s) ORDER BY column(s)

In a web database architecture what is the primary concern? Select the best answer from the following.

Security.

The work of systems analysis includes all of the following except which one answer? Select the one answer that is not related to the work of systems analysis.

Systems analysis helps to ensure everyone in the organization understands the technical design of the database.

What is true with respect to a row's primary key? Select all answers that apply.

The primary key should contain a value that should never change; the value should be immutable. The primary key must not contain the value null. The primary key uniquely identifies each row in a table.

You know that you have a lot of old data in the Departments table, and many of the department names are no longer used—meaning that no employee rows are matched to these old department rows. Which is the best join to use if I want a list of Departments where there are no Employees related (matched) to those departments? Select the best answer from the following.

You can use either the left or right join to produce the result set needed.

The right join provides no additional functionality over the left join. Anything that can be accomplished with a right-join can also be accomplished with a left-join. This statement is . . . Select the best answer from the following.

True

Which of the following answers is the correct response to the issue/question of single-valued versus multivalued attributes? Select the best answer from the following.

In the design of a relational database there should never be multivalued attributes.

What is a "meaningful" identifier? Select the best answer from the following.

This generally is a key where the value of the key carries implicit meaning.

You have a table called Employees. For each employee there is a MangerID column. This column provides the employee number (also from the same Employees table) of the person who is the manager for the employee selected. If you wish to create a query that will show each employee and then their manager (remember the manager is simply an employee in the same table) which is the best join to use? Select the best answer from the following.

This is an example of a self-join.

Who determines what data needs to be secured to maintain privacy? Select the best answer from the following.

This is an issue that depends on the data itself. Depending on the data, government regulations might impact what a company otherwise would do to secure their data.

The 'T' in T-SQL stands for, what? Select the best answer from the following.

Transact