Question.1 How to create user account? Answer: Using T_code SUO1 we create the user accounts. Question.2 what are the various steps for crating the User? Answer: Address Data, Logon Data, Defaults, Parameters, Profiles, Activity groups, Users. Question.3 What are the Different types of users? Answer: External..
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; [sociallocker] Question.22 To display the maximum salary of employee working as a salesman. Answer: SQL>SELECT MAX(sal) FROM..
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 Consistent Backup? Answer: A Consistent backup is one in which the files being backed up contain all changes upto the same system change number (SCN). Question.2 What is fractured Block? Answer: Because the database continues writing to the file during an online backup, there is the possibility..
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 Query parameter in SSRS? Answer: Query parameters is mentioned in the query of the datasources that are to be included into the SQL script’s WHERE clause of the SQL that can accept parameters. Query parameters begin with the symbol @.The name should not contain spaces and can..