MCQ:-

Question 11 You usually use _______ to reference data values that programs retrieve from the DB.

scalar variables

composite variables

records

varray

Question 12 When creating DB tables that contain foreign key references to other tables, you must:

first create the table in which the primary key is a foreign key

first create the table in which the foreign key is a primary key

first remove all integrity constraints

it does not matter, you are free to create any table first

Question 13 The 99MI format model does one of the following:

prefaces negative value with minus sign as in -12

displays minutes together with the hours as in 12:34

displays months as digits as in 12 months

displays Medium-size-Integers, i.e. with no decimal point

Question 14 The following function:

rpad('CIT', 5, '.');

would return:

'CIT.....'

'.....CIT'

'CIT..'

'..CIT'