Question

QUESTION 27

1. The SET command is used in which statement

   		UPDATE
   		SELECT DISTINCT
   		DELETE FROM
   		INSERT VALUES

QUESTION 28

1. Which view would you use to see only the tables you have created

   		ALL_TABLES
   		USER_TABLES
   		USER_TABS
   		ALL_OBJECTS

QUESTION 29

1. Which command should you use to write logical units of work to disk permanently

   		SAVEWORK
   		COMMIT
   		ROLLBACK
   		INSERT

QUESTION 30

1. A Top-N Analysis is capable of ranking a top or bottom set of results.

   True

   False

QUESTION 31

1. If you are performing an UPDATE statement with a subquery, it MUST be a correlated subquery?

   True

   False

QUESTION 32

1. Given the following CREATE VIEW statement, what data will be returned?

   CREATE OR REPLACE VIEW emp_dept

   AS SELECT SUBSTR(e.first_name,1,1) ||' '||e.last_name emp_name, e.salary, e.hire_date, d.department_name

   FROM employees e, departments d

   WHERE e.department_id = d.department_id

   AND d.department_id >=50;

   		First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_id of all employees working in department number 50 or higher.
   		First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_id of all employees working in department number 50.
   		First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_name of all employees working in department number 50.
   		First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_name of all employees working in department number 50 or higher.

Answer 1

///////////*********************************************************************************************************************************

Hi friend , please find the solution of above question, if you have any doubt feel free to ask.

Thank You.

**************************************************************************************************************************////////////////////////

27. A) UPDATE

28. B) USER'S TABLE

29. B) COMMIT

30. True

31. True

32. D) First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_name of all employees working in department number 50 or higher.