Saturday, May 28, 2022

Oracle Forms: Add List Element

Oracle Forms: Add List Element


Built-in support for ADD LIST ELEMENT

Description

Adds a single item to a list item that has already been created.

Syntax

PROCEDURE ADD_LIST_ELEMENT (list_name VARCHAR2, list_index, NUMBER list_label VARCHAR2, list_value NUMBER);

PROCEDURE ADD_LIST_ELEMENT (list_id ITEM,

list_index VARCHAR2, list_label VARCHAR2, list_value NUMBER);

Built-in Type  unrestricted procedure

Enter Query Mode  yes

Parameters

list_id

Specifies the one-of-a-kind ID that will be assigned to the list item by Form Builder when it is created. Make use of the built-in FIND ITEM function to return the ID to a variable of the right type. ITEM is the data type that the ID is stored as.

list_name 

The name that you designated for the list item at the time that it was created. The name is stored as data using the VARCHAR2 data type.

list_index

Identifies the value of the list index. The index of the list starts at 1.

list_label

This parameter allows you to provide the VARCHAR2 string that will be shown as the label of the list element.

list_value

The actual value of the list element that you want to add to the item on the list.

Constraints on the ADD LIST ELEMENT variable:

Form Builder will not let you add another values element to a base table list if the List Style attribute has been set to Poplist or T-list. This is the case whether or not the block already includes queried or updated data. This action will result in an error. If you had previously used the DELETE LIST ELEMENT or CLEAR LIST functions to delete the other values element from the list, which was indicated at design time by the Mapping of Other Values list item property setting, then you may find yourself in the predicament described above.

Note: When a block includes records that have been queried, the state of the block is changed to QUERY. When a block includes records that have been either added or changed, the status of the block is considered to have been CHANGED.

Examples of ADD LIST ELEMENT

/*

**    Built-in:  ADD_LIST_ELEMENT
**    Example:  Deletes index value 1 and adds the value "1994" to

**                   the list item called years when a button is

pressed.
**    trigger:  When-Button-Pressed
*/
BEGIN 
Delete_List_Element(’years’,1);

Add_List_Element(’years’, 1, ’1994’, ’1994’); 
END;


I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com

Thank you.

Thursday, May 26, 2022

Oracle Forms 10G: Displaying Icons on Push Buttons

 


ICO files may no longer be used as icons for buttons in Forms 10g since this format is no longer supported. You will need to change the file extension of your icon files to either GIF or JPG.

Configuration in the design phase.

Modify the registry of your Windows operating system to show the icons in your Forms builder.

The path should be something like this: Hkey Local MachineSoftwareOracleForms10 g Home>.

UI ICON simply inputting the path to your GIF and JPG files, for example C:MY APPICONS, and creating a new ui icon extension variable and assigning the value GIF to it.

Configuration of the run-time environment.

Creating the Jar file

  • After you have completed working with the GIF or JPG images, create a folder on your computer and name it ICONS. You are free to create this folder anywhere you choose. You may create an ICONS folder, for example, on a drive C beneath the root directory or as a subfolder under any folder you like.
  • Assuming you already have an ICONS folder established as a root folder on the C drive, you should now transfer all of your GIF files into this folder.
  • To change directories, use cd at the DOS prompt.
  • Enter the following command at the C: prompt to generate a Java Archive File (JAR) named my icons. Jar -cvf my_icons.jar icons 
  • Make a copy of this file and place it within the Forms10g Home>Forms\Java folder.
It is essential that you keep in mind how significant it is to have the name of the folder that contains GIF or JPG files as ICONS. Icons will not be shown in your form at run time if the folder name is anything other than what it is now set to. Oracle's documentation does not make any reference to this particular reason whatsoever. After spending more than a day attempting, but ultimately failing, to show the symbols, I discovered this information via metalink (Service Request no. 6602276.993).

Add or remove entries from REGISTRY.DAT file.

  • Launch this file, which may be found in the folder labelled "Forms10g Home>formsjavaoracleformsreg istry."
  • Add the following to the end of the default.icons.iconpath argument that is already there: default.icons.iconpath=icons/
  • If you want to save icon images in GIF format, you should keep the default value for the parameter default.icons.iconextension=gif that is currently in place. If you wish to utilise JPG files instead of GIF files, you need to replace the GIF with the JPG in the following way: default.icons.iconextension=jpg
The FORMSWEB.CFG file to be changed.

  • There is a copy of this file in the subdirectory titled "Forms10g Home>FormsServer."Add the following to the already existing parameters:
    • imagebase=codebase 
    • archive_jini=frmall_jinit.jar,my_icons.jar
Modify FORMSWEB.CFG file

This file exists under <Forms10g_Home>\Forms\Server folder. 
Append the following existing parameter: 
imagebase=codebase 

Copy/paste .gif(s)

Copy paste all animated .gif(s) file in following location
<Forms10g_Home>\forms\java\

Set property on button

Now open form builder 10g. Built new form, Design Canvas, create button and set its property as mentioned in below attached image
Oracle Forms 10G: Displaying Icons on Push Buttons

Note: Always mention complete name of icon image file including full extension.
for e.g. animated_image.gif  

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com

Thank you.

Thursday, May 19, 2022

Oracle Forms: Auto-Complete Checkbox

Oracle Forms: Auto-Complete Checkbox


 In this section, I'd want to provide a sample using an autocomplete combo box that's available in Oracle Forms.

The approach generates a "list block" on a layered canvas that is dynamically filtered based on the key input in the combo box. This block displays the results of the dynamic filtering. When searching for an accurate explanation of this component's purpose, it is common to come across the designation "Combo Box Including Filter." The 'list block' is enlarged and dynamically updated with each key press while the combo box is activated; here are some examples:

Oracle Forms: Auto-Complete Checkbox
  • The object group OG CBOX is integrated from the cbox.olb into the corresponding form via the use of drag-and-drop and copy-and-paste:
Oracle Forms: Auto-Complete Checkbox
  • The Combo Box Item has been put on the C-Canvas that was inherited, and any necessary adjustments should be made.
  • In the canvas that is being utilised, the position of the "List-Block" has to be altered such that.
Oracle Forms: Auto-Complete Checkbox
  • The Autocomplete Combo Box is activated by the WHEN-NEW-FORM-INSTANCE Trigger, which consists of the following:
*****************************************
pkg_CBOX.populate_auto_cbox(
 'CBOX', 
 'select name, name
    from europecities 
    order by 1',
 'C.DUMMY');
*****************************************

The item C.DUMMY that was obtained should be switched out for the true NEXT-ITEM that is in the combo box.
The following are some of the phases at which the answer may be put to the test:
  • To Download the Full Bundle, Please Click Here.
  • Scott / Tiger: SQL> @ cr_eurocities.sql
  • Carry out and check the functionality of the chk lboxproto2 form.
  • generate a new form following step 1): assume control of the OG _CBOX
  • the new form will be executed and tested.

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com

Thank you.

Tuesday, May 17, 2022

SAP Certified Development Associate - ABAP with SAP NetWeaver 7.50 Part -6

 


Question 01

Ques:- What does a Web Dynpro component contain? (3 Correct)

1. UI elements

2. Component controller

3. A context

4. Multiple views within a window

5. Exactly one interface controller

Correct Answer : 2,4,5

Question 02

Ques:- Identify the types of controller. (5 Correct)

1. Consumer controller

2. Window controller

3. Custom controller

4. Configuration controller

5. Component controller

6. View controller

Correct Answer : 2,3,4,5,6

Question 03

Ques:- You define a formal parameter to a subroutine that accepts only internal table of type standard

and type sorted as actual parameters. Which of the following generic ABAP data types must you use?

1. Index table

2. Standard table

3. Sorted table

4. Hashed table

Correct Answer : 1

Question 04

Ques:- Which ABAP statement using the local type gty_1 correctly defines a data object? (2 Correct)

1. DATA gv_1 TYPE gty_1 DEFAULT '1'.

2. CONSTANTS gc_1 TYPE gty_1 VALUE '1'.

3. DATA gv_1 LIKE gty_1.

4. DATA gv_1 TYPE gty_1.

Correct Answer : 2,4

Question 05

Ques:- Which boundary conditions lead to improved access time to an internal table? (3 Correct)

1. Index access for hashed tables

2. Index access for standard tables

3. Left justified part of key for hashed tables

4. Left justified part of key for sorted tables

5. Fully qualified key for sorted tables

Correct Answer : 2,4,5

Question 06

Ques:- Which hook method exists for all controller types?

1. wddoinit( )

2. wddobeforenavigation( )

3. wddoonopen( )

4. wddoonclose( )

Correct Answer : 1

Question 07

Ques:- What does SAP recommend that you use a hashed table?

1. When a table must be sorted automatically by key in ascending order

2. When a table must be accessible by both index and key

3. When a table is very large and you want to access the table by key only

4. When a table is very large and you want to access the table by index only.

Correct Answer : 3

Question 08

Ques:- Where can you set the GUI status and the GUI title for a classical screen (dynpro)?

1. In a module called from PAI of the screen

2. In the attributes of the screen

3. In the properties of the related header UI element

4. In a module called from PBO of the screen

Correct Answer : 4

Question 09

Ques:- Which controller types can exist within a Web Dynpro component? (3 Correct)

1. Component controller

2. Window controller

3. User controller

4. View controller

5. Application controller

Correct Answer : 1,2,4

Question 10

Ques:- What is the Web Dynpro programming model is based on?

1. Business Server Pages (BSPs)

2. Model View Controller (MVC)

3. Internet Transaction Server (ITS)

4. Classic Dynpro programming

Correct Answer : 2

Question 11

Ques:- Identify the different installation options for SAP NetWeaver Application Server (AS). (3 Correct)

• SAP NetWeaver AS ABAP

• SAP NetWeaver AS Java

• SAP NetWeaver AS ABAP + Java

• SAP NetWeaver AS C++

• SAP NetWeaver All-In-One

Correct Answer : 1,2,3

Question 12

Ques:- Which of the following statements are true of the ABAP dispatcher? (3 Correct)

1. It manages the resources of the applications written in ABAP.

2. It distributes the requests among the work processes.

3. It accepts incoming http requests from web browsers.

4. It saves the user requests in request queues and processes them using the first in, first out

approach.

5. It is the owner of the ABAP database schema.

Correct Answer : 1,2,4

Question 13

Ques:- Identify the interfaces and communication options that are supported by SAP systems. (4

Correct)

1. HyperText Transfer Protocol (HTTP)

2. Simple Mail Transfer Protocol (SMTP)

3. Remote Function Call (RFC)

4. Business Application Programming Interfaces (BAPIs)

5. Extended Data Transfer Protocol

6. SAP Transfer Protocol

Correct Answer : 1,2,3,4

Question 14

Ques:- For which of the following functions can Business Application Programming Interfaces (BAPIs) be

used? (3 Correct)

1. Request data from an SAP system

2. Pass data to an SAP system

3. Transfer SAP screen images to third-party applications (such as Microsoft Word)

4. Access business processes in SAP systems

Correct Answer : 1,2,4

Question 15

Ques:- Which of the following standards are implemented in SAP NetWeaver AS to support Web

services ? (4 Correct)

1. XML

2. SOAP

3. WDSL

4. UDDI

5. Web server

Correct Answer : 1,2,3,4

Question 16

Ques:- Which of the following is the tool to implement and store BAPIs?

1. Function Builder

2. ABAP Editor

3. Class Builder

4. ABAP Dictionary

Correct Answer : 1

Question 17

Ques:- Which of the following statements apply accurately to Application Link Enabling (ALE)? (2

Correct)

1. ALE can be used to exchange data exclusively between SAP systems of the same release

2. ALE can be used to exchange data using web services

3. ALE can be used to exchange data between collaborating systems using BAPIs

4. ALE can be used to communicate between the systems in your system landscape using RFC.?

5. ALE can be used to exchange data between AS ABAP and AS Java systems.

Correct Answer : 3,4

Question 18

Ques:- Which of the following layers contains the user interface where each user can access a program,

enter new data, and receive the results of a work process?

1. Application server layer

2. Presentation server layer

3. Application logic layer

4. SAP NetWeaver Application

Correct Answer : 2

Question 19

Ques:- Which of the following is the concept of a program being made up of several units, instead of

being made up of a single block?

1. Isolation

2. Modularity

3. Universality

4. Multiplicity

Correct Answer : 2

Question 20

Ques:- Which of the following system development objects are included in the Repository? (3 Correct)

1. Programs

2. Function modules

3. Object Navigator

4. Definitions of database tables

Correct Answer : 1,2,4

Question 21

Ques:- Which of the following ABAP Workbench tools is used to edit the source code?

1. ABAP Editor

2. ABAP Dictionary

3. Repository Information System

4. Menu Painter

Correct Answer : 1

Question 22

Ques:- Which of the following are package types? (2 Correct)

1. Application component

2. Development package

3. Main package

4. Software component

Correct Answer : 2,3

Question 23

Ques:- When is the transport of development objects for a development request triggered?

1. When an object is saved

2. When an object is activated

3. When a task is released

4. When a request is released

Correct Answer : 4

Question 24

Ques:- Which of the following statements is correct about the ABAP programming language? (3 Correct)

1. It enables multi-language applications.

2. It enables SQL access.

3. It is platform-dependent.

4. It is typed.

Correct Answer : 1,2,4

Question 25

Ques:- How do you include comment lines?

1. Begin the line with a pound # in the first column.

2. Begin the line with an asterisk * in the first column.

3. End the line with an asterisk * in the last column.

4. End the line with a pound # in the last column.

Correct Answer : 2

Question 26

Ques:- After a project employee completes the required development task, he or she should do the

following:

1. Transfer the task to the Production System

2. Release the task within the Change request

3. Unlock and export the task to the Transport Directory

4. Export the Project Request

Correct Answer : 2

Question 27

Ques:- Which of the following are complete ABAP standard types? (3 Correct)

1. T (Time)

2. C (Character)

3. N (Numerical character)

4. INT8 (Integer with Length of 8 bytes)

5. D (Date)

Correct Answer : 1,4,5

Question 28

Ques:- Which of the following is the operator used in an IF statement to formulate a negation before

logical conditions?

1. AND

2. OR

3. END

4. NOT

Correct Answer : 4

Question 29

Ques:- Which of the following are required in the syntax of the Message statement? (3 Correct)

1. Message number

2. Message type

3. Message class

4. Message role

Correct Answer : 1,2,3

Question 30

Ques:- In nested loops, which of the following contains the loop pass number of the loop in which it is

located?

1. sy-index

2. sy-repid

3. sy-uname

4. sy-mandt

Correct Answer : 1

Question 31

Ques:- You can use the logical expression IS SUPPLIED for any formal parameter passed to which

modularization unit? (3 Correct)

1. Function module

2. Static method

3. Instance method

4. Subroutine (FORM routine)

Correct Answer : 1,2,3

Question 32

Ques:- What are the differences between displaying in a full screen and in a container? (2 Correct)

1. Any type of ALV allows the use of event handling.

2. Only an ALV in a container allows the use of event handling.

3. The only difference is that the container name must be specified when creating the ALV object.

4. The container requires the use of an additional object (a container control).

5. The full screen requires Dynpro programming.

6. Only a full-screen ALV allows the use of event handling.

Correct Answer : 1,4

Question 33

Ques:- In which of the following source code blocks can you define local data objects? (3 Correct)

1. AT SELECTION-SCREEN event block

2. PBO module

3. Function module

4. Subroutine

5. Static method

Correct Answer : 3,4,5

Question 34

Ques:- What must you do to create a singleton class? (3 Correct)

1. Implement the IF_UMM_SINGLETON interface in the class

2. Set the class instantiation to private

3. sDefine the class as abstract

4. Instantiate the class in a static method of the class itself

5. Define the class as final

Correct Answer : 2,4,5

Question 35

Ques:- When analyzing a program, which tasks can you perform using the code inspector? (3 Correct)

1. Discover unused variables.

2. Evaluate the time needed for program execution.

3. Determine used database tables.

4. Inspect the memory consumption

5. Execute the extended program check

Correct Answer : 1,3,5

Question 36

Ques:- Which of the following items are used in a Web Dynpro Application to transport database data to

the user interface? (2 Correct)

1. Interface controller

2. Inbound plug

3. Context node

4. Supply function

Correct Answer : 1,3

Question 37

Ques:- Which of the following can you assign a search help to? (3 Correct)

1. Table type

2. Data element

3. Domain

4. Check table

5. Structure component

Correct Answer : 2,4,5

Question 38

Ques:- DOG is a subclass of ANIMAL. You have created a variable of type ANIMAL that references an

instance of the DOG class. Which of the following statements can you use to copy this reference to a

new variable of type DOG?

1. MOVE…. TO…..

2. MOVE……?TO……

3. MOVE-CORRESPONDING…… TO……

4. WRITE……TO……

Correct Answer : 2

Question 39

Ques:- Which of the following statements are true? (2 Correct)

1. A maintenance view is implemented as an inner join.

2. A database view is implemented as an outer join.

3. A maintenance view is implemented as an outer join.

4. A database view is implemented as an inner join.

Correct Answer : 3,4

Question 40

Ques:- To reserve an area on the screen for an ALV Grid Control, you must do the following:

1. Create an object (instantiate the object) of the class CL_GUI_ALV_GRID

2. Create an object (instantiate the object) of the class CL_SALV_TABLE

3. Create an object (instantiate the object) of the class CL_GUI_CUSTOM_CONTAINER

4. Use the Screen Painter

Correct Answer : 4

Question 41

Ques:- You have defined a classical screen (dynpro) with mandatory input fields. You want to exit the

screen using the Cancel button even if not all of the mandatory fields have been filled. What is necessary

to achieve this?

1. Assign function type E to the Cancel button and handle it in a module with the addition AT EXIT[1]COMMAND.

2. Use the LOOP AT SCREEN. ... ENDLOOP statement to set the "required" property of the input

fields to zero.

3. Set the function type assigned to the Cancel button to S and handle it in a module with the

addition AT EXIT-COMMAND.

4. Set the function code assigned to the Cancel button to CANCEL and handle it in a module with

the addition AT EXIT-COMMAND.

Correct Answer : 1

Question 42

Ques:- What can you change in the ABAP Debugger?

1. Definition of a structure

2. Value of a reference variable

3. Content of an internal table

4. Value of a constant

Correct Answer : 3

Question 43

Ques:- Which must a search help do? (4 Correct)

1. Use a table or a view for data selection

2. Determine the values for selection by the user

3. Have a dialog with the user

4. Be used from a screen

5. Allow the user to select a response

Correct Answer : 2,3,4,5

Question 44

Ques:- Each component has an interface; of what does this interface consist? (2 Correct)

1. Data Container

2. Interface context

3. Interface controller

4. Interface view

Correct Answer : 3,4

Question 45

Ques:- Which of the following functions does the ABAP Dispatcher perform? (2 Correct)

1. It distributes user requests among available work processes.

2. It communicates with other instances in the system.

3. It enables communication between SAP systems and external application systems.

4. It directs HTTP requests from an SAP system to a web server.

Correct Answer : 1,2

Question 46

Ques:- You want to create a transparent table in the ABAP dictionary. When the table is physically

created in the database?

1. When you save the table

2. When you activate the table

3. When you run the database utility transaction (SE14)

4. When you insert the table name and select create

Correct Answer : 2

Question 47

Ques:- Which of the following generic types can you use to define a field symbol that will be assigned to

a character string? (3 Correct)

1. Type clike

2. Type csequence

3. Type xsequence

4. Type any table

5. Type any

Correct Answer : 1,2,4

Question 48

Ques:- When must a foreign key have domain equality?

1. For a text table

2. For a check field

3. Always

4. Never

Correct Answer : 2

Question 49

Ques:- You always want to check the user authorization for data entered in an input field of a selection

screen.Where do you do this?

1. In the event block INITIALIZATION

2. In the event block AT SELECTION-SCREEN

3. In the event block AT SELECTION-SCREEN on VALUE-REQUEST

4. In the event block AT SELECTION-SCREEN OUTPUT

Correct Answer : 2

Question 50

Ques:- At most, how many buttons can the application toolbar have on the screen?

1. None of the above

2. 10

3. 20

4. 30

5. 35

Correct Answer : 5

Monday, May 16, 2022

HOW TO CONFIGURE WEBUTIL IN ORACLE FORMS 10G



 I'm going to demonstrate in a straightforward manner how to setup Oracle WebUtil Package to work with Oracle forms 10g.

Configuring WebUtil:

  • Click to download Package.
  • Both RAR files should be extracted to some directory.
  • Copy
    • File frmwebutil.jar
        From folder: webutil_106\webutil_106\java  To: $ORACLE_HOME/forms/java

        File: jacob.jar 
        From folder: jacob_18  To: $ORACLE_HOME/forms/java

        File: d2kwut60.dll, JNIsharedstubs.dll
        From folder: webutil_106\webutil_106\webutil To: $ORACLE_HOME/forms/webutil

        File: jacob.dll
       From folder: jacob_18 To: $ORACLE_HOME/forms/webutil

        File: forms_base_ie.js, forms_ie.js
      - From folder: webutil_106\webutil_106\java To: $ORACLE_HOME/forms/java

       File: webutil.olb, webutil.pll and create_webutil_db.sql
       From folder: webutil_106\webutil_106 To: $ORACLE_HOME/forms

       File: webutilbase.htm, webutiljini.htm, webutiljpi.htm and webutil.cfg
      - From folder: webutil_106\webutil_106\server To: $ORACLE_HOME/forms/server

      File: sign_webutil.bat
      - From folder: webutil_106\webutil_106\webutil To: $ORACLE_HOME/forms/webutil

  • In $ORACLE_HOME/forms/server/formsweb.cfg file
    • Make the necessary changes to the entries below.

# Forms applet archive setting for JInitiator
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar 
if you use JRE plugin then this line also required
archive=frmall_jinit.jar,frmwebutil.jar,jacob.jar 
[webutil]
WebUtilArchive=/forms/java/frmwebutil.jar,/forms/java/jacob.jar
<if you use JRE plugin then this line also required>
Replace baseHTMLjinitiator=webutiljini.htm with baseHTMLjinitiator=webutiljpi.htm 

  •  In $ORACLE_HOME/forms/server/default.env file change the following entries
             FORMS_PATH=C:\YourOracle_Home\forms;C:\YourOracle_home\forms\webutil

              # webutil config file path
              WEBUTIL_CONFIG=C:\YourOracle_Home\forms\server\webutil.cfg

            Add frmwebutil.jar, jacob.jar into Classpath  
CLASSPATH=C:\YourOracle_Home\forms\java\frmwebutil.jar;C:\YourOracle_Home\forms\java\jacob.jar

  •  Sign Webutil JAR files by running these following commands Make sure Form Builder is Closed

For Example :
        C:\>set PATH=D:\<Oracle_Home>\jdk\bin
        C:\>cd <Oracle_Home>\forms\webutil
        C:\<Oracle_Home>\forms\webutil>sign_webutil.bat C:\<Oracle_Home>\forms\java\frmwebutil.jar
        C:\<Oracle_Home>\forms\webutil>sign_webutil.bat C:\<Oracle_Home>\forms\java\jacob.jar

  • This will kick off a procedure that will culminate with a message. 1 file transferred successfully

Database configuration:
  • Connect via Scott or your User if you like.
  • You may use SQLPLUS or any other tool to run the script located at $ORACLE HOME/forms/create webutil db.sql.
Setting up Form Builder:
  • Open Form builder Connect with SCOTT and in PL/SQL libraries open Webutil.pll file
  • Use the "File" menu to save the file under an alternative name, such as "WebUtil lib," and then rename the file.
  • Create the new PLL file by compiling the existing one.
  • Attached a new file to your form with the name Webutil lib.pll and selected the Remove Path option. YES.
  • Launch the builder and go to the WebUtil.olb file's Object group. Then, either copy it or subclass it into your form.
  • Now it's time to assemble and execute your form.
Note:
The first time you use these libraries, the browser will ask you to certify them. Select the ALWAYS certify option. Verify that the frmwebtul.jar and jacob.jar files have been loaded properly by clicking the Java Console icon located on the task bar.
  • Click the Browse button on the form, then choose Datafile.txt, and then click the Open button... It is going to load a text file into the Data Block.


I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com

Thank you.

Saturday, May 14, 2022

Oracle Reports fast processing of images



REPORTS_JPEG_QUALITY_FACTOR

Description The degree of picture quality wanted for JPEG files may be specified with the use of this environment variable. It allows control over the compromise that is made between the quality of the JPEG picture and the size of the image. The size of the picture file increases proportionally with the image's perceived quality.

0 to 100 are considered valid values.

Default 100 (highest quality)

Usage Notes

  • When working with Windows, the value may be specified by using the registry. On Unix/Linux, set the environment variable in reports. sh.
  • The default value is used if the REPORTS JPEG QUALITY FACTOR parameter is either not supplied at all or wrongly defined (for example, set to a string or a value that is outside of the acceptable range).
  • A number of 75 produces a picture of satisfactory quality while yet maintaining an acceptable compression ratio.


I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com

Thank you.

Wednesday, May 11, 2022

SAP Certified Development Associate - ABAP with SAP NetWeaver 7.50 Part -5

 


Question 01

Ques:- What does a Web Dynpro component contain? (3 Correct)

1. UI elements

2. Component controller

3. Multiple views within a window

4. Exactly one interface controller

5. A context

Correct Answer : 2,3,4

Question 02

Ques:- Identify the types of controller. (5 Correct)

1. Consumer controller

2. Window controller

3. Custom controller

4. Configuration controller

5. Component controller

6. View controller

Correct Answer : 2,3,4,5,6

Question 03

Ques:- You define a formal parameter to a subroutine that accepts only internal table of type standard

and type sorted as actual parameters. Which of the following generic ABAP data types must you use?

1. Index table

2. Standard table

3. Sorted table

4. Hashed table

Correct Answer : 1

Question 04

Ques:- Which ABAP statement using the local type gty_1 correctly defines a data object? (2 Correct)

1. DATA gv_1 TYPE gty_1 DEFAULT '1'.

2. CONSTANTS gc_1 TYPE gty_1 VALUE '1'.

3. DATA gv_1 LIKE gty_1.

4. DATA gv_1 TYPE gty_1.

Correct Answer : 2,4

Question 05

Ques:- Which boundary conditions lead to improved access time to an internal table? (3 Correct)

1. Index access for hashed tables

2. Index access for standard tables

3. Left justified part of key for hashed tables

4. Left justified part of key for sorted tables

5. Fully qualified key for sorted tables

Correct Answer : 2,4,5

Question 06

Ques:- Which hook method exists for all controller types?

1. wddoinit( )

2. wddobeforenavigation( )

3. wddoonopen( )

4. wddoonclose( )

Correct Answer : 1

Question 07

Ques:- What does SAP recommend that you use a hashed table?

1. When a table must be sorted automatically by key in ascending order

2. When a table must be accessible by both index and key

3. When a table is very large and you want to access the table by key only

4. When a table is very large and you want to access the table by index only.

Correct Answer : 3

Question 08

Ques:- Where can you set the GUI status and the GUI title for a classical screen (dynpro)?

1. In a module called from PAI of the screen

2. In the attributes of the screen

3. In the properties of the related header UI element

4. In a module called from PBO of the screen

Correct Answer : 4

Question 09

Ques:- Which controller types can exist within a Web Dynpro component? (3 Correct)

1. Component controller

2. Window controller

3. User controller

4. View controller

5. Application controller

Correct Answer : 1,2,4

Question 10

Ques:- What is the Web Dynpro programming model is based on?

1. Business Server Pages (BSPs)

2. Model View Controller (MVC)

3. Internet Transaction Server (ITS)

4. Classic Dynpro programming

Correct Answer : 2

Question 11

Ques:- Identify the different installation options for SAP NetWeaver Application Server (AS). (3 Correct)

• SAP NetWeaver AS ABAP

• SAP NetWeaver AS Java

• SAP NetWeaver AS ABAP + Java

• SAP NetWeaver AS C++

• SAP NetWeaver All-In-One

Correct Answer : 1,2,3

Question 12

Ques:- Which of the following statements are true of the ABAP dispatcher? (3 Correct)

1. It manages the resources of the applications written in ABAP.

2. It distributes the requests among the work processes.

3. It accepts incoming http requests from web browsers.

4. It saves the user requests in request queues and processes them using the first in, first out

approach.

5. It is the owner of the ABAP database schema.

Correct Answer : 1,2,4

Question 13

Ques:- Identify the interfaces and communication options that are supported by SAP systems. (4

Correct)

1. HyperText Transfer Protocol (HTTP)

2. Simple Mail Transfer Protocol (SMTP)

3. Remote Function Call (RFC)

4. Business Application Programming Interfaces (BAPIs)

5. Extended Data Transfer Protocol

6. SAP Transfer Protocol

Correct Answer : 1,2,3,4

Question 24

Ques:- For which of the following functions can Business Application Programming Interfaces (BAPIs) be

used? (3 Correct)

1. Request data from an SAP system

2. Pass data to an SAP system

3. Transfer SAP screen images to third-party applications (such as Microsoft Word)

4. Access business processes in SAP systems

Correct Answer : 1,2,4

Question 15

Ques:- Which of the following standards are implemented in SAP NetWeaver AS to support Web

services ? (4 Correct)

1. XML

2. SOAP

3. WDSL

4. UDDI

5. Web server

Correct Answer : 1,2,3,4

Question 16

Ques:- Which of the following is the tool to implement and store BAPIs?

1. Function Builder

2. ABAP Editor

3. Class Builder

4. ABAP Dictionary

Correct Answer : 1

Question 17

Ques:- Which of the following statements apply accurately to Application Link Enabling (ALE)? (2

Correct)

1. ALE can be used to exchange data exclusively between SAP systems of the same release

2. ALE can be used to exchange data using web services

3. ALE can be used to exchange data between collaborating systems using BAPIs

4. ALE can be used to communicate between the systems in your system landscape using RFC.?

5. ALE can be used to exchange data between AS ABAP and AS Java systems.

Correct Answer : 3,4

Question 18

Ques:- Which of the following layers contains the user interface where each user can access a program,

enter new data, and receive the results of a work process?

1. Application server layer

2. Presentation server layer

3. Application logic layer

4. SAP NetWeaver Application

Correct Answer : 2

 

Question 19

Ques:- Which of the following is the concept of a program being made up of several units, instead of

being made up of a single block?

1. Isolation

2. Modularity

3. Universality

4. Multiplicity

Correct Answer : 2

Question 20

Ques:- Which of the following system development objects are included in the Repository? (3 Correct)

1. Programs

2. Function modules

3. Object Navigator

4. Definitions of database tables

Correct Answer : 1,2,4

Question 21

Ques:- Which of the following ABAP Workbench tools is used to edit the source code?

1. ABAP Editor

2. ABAP Dictionary

3. Repository Information System

4. Menu Painter

Correct Answer : 1

Question 22

Ques:- Which of the following are package types? (2 Correct)

1. Application component

2. Development package

3. Main package

4. Software component

Correct Answer : 2,3

Question 23

Ques:- When is the transport of development objects for a development request triggered?

1. When an object is saved

2. When an object is activated

3. When a task is released

4. When a request is released

Correct Answer : 4

Question 24

Ques:- Which of the following statements is correct about the ABAP programming language? (3 Correct)

1. It enables multi-language applications.

2. It enables SQL access.

3. It is platform-dependent.

4. It is typed.

Correct Answer : 1,2,4

Question 25

Ques:- How do you include comment lines?

1. Begin the line with a pound # in the first column.

2. Begin the line with an asterisk * in the first column.

3. End the line with an asterisk * in the last column.

4. End the line with a pound # in the last column.

Correct Answer : 2

Question 26

Ques:- After a project employee completes the required development task, he or she should do the

following:

1. Transfer the task to the Production System

2. Release the task within the Change request

3. Unlock and export the task to the Transport Directory

4. Export the Project Request

Correct Answer : 2

Question 27

Ques:- Which of the following are complete ABAP standard types? (3 Correct)

1. T (Time)

2. C (Character)

3. N (Numerical character)

4. INT8 (Integer with Length of 8 bytes)

5. D (Date)

Correct Answer : 1,4,5

Question 28

Ques:- Which of the following is the operator used in an IF statement to formulate a negation before

logical conditions?

1. AND

2. OR

3. END

4. NOT

Correct Answer : 4

Question 29

Ques:- Which of the following are required in the syntax of the Message statement? (3 Correct)

1. Message number

2. Message type

3. Message class

4. Message role

Correct Answer : 1,2,3

Question 30

Ques:- In nested loops, which of the following contains the loop pass number of the loop in which it is

located?

1. sy-index

2. sy-repid

3. sy-uname

4. sy-mandt

Correct Answer : 1

Question 31

Ques:- You can use the logical expression IS SUPPLIED for any formal parameter passed to which

modularization unit? (3 Correct)

1. Function module

2. Static method

3. Instance method

4. Subroutine (FORM routine)

Correct Answer : 1,2,3

Question 32

Ques:- What are the differences between displaying in a full screen and in a container? (2 Correct)

1. Any type of ALV allows the use of event handling.

2. Only an ALV in a container allows the use of event handling.

3. The only difference is that the container name must be specified when creating the ALV object.

4. The container requires the use of an additional object (a container control).

5. The full screen requires Dynpro programming.

6. Only a full-screen ALV allows the use of event handling.

Correct Answer : 1,4

Question 33

Ques:- In which of the following source code blocks can you define local data objects? (3 Correct)

1. AT SELECTION-SCREEN event block

2. PBO module

3. Function module

4. Subroutine

5. Static method

Correct Answer : 3,4,5

Question 34

Ques:- What must you do to create a singleton class? (3 Correct)

1. Implement the IF_UMM_SINGLETON interface in the class

2. Set the class instantiation to private

3. sDefine the class as abstract

4. Instantiate the class in a static method of the class itself

5. Define the class as final

Correct Answer : 2,4,5

Question 35

Ques:- When analyzing a program, which tasks can you perform using the code inspector? (3 Correct)

1. Discover unused variables.

2. Evaluate the time needed for program execution.

3. Determine used database tables.

4. Inspect the memory consumption

5. Execute the extended program check

Correct Answer : 1,3,5

Question 36

Ques:- Which of the following items are used in a Web Dynpro Application to transport database data to

the user interface? (2 Correct)

1. Interface controller

2. Inbound plug

3. Context node

4. Supply function

Correct Answer : 1,3

Question 37

Ques:- Which of the following can you assign a search help to? (3 Correct)

1. Table type

2. Data element

3. Domain

4. Check table

5. Structure component

Correct Answer : 2,4,5

Question 38

Ques:- DOG is a subclass of ANIMAL. You have created a variable of type ANIMAL that references an

instance of the DOG class. Which of the following statements can you use to copy this reference to a

new variable of type DOG?

1. MOVE…. TO…..

2. MOVE……?TO……

3. MOVE-CORRESPONDING…… TO……

4. WRITE……TO……

Correct Answer : 2

Question 39

Ques:- Which of the following statements are true? (2 Correct)

1. A maintenance view is implemented as an inner join.

2. A database view is implemented as an outer join.

3. A maintenance view is implemented as an outer join.

4. A database view is implemented as an inner join.

Correct Answer : 3,4

Question 40

Ques:- To reserve an area on the screen for an ALV Grid Control, you must do the following:

1. Create an object (instantiate the object) of the class CL_GUI_ALV_GRID

2. Create an object (instantiate the object) of the class CL_SALV_TABLE

3. Create an object (instantiate the object) of the class CL_GUI_CUSTOM_CONTAINER

4. Use the Screen Painter

Correct Answer : 4

Question 41

Ques:- You have defined a classical screen (dynpro) with mandatory input fields. You want to exit the

screen using the Cancel button even if not all of the mandatory fields have been filled. What is necessary

to achieve this?

1. Assign function type E to the Cancel button and handle it in a module with the addition AT EXIT[1]COMMAND.

2. Use the LOOP AT SCREEN. ... ENDLOOP statement to set the "required" property of the input

fields to zero.

3. Set the function type assigned to the Cancel button to S and handle it in a module with the

addition AT EXIT-COMMAND.

4. Set the function code assigned to the Cancel button to CANCEL and handle it in a module with

the addition AT EXIT-COMMAND.

Correct Answer : 1

Question 42

Ques:- What can you change in the ABAP Debugger?

1. Definition of a structure

2. Value of a reference variable

3. Content of an internal table

4. Value of a constant

Correct Answer : 3

Question 43

Ques:- Which must a search help do? (4 Correct)

1. Use a table or a view for data selection

2. Determine the values for selection by the user

3. Have a dialog with the user

4. Be used from a screen

5. Allow the user to select a response

Correct Answer : 2,3,4,5

Question 44

Ques:- Each component has an interface; of what does this interface consist? (2 Correct)

1. Data Container

2. Interface context

3. Interface controller

4. Interface view

Correct Answer : 3,4

Question 45

Ques:- Which of the following functions does the ABAP Dispatcher perform? (2 Correct)

1. It distributes user requests among available work processes.

2. It communicates with other instances in the system.

3. It enables communication between SAP systems and external application systems.

4. It directs HTTP requests from an SAP system to a web server.

Correct Answer : 1,2

Question 46

Ques:- You want to create a transparent table in the ABAP dictionary. When the table is physically

created in the database?

1. When you save the table

2. When you activate the table

3. When you run the database utility transaction (SE14)

4. When you insert the table name and select create

Correct Answer : 2

Question 47

Ques:- Which of the following generic types can you use to define a field symbol that will be assigned to

a character string? (3 Correct)

1. Type clike

2. Type csequence

3. Type xsequence

4. Type any table

5. Type any

Correct Answer : 1,2,4

Question 48

Ques:- When must a foreign key have domain equality?

1. For a text table

2. For a check field

3. Always

4. Never

Correct Answer : 2

Question 49

Ques:- You always want to check the user authorization for data entered in an input field of a selection

screen.Where do you do this?

1. In the event block INITIALIZATION

2. In the event block AT SELECTION-SCREEN

3. In the event block AT SELECTION-SCREEN on VALUE-REQUEST

4. In the event block AT SELECTION-SCREEN OUTPUT

Correct Answer : 2

Question 50

Ques:- At most, how many buttons can the application toolbar have on the screen?

1. None of the above

2. 10

3. 20

4. 30

5. 35

Correct Answer : 5