The application layer is located at the top of the TCP/IP protocol layers. This one contains the network applications which make it possible to communicate using the lower layers. The software in this layer therefore communicates using one of the two protocols of the layer below (the transport layer), i.e. TCP or UDP. In computer networking, an application layer firewall is a firewall operating at the application layer of a protocol stack. Generally it is a host using various forms of proxy servers to proxy traffic instead of routing it. As it works on the application layer, it may inspect the contents of the traffic, blocking what the firewall administrator views as inappropriate content, such as certain websites, viruses, and attempts to exploit known logical flaws in client software, and so forth. An application layer firewall does not route traffic on the network layer. All traffic stops at the firewall which may initiate its own connections if the traffic satisfies the rules.
The DNS translates Internet domain and host names to IP addresses. DNS automatically converts the names we type in our Web browser address bar to the IP addresses of Web servers hosting those sites. DNS implements a distributed database to store this name and address information for all public hosts on the Internet.
SMTP - Short for Simple Mail Transfer Protocol, a protocol for sending e-mail messages between servers.
Telnet is the main Internet protocol for creating a connection to a remote server.
D. manage user and group entries in Oracle Internet Directory (OID)
6. Described the format of oracle table?
create table <table_name>
10. Can we give DML statements inside a function?
YES YOU CAN USE DML(SELECT) WITHIN User defined function(UDF). BUT KEEP IN MIND THAT UDF CAN ONLY RETURN ONE SINGLE VALUE. BUT YOU CANT USE DDL(CREATE/ALTER/DROP) WITHIN UDF. TO DO THAT YOU HAVE TO USE SP(Stored Procedure).
11. Define oracle application certification?
Oracle application certification is an Oracle certification exam.
SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.
13. Described any DML example?
DML EXAMPLE:
CREATE OR REPLACE Function IncomeLevel
( name_in IN varchar2 )
RETURN varchar2
IS
monthly_value number(6);
ILevel varchar2(20);
cursor c1 is
select monthly_income
from employees
where name = name_in;
BEGIN
open c1;
fetch c1 into monthly_value;
close c1;
IF monthly_value <= 4000 THEN
ILevel := 'Low Income';
ELSIF monthly_value > 4000 and monthly_value <= 7000 THEN
ILevel := 'Avg Income';
ELSIF monthly_value > 7000 and monthly_value <= 15000 THEN
ILevel := 'Moderate Income';
ELSE
ILevel := 'High Income';
END IF;
RETURN ILevel;
END;
14. Described the Configuration of the SAP modules?
Transaction SPRO - this is the main tree for all the configuration.
15. What are the basics feature of SAP?
► Configuration of the SAP modules
► Function Key
► Navigation
In 4.x, you can have long SAP transaction code up to a maximum of 20 character
16. Described SAP function key feature?
o F1 - Help
o F4 - Possible entries or matchcode for the field you are accessing
o F5 - Selection screen
o F7 - Previous screen
o F8 - Next screen
o F9 - Technical info
o CTRL+X - Cut
o CTRL+C - Copy
o CTRL+V - Paste
17. Described SAP Navigation key feature?
o /n Skip to the next record if you are processing one batch input session
o /bend Cancel a batch input foreground process
o /nend Close all R/3 sessions and logoff
o /nxxx x Call the transaction xxxx in the same session
o /o Generate a session list
o /oxxx x Call the transaction xxxx in an additional session
o /i Delete the current session
o /h Turn the debug mode on
o /$tab Reset all buffers (for System Administrators)
o /$syn c Synchronize instances buffers (for System Administrators)
18. Described the concept of "Business Content" in SAP Business Information Warehouse?
Business Content is a pre-configured set of role and task-relevant information models based on consistent Metadata in the SAP Business Information Warehouse. Business Content provides selected roles within a company with the information they need to carry out their tasks. These information models essentially contain roles, workbooks, queries, InfoSources, InfoCubes, key figures, characteristics, update rules and extractors for SAP R/3, mySAP.com Business Applications and other selected applications.
19. What are the different types of ERP?
SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP's most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.
ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.
International Demonstration and Education System. A sample application provided for faster learning and implementation.
22. Can the BW run without a SAP R/3 implementation?
Certainly. You can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data. Here you simply need to map the transfer structures associated with BW data sources (InfoCubes, ODS tables) to the inbound data files or use 3rd part tool to connect your flat files and other data sources and load data in BW. Several third party ETL products such as Acta, Infomatica, DataStage and others will have been certified to load data in BW.
23. Why do we usually choose to implement SAP?
There are number of technical reasons numbers of companies are planning to implement SAP. It's highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.
24. What should approach for writing a BDC program?
Convert the legacy system data to a flat file and convert flat file into internal table. Transfer the flat file into sap system called "sap data transfer". Call transaction(Write the program explicitly) or create sessions (sessions are created and processed ,if success data will transfer).
The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.
