A.an entity

B.label

C.a cardinality

D.an attribute

E.an optionality

F.a unique identifier

A.You must have SELECT privileges on a table to view it in ALL _TABLES.

B.ALL TABLES displays all tables owned by the current user.

C.All users can query DBA TABLES successfully.

D.You must have SELECT privileges on a table to view it in DBA TABLES.

E.You must have SELECT privileges on a table to view it in USER TABLES.

F.USER_ TABLES displays all tables owned by the current user.

A.Option C

B.Option D

C.Option E

D.Option A

E.Option B

A.It succeeds and an index is created for CITIZEN_ID.

B.It succeeds and CITY can contain only 'SEATTLE' or null for all rows.

C.It fails because the NOT NULL and DEFAULT options cannot be combined for the same column.

D.It fails because the condition for the CNAMES constraint is not valid.

A.SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)FROM invoice;

B.SELECT inv_no,NVL2(inv_date,'Pending','Incomplete')FROM invoice;

C.SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available')FROM invoice;

D.SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available')FROM invoice;