Set - 6

Question 71 :

What are the data types allowed in a table ?

Answer :

CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.


Question 72 :

What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Answer :

CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.


Question 73 :

Can a view be updated/inserted/deleted? If Yes under what conditions ?

Answer :

A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.


Question 74 :

What are the different types of Coordinations of the Master with the Detail block?

Answer :

POPULATE_GROUP(function)
POPULATE_GROUP_WITH_QUERY(function)
SET_GROUP_CHAR_CELL(procedure)
SET_GROUPCELL(procedure)
SET_GROUP_NUMBER_CELL(procedure)


Question 75 :

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time?
I) TRUE II) FALSE

Answer :

II) FALSE