Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. Composite objects can be nested in a hierarchy. a. TRUE b. FALSE 2. Where can

ID: 3582521 • Letter: 1

Question

1. Composite objects can be nested in a hierarchy.

a. TRUE b. FALSE

2. Where can a CASE be used?

a. A WHERE clause

b. A HAVING clause

c. None of these can hold a CASE.

d. All three of these can hold a CASE.

e. The ON clause of a JOIN

3. Reusable programs that are assembled with other components to create complete applications are called hardware components.

Select one:

a. TRUE

b. FALSE

4. Which of the following is NOT a design concept?

Select one:

a. use case

b. pattern

c. component

d. reuse

5.

What data type is used to store the quantity of time between two dates or times?

Select one:

a. EXACT NUMERIC

b. DATETIME

c. INTERVAL

d. APPROXIMATE NUMERIC

6.

What CASE expression is used to perform more complex comparisons, such as greater than, less than, IN, BETWEEN, or EXISTS?

Select one:

a. Simple when clause

b. Both a simple and a searched when clause

c. Searched when clause

d. Neither a simple nor a searched when clause

7.

Exception steps signify ________.

Select one:

a. Failure

b. neither A or B

c. Remedies

d. either A or B

8.

"getMenu()" is an example of ________.

Select one:

a. an object

b. a value

c. data

d. an argument

Explanation / Answer

1. Composite objects can be nested in a hierarchy.
a. TRUE b. FALSE

Ans: a , Composite objects are union of nested objects and class hierarchies.


2. Where can a CASE be used?
a. A WHERE clause
b. A HAVING clause
c. None of these can hold a CASE.
d. All three of these can hold a CASE.
e. The ON clause of a JOIN

Ans: c, As case is used like an if/else condition in sql


3. Reusable programs that are assembled with other components to create complete applications are called hardware components.
Select one:
a. TRUE
b. FALSE

Ans: a

4. Which of the following is NOT a design concept?
Select one:
a. use case
b. pattern
c. component
d. reuse

Ans: use case

5.
What data type is used to store the quantity of time between two dates or times?
Select one:
a. EXACT NUMERIC
b. DATETIME
c. INTERVAL
d. APPROXIMATE NUMERIC

Ans: INTERVAL


6.
What CASE expression is used to perform more complex comparisons, such as greater than, less than, IN, BETWEEN, or EXISTS?
Select one:
a. Simple when clause
b. Both a simple and a searched when clause
c. Searched when clause
d. Neither a simple nor a searched when clause


Ans: a

7.
Exception steps signify ________.
Select one:
a. Failure
b. neither A or B
c. Remedies
d. either A or B


Ans: Failure


8.
"getMenu()" is an example of ________.
Select one:
a. an object
b. a value
c. data
d. an argument


Ans: a