QUESTION 26
Which relationship exists between occurrences of the same entity types?

QUESTION 27
Which type of join is demonstrated by the following query?
sql
SELECT *
FROM Make, Model
WHERE Make.ModelID = Model.ID;

QUESTION 28
Which clause is used to specify the join columns when performing a join in MySQL?

QUESTION 29
Which capability should databases maintain to simplify the use of SQL with a general-purpose language?

QUESTION 30
What is the role of the database administrator?

QUESTION 31
Which type of join selects all the rows from both the left and right table, regardless of match?

QUESTION 32
Which relationship is shown in the following diagram?

QUESTION 33
Which function removes only the leading spaces from a string?

QUESTION 34
Which syntax feature classifies the explicit string, numeric, or binary values used in SQL queries?

QUESTION 35
Which description defines a data type?

QUESTION 36
Which function is considered an aggregate function?

QUESTION 37
Which term refers to a path from a top-level block to a bottom-level block?

QUESTION 38
Which property is associated with a one-field primary key?

QUESTION 39
Which action does the % operator accomplish in MySQL?

QUESTION 40
How can a primary key constraint be added after the table is created?

QUESTION 41
Which constraint propagates primary key changes to foreign keys?

QUESTION 42
Which primary key values consist of a single field only?