Which attribute type is derived from other attributes?

Question $26$ options:

Multivalued Attribute

Derived Attribute

Composite Attribute

Simple Attribute

Question $27(1$ point$)$

What kind of constraint limits the values that can be stored in a column?

Question $27$ options:

size constraint

values constraint

check constraint

integrity constraint

Question $28(1$ point$)$

What kind of constraint enforces referential integrity between tables?

Question $28$ options:

reference constraint

foreign key constraint

both a and b

none of the above

Question $29(1$ point$)$

Which SQL keyword is used to sort the result set?

Question $29$ options:

ORDER

ORDER BY

SORT

SORT BY

Question $30(1$ point$)$

To concatenate character strings in a string expression, which operator do you use?

Question $30$ options:

$+$

$-$

$*$

$=$

Question $31(1$ point$)$

Which symbol is used to represent an entity in an ERD?

Question $31$ options:

Diamond

Rectangle

Ellipse

Oval

Question $32(1$ point$)$

In an ERD, a relationship is depicted using which symbol?

Question $32$ options:

Oval

Rectangle

Diamond

Triangle

Question $33(1$ point$)$

Which of the following is not a valid column alias name?

Question $33$ options:

Total

Total Sales

TotalSales

"Total Sales"

Question $34(1$ point$)$

If you want to filter the result set that$$s returned by a SELECT statement, you must include which clause?

Question $34$ options:

WHERE

FROM

ORDER BY

SELECT

Question $35(1$ point$)$

What does "ordinality" refer to in the context of database design?

Question $35$ options:

The range of allowable values for an attribute

The minimum number of instances of one entity that can be associated with each instance of another entity

The number of entities in a database

The order in which data is entered into the database

Question $36(1$ point$)$

Which clause of the SELECT statement names the table that contains the data to be retrieved?

Question $36$ options:

WHERE

FROM

ORDER BY

SELECT

Question $37(1$ point$)$

A relationship where each entity instance is related to at most one instance of another entity is known as

Question $37$ options:

One$-$to$-$Many

One$-$to$-$One

Many$-$to$-$Many

Many$-$to$-$One

Question $38(1$ point$)$

Which type of relationship involves three entities?

Question $38$ options:

Quaternary

Ternary

Binary

Unary

Question $39(1$ point$)$

The search condition of a WHERE clause consists of one or more

Question $39$ options:

string expressions

Boolean expressions

numeric expressions

none of the above

Question $40(1$ point$)$

When you code a SELECT statement, you must code the four main clauses in the following order

Question $40$ options:

SELECT, FROM, ORDER BY$,$ WHERE

SELECT, ORDER BY$,$ FROM, WHERE

SELECT, WHERE, ORDER BY$,$ FROM

SELECT, FROM, WHERE, ORDER BY