True

False

White-box

Black-box

Grey-box

None

It becomes Obsolete

It becomes Frozen

It is still available for Modeling

None of above

Adaptation

Assembly

Qualification

Maintenance

Generate Code

Fetch New Shared Model

Release to Shared pool

Track Model changes

Component can exist outside workspace

Dependencies can be defined between Components

Component and Class are same entities

Component can have Interfaces

a special type of table

a special type of store procedure, executed when certain event occurs

a special type of view

a dynamic procedure

checks if the table has primary key specified

Deletes the table

deletes all rows from a table

change the structure of the table

Header

Declarative

Executable

Exception

AFTER statement trigger

INSERT row trigger

DELETE row trigger

All of the above

When a SELECT statement returns no rows

When a SELECT statement returns more than one row

When the datatypes of SELECT clause and INTO clause do not match

When INTO statement is missing in the SELECT statement

NULL

0

Results in a compilation error

An exception will be raised

TO_CHAR

LOWER

LPAD

MAX

Header

Declarative

Executable

Exception

SELECT ADD(Price) FROM Sales

SELECT SUM(Price) WHERE Sales

SELECT TOTAL(Price) FROM Sales

SELECT SUM(Price) FROM Sales

SELECT COUNT(*) FROM Sales

SELECT COUNT(*) IN Sales

SELECT COUNTER(*) FROM Sales

SELECT NUM() FROM Sales

OF(11) is: 45

OF(11) is: 56

OF(11) is: 89

OF(11) is: 111

Compilation fails

An exception is thrown at runtime.

int y = x;

int y = 10;

int y = 11;

int y = 12;

int y = 13;

None of the above will allow compilation to succeed

-

-c

-c2

-2c

-c22b

-2c2b

8

8 7

8 7 6

Compilation fails

An exception is thrown at runtime