Category: Bangla Tips Category

1. How do we know that the algorithm produce the correct result? a. Desk Checking b. Program Flow Chart c. Debugging d. All of the above. Answer: a   2. A group of instructions for a computer that causes it to perform a task as known as…………….. a. Algorithm b. Statement c. Computer Program d. Counter Answer: c 3. Which steps allow for programming process? a. Coding the program b. Defining the problem c. Preparing an algorithm d. All of the above Answer: d   4. A sequence of steps…

Oracle Database 10g SQL Fundamentals I   Chapter07: Using the Set Operators & Chapter 08: Manipulating Data Question: 1 View the Exhibit and examine the structure of the EMPLOYEES and DEPARTMENTS tables.   Which SET operator would you use in the blank space in the following SQL statement to list the departments where all the employees have managers?   SELECT department_id FROM departments ____ SELECT department_id FROM employees WHERE manager_id IS NULL;   A. UNION B. MINUS C. INTERSECT D. UNION ALL   Answer: B   Question: 2 View the…

Oracle Database 10g SQL Fundamentals I Chapter 06: Subqueries Question: 1 View the Exhibit and examine the description of the EMPLOYEES table.   You want to display the EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT_ID for all the employees who work in the same department and have the same manager as that of the employee having EMPLOYEE_ID 104. To accomplish the task, you execute the following SQL statement: SELECT employee_id, first_name, department_id FROM employees WHERE (manager_id, department_id) =(SELECT department_id, manager_id FROM employees WHERE employee_id = 104) AND employee_id <> 104; When you execute…