When coded within a SELECT clause, which TOP clause will return a result set consisting of the ten largest InvoiceNumbers?

Question $11$ options:

TOP $10$ InvoiceNumber

TOP $10$ InvoiceTotal

TOP $10$ PERCENT InvoiceNumber

TOP $10$ PERCENT WITH TIES InvoiceNumber

TOP InvoiceNumber, InvoiceTotal

Question $12(1$ point$)$

The order of precedence for the logical operators in a WHERE clause is

Question $12$ options:

Not, And, Or

And, Or$,$ Not

Or$,$ And, Not

Not, Or$,$ And

Question $13(1$ point$)$

When coded in a WHERE clause, which search condition will return invoices when PaymentDate is not null and InvoiceTotal is greater than or equal to $$500?$

Question $13$ options:

PaymentDate IS NULL AND InvoiceTotal $>500$

PaymentDate IS NOT NULL OR InvoiceTotal $>=500$

NOT $($PaymentDate IS NULL AND InvoiceTotal $<=500)$

PaymentDate IS NOT NULL AND InvoiceTotal $>=500$

Question $14(1$ point$)$

When you define a foreign key constraint, you can specify all but one of the following. Which one is it$?$

Question $14$ options:

that no action should be taken and an error should be returned when a related row in a related table is deleted or updated

that the deletion of a related row in a primary key table should be cascaded down to the rows in the foreign key table

that the insertion of a row in a foreign key table that has a foreign key that isn$$t matched in the primary key table should be cascaded up to the primary key table

that the updating of a primary key in a primary key table should be cascaded down to the rows in the foreign key table

Question $15(1$ point$)$

Unless you assign a $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_,$ the column name in the result set is the same as the column name in the base table.

Question $15$ options:

unique syntax

column alias

qualification

all of the above

Question $16(1$ point$)$

A combination of column names and operators that evaluate to a single value is called

Question $16$ options:

a query

an expression

a predicate

a view

Question $17(1$ point$)$

Which keyword lets you control the number of rows that are returned by a query?

Question $17$ options:

ALL

DISTINCT

TOP

all of the above

Question $18(1$ point$)$

To sort the records that are retrieved by a SELECT statement in descending sequence what keyword do you code at the end of the ORDER BY clause?

Question $18$ options:

ALL

DISTINCT

DESC

ASC

Question $19(1$ point$)$

A string expression can consist of

Question $19$ options:

one or more character columns

one or more literal values

a combination of character columns and literal values

all of the above

Question $20(1$ point$)$

Each of the following column attributes is a column constraint, except

Question $20$ options:

NOT NULL

UNIQUE

DEFAULT

PRIMARY KEY

Question $21(1$ point$)$

Which of the following best describes cardinality in an ERD?

Question $21$ options:

The specific values an attribute can take

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

The number of attributes an entity has

The number of entities involved in a relationship

Question $22(1$ point$)$

To override the order of precedence in an arithmetic expression, you can use

Question $22$ options:

parentheses

single quotes

double quotes

braces

Question $23(1$ point$)$

Which of the following is not a type of entity in an Entity$-$Relationship Diagram $($ERD$)?$

Question $23$ options:

Strong Entity

Weak Entity

Dependent Entity

Associative Entity

Question $24(1$ point$)$

Which keyword can you use to retrieve rows in which an expression matches a string pattern called a mask?

Question $24$ options:

OR

ORDER BY

WHERE

LIKE

Question $25(1$ point$)$

The NOT NULL constraint enforces a column to not accept empty values.

Question $25$ options:

True

False