sql study

Which SQL keyword is used to separate two conditions when both must be true for the rows(records) to be selected?

AND

One or more attributes or attribute collections (composite) that can potentially be used as a primary key are called ________ keys.

Candidate

A join in which each row in one table is matched to every row in a second table is called a(n) ________ join.

Cartesian Product or Cross Join

Which of the following cannot be done using the CONSTRAINT phrase?

Create a second (candidate) primary key

Which SQL Keyword/phrase is used to eliminate duplicate rows in the results of a SQL SELECT query?

DISTINCT

Which SQL keyword is used to remove one or more rows (records) from a table?

Delete

Which of the following keywords is used in most SELECT statements?

FROM

Inner Joins are limited to joining just two tables. If you need to join three or more tables, a different type of JOIN is required.

False

Subqueries can do everything JOINs can do and some things a JOIN cannot do.

False

A(n) ________ join returns the selected columns for all the rows in chosen tables that have a related row in the joined table.

Inner

A(n) ________ occurs when we can't insert facts about one entity until we insert facts about another entity.

Insertion Anomaly

When representing a many-to-many relationship in a data model, a(n) ________ relation/table must be created.

Intersection/Linking

Which keyword is used to select a record if the column/field value meets any of the criteria listed?

OR

The attribute or attribute collection (composite) which is chosen from the available candidates to uniquely identify each row is called the ________ key.

Primary

A _____ key is often used in place of a composite primary key.

Surrogate

1411Server.TutorCenter.dbo.Tutor.TutorKey is a valid example of a fully qualified name.

True

Joins allow the user to reunite elements that have been split into a single result set.

True

In this qualified name , 1411Server.TutorCenter.dbo.Tutor.TutorKey, what is the name of the database?

TutorCenter

Which SQL keyword is used to modify one or more rows (records) from a table?

Update

Which SQL keyword is used to apply conditions to restrict records that are included in the results of a SELECT query?

WHERE

A(n) _____ is a substitute name for a column or table.

alias

To avoid an ambiguous reference in an SQL statement, it is recommended that you use a ________.

quailified name

In a relation (table), the order of ________________.

rows and columns is not significant (does not matter).

An anomaly in a relation (table) is a(n):

undesirable consequence