Question.1 How the system identifies a ‘Posting Period’? Answer: Based on the posting date entered into the system while posting a document, the system automatically determines the period, by looking at the document date and the year. However, for this to occur .you should have properly defined the fiscal year..
Question.1 What is Meta Data Repository? Answer: Meta Data is a data about the data. It also contains Query statistics ETL statistics Business subject area Source Information Target Information Source to Target mapping Information. Question.2 What is Data Stage Engine? Answer: It is a JAVA engine running at the background…
Question.1 What are the benefits of .NET Framework? Answer: .NET Framework offers many benefits to application developers. Some of these benefits are as follows: Consistent programming model —.NET Framework provides a consistent object-oriented programming model across various languages. You on we this model to create programs for performing different tasks,..
Question.1 What are all the components of ‘SAP ERP’ Solution? Answer: • SAP ERP Central Component (ECC 6.0) • SAP SEM (Strategic Enterprise Management) (SEM 6.0) • SAP cProject Suite (Project and Portfolio Management 4.0) • SAP SRM for ERP (SRM 5.0) • SAP Catalog Content Management (CCM 2.0 for..
Question.1 What is SAP R/3? R/3 stands for? Answer: System Application and Products. R stands for real-time environment version 3. Question.2 What is T_Code? Answer: If we want to perform any operations that can be performed with T_Code. T_Code stands for a collection of dialog steps.
Question.1 What are the components of Informatica? And what is the purpose of each? Answer: Informatica Designer, Server Manager & Repository Manager. Designer for Creating Source & Target definitions, Creating Mapplets and Mappings etc. Server Manager for creating sessions & batches, Scheduling the sessions & batches, Monitoring the trig jered..
Question.1 what is the link/control between sales and distribution and quality? Answer: sales&distridution and the quality that is the company is give the good service and the resonalbule rates that way the Company give it is the link between the SD team member with pp member to give good product..
Question.40 Display the name,job of the employees and display Executive if the job is Clerk , RM if the job is Manager else display the job. Answer: SELECT ename,job, DECODE(job, ‘CLERK’, ‘EXECUTIVE’, ‘MANAGER’, ‘RM’, job) FROM emp; Question.41 To display employee name, department name and department number for all employees…
Question. 20 To display the number of employees working with the company. Answer: SQL>SELECT COUNT(*) FROM emp; Question.21 To display the total salaries payable to employees. Answer: SQL>SELECT SUM(sal) FROM emp; Get A live Demo Oracle Online Course
Emp Table: EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH CLERK 7902 17-Dec-95 800 20 7499 ASHA SALESMAN 7698 20-Feb-95 1600 300 30 7521 WASIM SALESMAN 7698 22-Feb-95 1250 500 30 7566 RAJA MANAGER 7839 2-Apr-95 2975 20 7654 MARIA SALESMAN 7698 28-Sep-95 1250 1400 30 7698 BILL..