Question 71 :
What are the data types allowed in a table ?
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 ?
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 ?
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?
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