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.3 What is the..
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…
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 02-Apr-95 2975 20 7654 MARIA SALESMAN 7698 28-Sep-95 1250 1400 30 7698 BILL..
Question.1 What is the purpose of garbage collection in Java, and when is it used? Answer: The purpose of garbage collection is to identify and discard objects that are no longer needed by a program so that their resources can be reclaimed and reused. A Java object is subject to..
Question.1 What is a database? Answer: Database offer a single point of mechanism for storing and retrieving information with the help of tables. Table is made up of columns and rows where each column stores specific attribute and each row displays a value for the corresponding attribute. It is a..
Question.1 What is private mode? When does user switch to user mode? Answer: Private mode is a mode where the heap data is getting exclusively allocated by the user and is no more shared across the system. This happens when your extended memory is exhausted. Question.2 What is osp$ mean?..
Question.1 What is the difference between DataStage and Informatica? Answer: DataStage support parallel processing which informatica doesn’t. Links are object in the DataStage ,in Informatica it’s a port to port connectivity .In Informatica, its easy to implement Slowly Changing Dimensions which is little bit complex in Data Stage. DataStage doesn’t..