FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Relational Databases and SQL

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following commands allow us to join data across multiple tables to link specific pieces of information that are of interest?

A) Select
B) Project
C) Join
D) Display

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Which relationship type does (1:N) mean?

A) one-to-many
B) one-to-one
C) one-to-few
D) many-to-many

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 43

Essay

Review LaterAdd Note

The following table is a view of TRAINING_COMPLETED from the various data elements in High-Tech Corp.'s relational database: Required: a. Using proper SQL commands,develop a query to extract training data for employee Missy Pitman (employee number 11111),showing the date,hours,and training code. b. Design a table showing the output that would be generated based upon your query created above.

REA stands for resources,entities and agents.

Which is not a step in creating a relation using SQL?

In a relational database,the entity is represented as a(n) :

Relationships map and define the way in which data can be extracted from a database.

The mapping of the relationships between entities would be used in the development of a(n) :

The ______________________________ specifies how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship.

In a relational database,a relation is defined as a collection of data representing multiple occurrences of the following except:

A(n) ____ is an item of data that characterizes an entity or relationship.

The cardinality constraint is used to specify both the minimum and maximum participation of one entity in the relationship with the other entity.

An entity can be classified as all of the following except:

For the following entity and attribute model,what would be the key attribute of the Students entity?

A collection of data representing multiple occurrences of a resource,event,or agent is known as a(n)______________________________.

A recursive relationship occurs between two different instances of an entity.

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.

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

Composite attributes consist of multiple subattributes.

Attributes that consist of multiple subattributes are referred to as ______________________________.