- What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window
a] Both windows behave the same way as far as moving the window is concerned.
b] A document window can be moved outside the application window while a dialog window cannot be moved
c] A dialog window can be moved outside the application window while a document window cannot be moved
Ans : C
2. What is the difference between a MESSAGEBOX and an ALERT
a] A messagebox can be used only by the system and cannot be used in user application while an alert can be used in user application also.
b] A alert can be used only by the system and cannot be use din user application while an messagebox can be used in user application also.
c] An alert requires an response from the user while a messagebox just flashes a message and only requires an acknowledgment from the user
d] An message box requires an response from the user while a alert just flashes a message an only requires an acknowledgment from the user
Ans : C
3. Which of the following is not an reason for the fact that most of the processing is done at the server ?
a] To reduce network traffic. b] For application sharing, c] To implement business rules centrally, d] None of the above
Ans : D
4. Can a DIALOG WINDOW have scroll bar attached to it ?
a] Yes, b] No
Ans : B
5. Which of the following is not an advantage of GUI systems ?
a] Intuitive and easy to use., b] GUI's can display multiple applications in multiple windows
c] GUI's provide more user interface objects for a developer
d] None of the above
Ans :D
6.. What is the difference between a LIST BOX and a COMBO BOX ?
a] In the list box, the user is restricted to selecting a value from a list but in a combo box the user can type in a value which is not in the list
b] A list box is a data entry area while a combo box can be used only for control purposes
c] In a combo box, the user is restricted to selecting a value from a list but in a list box the user can type in a value which is not in the list
d] None of the above
Ans : A
7. In a CLIENT/SERVER environment , which of the following would not be done at the client ?
a] User interface part, b] Data validation at entry line, c] Responding to user events, d] None of the above
Ans : D
8. Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?
a] Because an integrity constraint is automatically checked while data is inserted into or updated in a table while a stored procedure has to be specifically invoked
b] Because the stored procedure occupies more space in the database than a integrity constraint definition
c] Because a stored procedure creates more network traffic than a integrity constraint definition
Ans : A
9. Which of the following is not an advantage of a client/server model ?
a] A client/server model allows centralized control of data and centralized implementation of business rules.
b] A client/server model increases developer's productivity
c] A client/server model is suitable for all applications
d] None of the above.
Ans : C
10. What does DLL stands for ?
a] Dynamic Language Library
b] Dynamic Link Library
c] Dynamic Load Library
d] None of the above
Ans : B
11. POST-BLOCK trigger is a
a] Navigational trigger
b] Key trigger
c] Transactional trigger
d] None of the above
Ans : A
12.. The system variable that records the select statement that SQL * FORMS most recently used to populate a block is
a] SYSTEM.LAST_RECORD
b] SYSTEM.CURSOR_RECORD
c] SYSTEM.CURSOR_FIELD
d] SYSTEM.LAST_QUERY
Ans: D
13. Which of the following is TRUE for the ENFORCE KEY field
a] ENFORCE KEY field characterstic indicates the source of the valuethat SQL*FORMS uses to populate the field
b] A field with the ENFORCE KEY characterstic should have the INPUT ALLOWED charaterstic turned off
a] Only 1 is TRUE
b] Only 2 is TRUE
c] Both 1 and 2 are TRUE
d] Both 1 and 2 are FALSE
Ans : A
14.. What is the maximum size of the page ?
a] Characters wide & 265 characters length
b] Characters wide & 265 characters length
c] Characters wide & 80 characters length
d] None of the above
Ans : B
15. A FORM is madeup of which of the following objects
a] block, fields only,
b] blocks, fields, pages only,
c] blocks, fields, pages, triggers and form level procedures,
d] Only blocks.
Ans : C
16. For the following statements which is true
1] Page is an object owned by a form
2] Pages are a collection of display information such as constant text and graphics.
a] Only 1 is TRUE
b] Only 2 is TRUE
c] Both 1 & 2 are TRUE
d] Both are FALSE
Ans : B
17. The packaged procedure that makes data in form permanent in the Database is
a] Post
b] Post form
c] Commit form
d] None of the above
Ans : C
18. Which of the following is TRUE for the SYSTEM VARIABLE $$date$$
a] Can be assigned to a global variable
b] Can be assigned to any field only during design time
c] Can be assigned to any variable or field during run time
d] None of the above
Ans : B
19. Which of the following packaged procedure is UNRESTRICTED ?
a] CALL_INPUT, b] CLEAR_BLOCK, c] EXECUTE_QUERY, d] USER_EXIT
Ans : D
20. Identify the RESTRICTED packaged procedure from the following
a] USER_EXIT, b] MESSAGE, c] BREAK, d] EXIT_FORM
Ans : D
21. What is SQL*FORMS
a] SQL*FORMS is a 4GL tool for developing & executing Oracle based interactive applications.
b] SQL*FORMS is a 3GL tool for connecting to the Database.
c] SQL*FORMS is a reporting tool
d] None of the above.
Ans : A
22. Name the two files that are created when you generate a form using Forms 3.0
a] FMB & FMX, b] FMR & FDX, c] INP & FRM, d] None of the above
Ans : C
23. What is a trigger
a] A piece of logic written in PL/SQL
b] Executed at the arrival of a SQL*FORMS event
c] Both A & B
d] None of the above
Ans : C
24. Which of the following is TRUE for a ERASE packaged procedure
1] ERASE removes an indicated Global variable & releases the memory associated with it
2] ERASE is used to remove a field from a page
1] Only 1 is TRUE
2] Only 2 is TRUE
3] Both 1 & 2 are TRUE
4] Both 1 & 2 are FALSE
Ans : 1
25. All datafiles related to a Tablespace are removed when the Tablespace is dropped
a] TRUE
b] FALSE
Ans : B
26. Size of Tablespace can be increased by
a] Increasing the size of one of the Datafiles
b] Adding one or more Datafiles
c] Cannot be increased
d] None of the above
Ans : B
27. Multiple Tablespaces can share a single datafile
a] TRUE
b] FALSE
Ans : B
28. A set of Dictionary tables are created
a] Once for the Entire Database
b] Every time a user is created
c] Every time a Tablespace is created
d] None of the above
Ans : A
29. Data dictionary can span across multiple Table spaces
a] TRUE
b] FALSE
Ans : B
30. What is a DATABLOCK
a] Set of Extents
b] Set of Segments
c] Smallest Database storage unit
d] None of the above
Ans : C
31. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint
a] Yes
b] No
Ans : B
32. A column defined as PRIMARY KEY can have NULL's
a] TRUE
b] FALSE
Ans : B
33. A Transaction ends
a] Only when it is Committed
b] Only when it is Rolled back
c] When it is Committed or Rolled back
d] None of the above
Ans : C
34. A Database Procedure is stored in the Database
a] In compiled form
b] As source code
c] Both A & B
d] Not stored
Ans : C
35. A database trigger doesn't apply to data loaded before the definition of the trigger
a] TRUE
b] FALSE
Ans : A
36. Dedicated server configuration is
a] One server process - Many user processes
b] Many server processes - One user process
c] One server process - One user process
d] Many server processes - Many user processes
Ans : C
37. Which of the following does not affect the size of the SGA
a] Database buffer
b] Redo log buffer
c] Stored procedure
d] Shared pool
Ans : C
1.void main()
{
struct a
{
char ch[10];
char *str;
};
struct a s1={" Hyderabad "," Bangalore "};
printf("
%c%c",s1.ch[0],*s1.str);
printf("
%s%s",s1.ch,s1.str);
getch();
}
Ans: HB, HyderabadBangalor
2. main(int argc,int *argv[])
{
int i;
for(i=1;i
printf("
%s%s",argv[i],(i
return 0;
getch();
}
file://
Ans: i work for oracle
3.void main()
{
int i,j,k;
for(i=0;i<3;i++)
k=sum(i,i);
printf("
%d",k);
getch();
}
sum(s,t)
{
static int m;
m+=s+t;
return m;
}
file://
Ans: 6
4.void main()
{
int i;
clrscr();
for(i=1;i<6;++i)
switch(i)
{
case 1:
case 2: printf("%d,",i++);break;
case 3: continue;
case 4: printf("%d,",i);
}
printf("%d",i);
getch();
}
file://Ans: 1,4,6
5.Which of the storage classes becomes the global variables for the entire Program
(A) Extern
(B) Static
(C) Auto
(D) Register
ANS : A
6.What is the output of the program
void main()
{
char s[]="oracle is the best";
char t[40];
char *ss,*tt;
while(*tt++=*ss++);
printf("%s",t);
getch();
}
A. oracle is the best
B. Core dump
c. Error Message
D. Goes into infinite loop
Ans: B. core dump (Garbage value)
7.What is the output of the program
void main()
{
int j[10]={9,7,5,3,1,2,4,6,9};
int i=1;
clrscr();
for(;i<9;i++)
printf("%d ",--j[i++]);
getch();
}
A. 6,2,1,5
B. 6,2,1,5,7
c. Error Message
D. core dump
Ans: A. 6,2,1,5
8.What is the output of the program
void main()
{
int i,j,k,n=5;
clrscr();
for(i=5;i>0;i--)
{
j=1
k=n&j;
k==0?printf("0"):printf("1");
}
getch();
}
A. 00011
B. 11110
c. 11001
D. 11100
Ans: B. 11110
9.Which of the following storage classes became the global variable for the entire program
A. Extern
B. Static=20
c. Auto
D. Register
Ans: A
10.What is the output of the program, if integer occupies 2 bytes = memory?
union
{
int a;
char b;
char c[10];
}u1;
void main()
{
int l=sizeof(u1);
printf("%d",l);
getch();
}
A. 13
B. 10
c. 16
D. None of the above
Ans: B. 10
11.What is the output of the program
void main()
{
fork();
printf(" Hello World");
getch();
}
A. Hello World
B. Hello World Hello World
c. Error Message
D. None of these
Ans: B
12.What is the output of the program
void main()
{
struct a
{
int i;
char *st1;
};
typedef struct a ST;
ST *str1;
str1=(ST*)malloc(100);
str1->i=100;
strcpy(str1->st1,"Welcome to Oracle");
printf(" %d%s
",str1->i,str1->st1);
getch();
}
A. core dump
B. will not compile
c. 100,Welcome to Oracle
D. None of these
Ans: C
13.What is the output of the program
void main()
{
int i,j,k;
i=2;
j=4;
k=i++>j&2;
printf("%d
",k);
if(++k && ++i<--j|| i++)
{
j=++k;
}
printf(" %d %d %d",i,-j--,k);
getch();
}
A. 4,-3,2
B. 5,-3,2
c. 4,-2,2
D. 5,-2,2
Ans: D
14.Which of the following is not true incase of Command line arguments
A. The argc parameter is used to hold the number of arguments in the = command line and is an integer
B. The argv parameter is a pointer to an array of a character = pointer and each one points to command line arguments
C. The argv[1] always point to program name
D. None of above
Ans: C
{
struct a
{
char ch[10];
char *str;
};
struct a s1={" Hyderabad "," Bangalore "};
printf("
%c%c",s1.ch[0],*s1.str);
printf("
%s%s",s1.ch,s1.str);
getch();
}
Ans: HB, HyderabadBangalor
2. main(int argc,int *argv[])
{
int i;
for(i=1;i
printf("
%s%s",argv[i],(i
return 0;
getch();
}
file://
Ans: i work for oracle
3.void main()
{
int i,j,k;
for(i=0;i<3;i++)
k=sum(i,i);
printf("
%d",k);
getch();
}
sum(s,t)
{
static int m;
m+=s+t;
return m;
}
file://
Ans: 6
4.void main()
{
int i;
clrscr();
for(i=1;i<6;++i)
switch(i)
{
case 1:
case 2: printf("%d,",i++);break;
case 3: continue;
case 4: printf("%d,",i);
}
printf("%d",i);
getch();
}
file://Ans: 1,4,6
5.Which of the storage classes becomes the global variables for the entire Program
(A) Extern
(B) Static
(C) Auto
(D) Register
ANS : A
6.What is the output of the program
void main()
{
char s[]="oracle is the best";
char t[40];
char *ss,*tt;
while(*tt++=*ss++);
printf("%s",t);
getch();
}
A. oracle is the best
B. Core dump
c. Error Message
D. Goes into infinite loop
Ans: B. core dump (Garbage value)
7.What is the output of the program
void main()
{
int j[10]={9,7,5,3,1,2,4,6,9};
int i=1;
clrscr();
for(;i<9;i++)
printf("%d ",--j[i++]);
getch();
}
A. 6,2,1,5
B. 6,2,1,5,7
c. Error Message
D. core dump
Ans: A. 6,2,1,5
8.What is the output of the program
void main()
{
int i,j,k,n=5;
clrscr();
for(i=5;i>0;i--)
{
j=1
k=n&j;
k==0?printf("0"):printf("1");
}
getch();
}
A. 00011
B. 11110
c. 11001
D. 11100
Ans: B. 11110
9.Which of the following storage classes became the global variable for the entire program
A. Extern
B. Static=20
c. Auto
D. Register
Ans: A
10.What is the output of the program, if integer occupies 2 bytes = memory?
union
{
int a;
char b;
char c[10];
}u1;
void main()
{
int l=sizeof(u1);
printf("%d",l);
getch();
}
A. 13
B. 10
c. 16
D. None of the above
Ans: B. 10
11.What is the output of the program
void main()
{
fork();
printf(" Hello World");
getch();
}
A. Hello World
B. Hello World Hello World
c. Error Message
D. None of these
Ans: B
12.What is the output of the program
void main()
{
struct a
{
int i;
char *st1;
};
typedef struct a ST;
ST *str1;
str1=(ST*)malloc(100);
str1->i=100;
strcpy(str1->st1,"Welcome to Oracle");
printf(" %d%s
",str1->i,str1->st1);
getch();
}
A. core dump
B. will not compile
c. 100,Welcome to Oracle
D. None of these
Ans: C
13.What is the output of the program
void main()
{
int i,j,k;
i=2;
j=4;
k=i++>j&2;
printf("%d
",k);
if(++k && ++i<--j|| i++)
{
j=++k;
}
printf(" %d %d %d",i,-j--,k);
getch();
}
A. 4,-3,2
B. 5,-3,2
c. 4,-2,2
D. 5,-2,2
Ans: D
14.Which of the following is not true incase of Command line arguments
A. The argc parameter is used to hold the number of arguments in the = command line and is an integer
B. The argv parameter is a pointer to an array of a character = pointer and each one points to command line arguments
C. The argv[1] always point to program name
D. None of above
Ans: C
2. What is the User-Named Editor?
ANS:-A user named editor has the same text editing functionality as the default editor, but, becaue it is a named object, you can specify editor attributes such as windows display size, position, and title.
3. What are the Built-ins to display the user-named editor?
ANS:-A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.
4. What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
ANS:-Show editor is the generic built_in which accepts any editor name and takes some input string and returns modified output string. Whereas the edit_textitem built_in needs the input focus to be in the text item before the built_in is excuted.
5. What is an LOV?
ANS:-An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.
6. What is the basic data structure that is required for creating an LOV?
ANS:-Record Group.
7. What is the "LOV of Validation" Property of an item? What is the use of it?
ANS:-When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV.
Whenever the validation event occurs. If the value in the text item matches one of the values in the first column of the LOV, validation succeeds, the LOV is not displayed, and processing continues normally. If the value in the text item does not match one of the values in the first column of the LOV, Oracle Forms displays the LOV and uses the text item value as the search criteria to automatically reduce the list.
8. What are the built_ins used the display the LOV?
ANS:-Show_lov , List_values
9. What are the built-ins that are used to Attach an LOV programmatically to an item?
ANS:-set_item_property, get_item_property (by setting the LOV_NAME property)
10.. What are the built-ins that are used for setting the LOV properties at runtime?
ANS:-get_lov_property , set_lov_property
11. What is a record group?
ANS:-A record group is an internal Oracle Forms that structure that hs a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to the form module which they are defined.
12. How many number of columns a record group can have?
ANS:-A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.
13. What is the Maximum allowed length of Record group Column?
ANS:-Record group column names cannot exceed 30 characters.
14. What are the different types of Record Groups?
ANS:-Query Record Groups, NonQuery Record Groups, State Record Groups
15. What is a Query Record Group?
ANS:-A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns referenced in the SELECT statement. The records in query record group are the rows retrieved by the query associated with that record group.
16. What is a Non Query Record Group?
ANS:-A non-query record group is a group that does not have an associated query, but whose structure and values can be modified programmatically at runtime.
17. What is a Static Record Group?
ANS:-A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at runtime.
18. What are the built-ins used for Creating and deleting groups?
ANS:-CREATE-GROUP (function)
CREATE_GROUP_FROM_QUERY(function)
DELETE_GROUP(procedure)
19.What are the built -ins used for Modifying a group's structure?
ANS:-ADD-GROUP_COLUMN (function)
ADD_GROUP_ROW (procedure)
DELETE_GROUP_ROW(procedure)
20. What are the built-ins used for Getting cell values?
ANS:-GET_GROUP_CHAR_CELL (function)
GET_GROUP_DATE_CELL(function)
GET_GROUP_NUMBET_CELL(function)
21. What are built-ins used for Processing rows?
ANS:-GET_GROUP_ROW_COUNT(function)
GET_GROUP_SELECTION_COUNT(function)
GET_GROUP_SELECTION(function)
RESET_GROUP_SELECTION(procedure)
SET_GROUP_SELECTION(procedure)
UNSET_GROUP_SELECTION(procedure)
23. What are the built-ins used for finding Object ID function?
ANS:-FIND_GROUP(function)
FIND_COLUMN(function)
24.. Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time.
I) TRUE II)FALSE
II) FALSE
25.. Use the ADD_GROUP_ROW procedure to add a row to a static record group
I) TRUE II)FALSE
I) FALSE
26. What are parameters?
ANS:-Parameters provide a simple mechanism for defining and setting the values of inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.
27. What are the Built-ins used for sending Parameters to forms?
You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.
28. What is the maximum no of chars the parameter can store?
The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.
29. How do you call other Oracle Products from Oracle Forms?
Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the opertor.
30. How do you reference a Parameter?
In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER
Parameter name
ANS:-A user named editor has the same text editing functionality as the default editor, but, becaue it is a named object, you can specify editor attributes such as windows display size, position, and title.
3. What are the Built-ins to display the user-named editor?
ANS:-A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.
4. What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
ANS:-Show editor is the generic built_in which accepts any editor name and takes some input string and returns modified output string. Whereas the edit_textitem built_in needs the input focus to be in the text item before the built_in is excuted.
5. What is an LOV?
ANS:-An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.
6. What is the basic data structure that is required for creating an LOV?
ANS:-Record Group.
7. What is the "LOV of Validation" Property of an item? What is the use of it?
ANS:-When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV.
Whenever the validation event occurs. If the value in the text item matches one of the values in the first column of the LOV, validation succeeds, the LOV is not displayed, and processing continues normally. If the value in the text item does not match one of the values in the first column of the LOV, Oracle Forms displays the LOV and uses the text item value as the search criteria to automatically reduce the list.
8. What are the built_ins used the display the LOV?
ANS:-Show_lov , List_values
9. What are the built-ins that are used to Attach an LOV programmatically to an item?
ANS:-set_item_property, get_item_property (by setting the LOV_NAME property)
10.. What are the built-ins that are used for setting the LOV properties at runtime?
ANS:-get_lov_property , set_lov_property
11. What is a record group?
ANS:-A record group is an internal Oracle Forms that structure that hs a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to the form module which they are defined.
12. How many number of columns a record group can have?
ANS:-A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.
13. What is the Maximum allowed length of Record group Column?
ANS:-Record group column names cannot exceed 30 characters.
14. What are the different types of Record Groups?
ANS:-Query Record Groups, NonQuery Record Groups, State Record Groups
15. What is a Query Record Group?
ANS:-A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns referenced in the SELECT statement. The records in query record group are the rows retrieved by the query associated with that record group.
16. What is a Non Query Record Group?
ANS:-A non-query record group is a group that does not have an associated query, but whose structure and values can be modified programmatically at runtime.
17. What is a Static Record Group?
ANS:-A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at runtime.
18. What are the built-ins used for Creating and deleting groups?
ANS:-CREATE-GROUP (function)
CREATE_GROUP_FROM_QUERY(function)
DELETE_GROUP(procedure)
19.What are the built -ins used for Modifying a group's structure?
ANS:-ADD-GROUP_COLUMN (function)
ADD_GROUP_ROW (procedure)
DELETE_GROUP_ROW(procedure)
20. What are the built-ins used for Getting cell values?
ANS:-GET_GROUP_CHAR_CELL (function)
GET_GROUP_DATE_CELL(function)
GET_GROUP_NUMBET_CELL(function)
21. What are built-ins used for Processing rows?
ANS:-GET_GROUP_ROW_COUNT(function)
GET_GROUP_SELECTION_COUNT(function)
GET_GROUP_SELECTION(function)
RESET_GROUP_SELECTION(procedure)
SET_GROUP_SELECTION(procedure)
UNSET_GROUP_SELECTION(procedure)
23. What are the built-ins used for finding Object ID function?
ANS:-FIND_GROUP(function)
FIND_COLUMN(function)
24.. Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time.
I) TRUE II)FALSE
II) FALSE
25.. Use the ADD_GROUP_ROW procedure to add a row to a static record group
I) TRUE II)FALSE
I) FALSE
26. What are parameters?
ANS:-Parameters provide a simple mechanism for defining and setting the values of inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.
27. What are the Built-ins used for sending Parameters to forms?
You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.
28. What is the maximum no of chars the parameter can store?
The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.
29. How do you call other Oracle Products from Oracle Forms?
Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the opertor.
30. How do you reference a Parameter?
In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER
Parameter name
1. What is a visual attribute?
ANS:-Visual Attributes are the font, color and pattern characteristics of objects that operators see and interact with in our application.
2. What are the types of visual attribute settings?
ANS:-Custom Visual attributes, Default visual attributes ,Named Visual attributes.
3. What is a window?
ANS:-A window, by itself , can be thought of as an empty frame. The frame provides a way to interact with the window, including the ability to scroll, move, and resize the window. The content of the window ie. what is displayed inside the frame is determined by the canvas View or canvas-views displayed in the window at run-time.
4. What are the different types of windows?
ANS:-Root window, secondary window.
5. Can a root window be made modal?
ANS:- No.
6. List the buil-in routine for controlling window during run-time?
Find_window,
get_window_property,
hide_window,
move_window,
resize_window,
set_window_property,
show_View
7. List the windows event triggers available in Forms 4.0?
ANS:-When-window-activated, when-window-closed, when-window-deactivated, when-window-resized
8. What built-in is used for changing the properties of the window dynamically?
ANS:- Set_window_property
9. What is a canvas-view?
ANS:-A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they run your form. At run-time, operators can see only those items that have been assigned to a specific canvas. Each canvas, in term, must be displayed in a specific window.
10. Give the equivalent term in forms 4.0 for the following. Page, Page 0?
ANS:-Page - Canvas-View
Page 0 - Canvas-view null.
11. What are the types of canvas-views?
ANS:-Content View, Stacked View.
12. What is the content view and stacked view?
ANS:-A content view is the "Base" view that occupies the entire content pane of the window in which it is displayed. A stacked view differs from a content canvas view in that it is not the base view for the window to which it is assigned
13. List the built-in routines for the controlling canvas views during run-time?
ANS:-Find_canvas
Get-Canvas_property
Get_view_property
Hide_View
Replace_content_view
Scroll_view
Set_canvas_property
Set_view_property
Show_view
14. What is an Alert?
ANS:-An alert is a modal window that displays a message notifies the operator of some application condition
15. What are the display styles of an alert?
ANS:-Stop, Caution, note
16. Can you attach an alert to a field?
ANS:- No
17. What built-in is used for showing the alert during run-time?
ANS:-Show_alert.
18. Can you change the alert messages at run-time? If yes, give the name of the built-in to change the alert messages at run-time.
ANS:-Yes. Set_alert_property.
19. What is the built-in function used for finding the alert?
ANS:-Find_alert
20. List the editors available in forms 4.0?
ANS:-Default editor, User defined editors, system editors.
21. What built-in routines are used to display editor dynamically?
ANS:- Edit_text item , show_editor
22.. What is an Lov?
ANS:-A list of values is a single or multi column selection list displayed in a pop-up window
23. Can you attach an lov to a field at design time?
ANS:-Yes.
24:- Can you attach an lov to a field at run-time? if yes, give the build-in name.
ANS:-Yes. Set_item_proprety
25. What is the built-in used for showing lov at runtime?
ANS:-Show_lov
26. What is the built-in used to get and set lov properties during run-time?
ANS:-Get_lov_property , Set_lov_property
27. What is a record Group?
ANS:-A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table
28. What are the different type of a record group?
ANS:-Query record group, Static record group, Non query record group
29. Give built-in routine related to a record groups?
ANS:- Create_group (Function)
Create_group_from_query(Function)
Delete_group(Procedure)
Add_group_column(Function)
Add_group_row(Procedure)
Delete_group_row(Procedure)
Populate_group(Function)
Populate_group_with_query(Function)
Set_group_Char_cell(procedure)
30. What is the built_in routine used to count the no of rows in a group?
ANS:-Get_group _row_count
31. List system variables available in forms 4.0, and not available in forms 3.0?
ANS:-System.cordination_operation
System Date_threshold
System.effective_Date
System.event_window
System.suppress_working
32. System.effective_date system variable is read only True/False
ANS:- False
33. What is a library in Forms 4.0?
ANS:-A library is a collection of Pl/SQL program units, including user named procedures, functions & packages
34. Is it possible to attach same library to more than one form?
ANS:-Yes
35. Explain the following file extension related to library:- .pll,.lib,.pld?
ANS:-The library pll files is a portable design file comparable to an fmb form file
The library lib file is a plat form specific, generated library file comparable to a fmx form file
The pld file is Txt format file and can be used for source controlling your library files
36. How do you pass the parameters from one form to another form?
ANS:-To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built_in function to programmatically. Create a parameter list to execute the add parameter built_in procedure to add one or more parameters list. Execute the call_form, New_form or run_product built_in procedure and include the name or id of the parameter list to be passed to the called form.
ANS:-Visual Attributes are the font, color and pattern characteristics of objects that operators see and interact with in our application.
2. What are the types of visual attribute settings?
ANS:-Custom Visual attributes, Default visual attributes ,Named Visual attributes.
3. What is a window?
ANS:-A window, by itself , can be thought of as an empty frame. The frame provides a way to interact with the window, including the ability to scroll, move, and resize the window. The content of the window ie. what is displayed inside the frame is determined by the canvas View or canvas-views displayed in the window at run-time.
4. What are the different types of windows?
ANS:-Root window, secondary window.
5. Can a root window be made modal?
ANS:- No.
6. List the buil-in routine for controlling window during run-time?
Find_window,
get_window_property,
hide_window,
move_window,
resize_window,
set_window_property,
show_View
7. List the windows event triggers available in Forms 4.0?
ANS:-When-window-activated, when-window-closed, when-window-deactivated, when-window-resized
8. What built-in is used for changing the properties of the window dynamically?
ANS:- Set_window_property
9. What is a canvas-view?
ANS:-A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they run your form. At run-time, operators can see only those items that have been assigned to a specific canvas. Each canvas, in term, must be displayed in a specific window.
10. Give the equivalent term in forms 4.0 for the following. Page, Page 0?
ANS:-Page - Canvas-View
Page 0 - Canvas-view null.
11. What are the types of canvas-views?
ANS:-Content View, Stacked View.
12. What is the content view and stacked view?
ANS:-A content view is the "Base" view that occupies the entire content pane of the window in which it is displayed. A stacked view differs from a content canvas view in that it is not the base view for the window to which it is assigned
13. List the built-in routines for the controlling canvas views during run-time?
ANS:-Find_canvas
Get-Canvas_property
Get_view_property
Hide_View
Replace_content_view
Scroll_view
Set_canvas_property
Set_view_property
Show_view
14. What is an Alert?
ANS:-An alert is a modal window that displays a message notifies the operator of some application condition
15. What are the display styles of an alert?
ANS:-Stop, Caution, note
16. Can you attach an alert to a field?
ANS:- No
17. What built-in is used for showing the alert during run-time?
ANS:-Show_alert.
18. Can you change the alert messages at run-time? If yes, give the name of the built-in to change the alert messages at run-time.
ANS:-Yes. Set_alert_property.
19. What is the built-in function used for finding the alert?
ANS:-Find_alert
20. List the editors available in forms 4.0?
ANS:-Default editor, User defined editors, system editors.
21. What built-in routines are used to display editor dynamically?
ANS:- Edit_text item , show_editor
22.. What is an Lov?
ANS:-A list of values is a single or multi column selection list displayed in a pop-up window
23. Can you attach an lov to a field at design time?
ANS:-Yes.
24:- Can you attach an lov to a field at run-time? if yes, give the build-in name.
ANS:-Yes. Set_item_proprety
25. What is the built-in used for showing lov at runtime?
ANS:-Show_lov
26. What is the built-in used to get and set lov properties during run-time?
ANS:-Get_lov_property , Set_lov_property
27. What is a record Group?
ANS:-A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table
28. What are the different type of a record group?
ANS:-Query record group, Static record group, Non query record group
29. Give built-in routine related to a record groups?
ANS:- Create_group (Function)
Create_group_from_query(Function)
Delete_group(Procedure)
Add_group_column(Function)
Add_group_row(Procedure)
Delete_group_row(Procedure)
Populate_group(Function)
Populate_group_with_query(Function)
Set_group_Char_cell(procedure)
30. What is the built_in routine used to count the no of rows in a group?
ANS:-Get_group _row_count
31. List system variables available in forms 4.0, and not available in forms 3.0?
ANS:-System.cordination_operation
System Date_threshold
System.effective_Date
System.event_window
System.suppress_working
32. System.effective_date system variable is read only True/False
ANS:- False
33. What is a library in Forms 4.0?
ANS:-A library is a collection of Pl/SQL program units, including user named procedures, functions & packages
34. Is it possible to attach same library to more than one form?
ANS:-Yes
35. Explain the following file extension related to library:- .pll,.lib,.pld?
ANS:-The library pll files is a portable design file comparable to an fmb form file
The library lib file is a plat form specific, generated library file comparable to a fmx form file
The pld file is Txt format file and can be used for source controlling your library files
36. How do you pass the parameters from one form to another form?
ANS:-To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built_in function to programmatically. Create a parameter list to execute the add parameter built_in procedure to add one or more parameters list. Execute the call_form, New_form or run_product built_in procedure and include the name or id of the parameter list to be passed to the called form.
1. What are the difference between lov & list item?
ANS:-Lov is a property where as list item ias an item. A list item can have only one column, lov can have one or more columns.
2. What are the different display styles of list items?
ANS:-Pop_list, Text_list, Combo box
3. What is pop list?
ANS:- The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.
4. What is a text list?
ANS:- The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears, allowing the operator to view and select undisplayed values.
5. What is a combo box?
ANS:- A combo box style list item combines the features found in list and text item. Unlike the pop list or the text list style list items, the combo box style list item will both display fixed values and accept one operator entered value.
6. What are display items?
ANS:-Display items are similar to text items with the exception that display items only store and display fetched or assigned values. Display items are generally used as boilerplate or conditional text.
7. What is difference between open_form and call_form?
ANS:-when one form invokes another form by executing open_form the first form remains displayed,and operators can navigate between the forms as desired. when one form invokes another form by executing call_form,the called form is modal with respect to the calling form. That is, any windows that belong to the calling form are disabled, and operators cannot navigate to them until they first exit the called form.
8. What is new_form built-in?
ANS:-When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second. If there are changes pending in the first form, the operator will be prompted to save them before the new form is loaded.
9. What is a library?
ANS:- A library is a collection of subprograms including user named procedures, functions and packages.
10.. What is the advantage of the library?
ANS:-Library's provide a convenient means of storing client-side program units and sharing them among multipule applications. Once you create a library, you can attach it to any other form,menu,or library modules. When you can call library program units from triggers menu items commands and user named routine, you write in the modules to which you have attach the library. when a library attaches another library ,program units in the first library can reference program units in the attached library. Library support dynamic loading-that is library program units are loaded into an application only when needed. This can significantly reduce the run-time memory requirements of an applications.
11. What is strip sources generate options?
ANS:-Removes the source code from the library file and generates a library files that contains only pcode.The resulting file can be used for final deployment, but can not be subsequently edited in the designer.
ex. f45gen module=old_lib.pll userid=scott/tiger
strip_source YES output_file
12.What are the vbx controls?
ANS:-Vbx control provide a simple method of building and enhancing user interfaces. The controls can use to obtain user inputs and display program outputs.vbx control where originally develop as extensions for the ms visual basic environments and include such items as sliders, rides and knobs.
13. What is a timer?
ANS:-Timer is a "internal time clock" that you can programmatically create to perform an action each time the timer expires.
14. What are built-ins associated with timers?
ANS:-find_timer, create_timer, delete_timer
15. what are difference between post database commit and post-form commit?
ANS:- Post-form commit fires once during the post and commit transactions process, after the database commit occures. The post-form-commit trigger fires after inserts,updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.
16. What is a difference between pre-select and pre-query?
ANS:-Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode. Pre-query trigger fires before pre-select trigger.
17. What is trigger associated with the timer? When-timer-expired.?
18. What is the use of transactional triggers?
ANS:-Using transactional triggers we can control or modify the default functionality of the oracle forms.
REPORTS:-
1. What are the different file extensions that are created by oracle reports?
ANS:- Rep file and Rdf file.
2. From which designation is it preferred to send the output to the printed?
ANS:- Previewer.
3. Is it possible to disable the parameter from while running the report?
ANS:-Yes
4. What is lexical reference? How can it be created?
ANS:- Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or
parameter name.
5. What is bind reference and how can it create?
ANS:-Bind reference are used to replace the single value in sql,pl/sql statements a bind reference can be careated using a (:) before a column or a parameter name.
6.What use of command line parameter cmd file?
ANS:- It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.
7.Where is a procedure return in an external pl/sql library executed at the client or at the server?
ANS:- At the client.
8. Where is the external query executed at the client or the server?
ANS:- At the server.
9. What are the default parameter that appear at run time in the parameter screen?
ANS:- Destype and Desname.
10. Which parameter can be used to set read level consistency across multiple queries?
ANS:- Read only.
11. What is term?
ANS:-The term is terminal definition file that describes the terminal form which you are using r20run.
12. What is use of term?
ANS:- The term file which key is correspond to which oracle report functions.
13. Is it possible to insert comments into sql statements return in the data model editor?
ANS:- Yes.
14. If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
ANS:- Only for 10 records.
15. What are the sql clauses supported in the link property sheet?
ANS:- Where start with having.
16. To execute row from being displayed that still use column in the row which property can be used?
ANS:- Format trigger.
17. Is it possible to set a filter condition in a cross product group in matrix reports?
ANS:- No.
18. If a break order is set on a column would it effect columns which are under the column?
ANS:- No.
19. With which function of summary item is the compute at options required?
ANS:- percentage of total functions.
20. What is the purpose of the product order option in the column property sheet?
ANS:- To specify the order of individual group evaluation in a cross products.
21. Can a formula column be obtained through a select statement?
ANS:- Yes.
22.Can a formula column referred to columns in higher group?
ANS:- Yes.
23. How can a break order be created on a column in an existing group?
ANS:- By dragging the column outside the group.
24. What are the types of calculated columns available?
ANS:- Summary, Formula, Placeholder column.
25. What is the use of place holder column?
ANS:- A placeholder column is used to hold a calculated values at a specified place rather than allowing is to appear in the actual row where it has to appeared.
26. What is the use of hidden column?
ANS:- A hidden column is used to when a column has to embedded into boilerplate text.
27. What is the use of break group?
ANS:- A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.
28. If two groups are not linked in the data model editor, What is the hierarchy between them?
ANS:- Two group that is above are the left most rank higher than the group that is to right or below it.
29.The join defined by the default data link is an outer join yes or no?
ANS:- Yes.
30. How can a text file be attached to a report while creating in the report writer?
ANS:- By using the link file property in the layout boiler plate property sheet.
31. Can a repeating frame be created without a data group as a base?
ANS:- No.
32. Can a field be used in a report without it appearing in any data group?
ANS:- Yes.
33. For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
ANS:- Yes.
34. Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?
ANS:- Yes.
35. If yes, how?
ANS:- By the use anchors.
36. What are the two repeating frame always associated with matrix object?
ANS:- One down repeating frame below one across repeating frame.
37. Is it possible to split the print reviewer into more than one region?
ANS:- Yes.
38. Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?
ANS:- No.
39. How can a square be drawn in the layout editor of the report writer?
ANS:- By using the rectangle tool while pressing the (Constraint) key.
40. To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?
41. What does the term panel refer to with regard to pages?
ANS:- A panel is the no. of physical pages needed to print one logical page.
42. What is an anchoring object & what is its use?
ANS:- An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.
43. What is a physical page ? & What is a logical page ?
ANS:- A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.
44. What is the frame & repeating frame?
ANS:- A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the no. of records that are to displayed is not known before.
ANS:-Lov is a property where as list item ias an item. A list item can have only one column, lov can have one or more columns.
2. What are the different display styles of list items?
ANS:-Pop_list, Text_list, Combo box
3. What is pop list?
ANS:- The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.
4. What is a text list?
ANS:- The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears, allowing the operator to view and select undisplayed values.
5. What is a combo box?
ANS:- A combo box style list item combines the features found in list and text item. Unlike the pop list or the text list style list items, the combo box style list item will both display fixed values and accept one operator entered value.
6. What are display items?
ANS:-Display items are similar to text items with the exception that display items only store and display fetched or assigned values. Display items are generally used as boilerplate or conditional text.
7. What is difference between open_form and call_form?
ANS:-when one form invokes another form by executing open_form the first form remains displayed,and operators can navigate between the forms as desired. when one form invokes another form by executing call_form,the called form is modal with respect to the calling form. That is, any windows that belong to the calling form are disabled, and operators cannot navigate to them until they first exit the called form.
8. What is new_form built-in?
ANS:-When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second. If there are changes pending in the first form, the operator will be prompted to save them before the new form is loaded.
9. What is a library?
ANS:- A library is a collection of subprograms including user named procedures, functions and packages.
10.. What is the advantage of the library?
ANS:-Library's provide a convenient means of storing client-side program units and sharing them among multipule applications. Once you create a library, you can attach it to any other form,menu,or library modules. When you can call library program units from triggers menu items commands and user named routine, you write in the modules to which you have attach the library. when a library attaches another library ,program units in the first library can reference program units in the attached library. Library support dynamic loading-that is library program units are loaded into an application only when needed. This can significantly reduce the run-time memory requirements of an applications.
11. What is strip sources generate options?
ANS:-Removes the source code from the library file and generates a library files that contains only pcode.The resulting file can be used for final deployment, but can not be subsequently edited in the designer.
ex. f45gen module=old_lib.pll userid=scott/tiger
strip_source YES output_file
12.What are the vbx controls?
ANS:-Vbx control provide a simple method of building and enhancing user interfaces. The controls can use to obtain user inputs and display program outputs.vbx control where originally develop as extensions for the ms visual basic environments and include such items as sliders, rides and knobs.
13. What is a timer?
ANS:-Timer is a "internal time clock" that you can programmatically create to perform an action each time the timer expires.
14. What are built-ins associated with timers?
ANS:-find_timer, create_timer, delete_timer
15. what are difference between post database commit and post-form commit?
ANS:- Post-form commit fires once during the post and commit transactions process, after the database commit occures. The post-form-commit trigger fires after inserts,updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.
16. What is a difference between pre-select and pre-query?
ANS:-Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode. Pre-query trigger fires before pre-select trigger.
17. What is trigger associated with the timer? When-timer-expired.?
18. What is the use of transactional triggers?
ANS:-Using transactional triggers we can control or modify the default functionality of the oracle forms.
REPORTS:-
1. What are the different file extensions that are created by oracle reports?
ANS:- Rep file and Rdf file.
2. From which designation is it preferred to send the output to the printed?
ANS:- Previewer.
3. Is it possible to disable the parameter from while running the report?
ANS:-Yes
4. What is lexical reference? How can it be created?
ANS:- Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or
parameter name.
5. What is bind reference and how can it create?
ANS:-Bind reference are used to replace the single value in sql,pl/sql statements a bind reference can be careated using a (:) before a column or a parameter name.
6.What use of command line parameter cmd file?
ANS:- It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.
7.Where is a procedure return in an external pl/sql library executed at the client or at the server?
ANS:- At the client.
8. Where is the external query executed at the client or the server?
ANS:- At the server.
9. What are the default parameter that appear at run time in the parameter screen?
ANS:- Destype and Desname.
10. Which parameter can be used to set read level consistency across multiple queries?
ANS:- Read only.
11. What is term?
ANS:-The term is terminal definition file that describes the terminal form which you are using r20run.
12. What is use of term?
ANS:- The term file which key is correspond to which oracle report functions.
13. Is it possible to insert comments into sql statements return in the data model editor?
ANS:- Yes.
14. If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
ANS:- Only for 10 records.
15. What are the sql clauses supported in the link property sheet?
ANS:- Where start with having.
16. To execute row from being displayed that still use column in the row which property can be used?
ANS:- Format trigger.
17. Is it possible to set a filter condition in a cross product group in matrix reports?
ANS:- No.
18. If a break order is set on a column would it effect columns which are under the column?
ANS:- No.
19. With which function of summary item is the compute at options required?
ANS:- percentage of total functions.
20. What is the purpose of the product order option in the column property sheet?
ANS:- To specify the order of individual group evaluation in a cross products.
21. Can a formula column be obtained through a select statement?
ANS:- Yes.
22.Can a formula column referred to columns in higher group?
ANS:- Yes.
23. How can a break order be created on a column in an existing group?
ANS:- By dragging the column outside the group.
24. What are the types of calculated columns available?
ANS:- Summary, Formula, Placeholder column.
25. What is the use of place holder column?
ANS:- A placeholder column is used to hold a calculated values at a specified place rather than allowing is to appear in the actual row where it has to appeared.
26. What is the use of hidden column?
ANS:- A hidden column is used to when a column has to embedded into boilerplate text.
27. What is the use of break group?
ANS:- A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.
28. If two groups are not linked in the data model editor, What is the hierarchy between them?
ANS:- Two group that is above are the left most rank higher than the group that is to right or below it.
29.The join defined by the default data link is an outer join yes or no?
ANS:- Yes.
30. How can a text file be attached to a report while creating in the report writer?
ANS:- By using the link file property in the layout boiler plate property sheet.
31. Can a repeating frame be created without a data group as a base?
ANS:- No.
32. Can a field be used in a report without it appearing in any data group?
ANS:- Yes.
33. For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
ANS:- Yes.
34. Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?
ANS:- Yes.
35. If yes, how?
ANS:- By the use anchors.
36. What are the two repeating frame always associated with matrix object?
ANS:- One down repeating frame below one across repeating frame.
37. Is it possible to split the print reviewer into more than one region?
ANS:- Yes.
38. Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?
ANS:- No.
39. How can a square be drawn in the layout editor of the report writer?
ANS:- By using the rectangle tool while pressing the (Constraint) key.
40. To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?
41. What does the term panel refer to with regard to pages?
ANS:- A panel is the no. of physical pages needed to print one logical page.
42. What is an anchoring object & what is its use?
ANS:- An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.
43. What is a physical page ? & What is a logical page ?
ANS:- A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.
44. What is the frame & repeating frame?
ANS:- A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the no. of records that are to displayed is not known before.
