IT-6202 - Database Management System 1 (Oracle) oed answer key

Showing 121 to 140 of 144 total answers.

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhich of the following is the correct query that displays the lowest salary rename as "LOWEST SALARY", maximum salary rename as "HIGHEST SALARY" and department_id concatenated to job_id?

Answer

SELECT CONCAT(DEPARTMENT_ID,JOB_ID),MIN(SALARY), MAX(SALARY)FROM EMPLOYEESGROUP BY JOB_ID,DEPARTMENT_ID;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT LASTNAME,SALARY, RPAD(SALARY,4,'@')FROM EMPLOYEESWHERE SALARY BETWEEN 4000 AND 9000LASTNAME LIKE =E2=80=98%S';

Answer

MOURGOS 5800 5800

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT LASTNAME,SALARY, RPAD(SALARY,4,'@')FROM EMPLOYEESWHERE SALARY BETWEEN 4000 AND 9000LASTNAME LIKE =E2=80=98%S';

Answer

MOURGOS 5800 5800

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order todisplay the firstname and length of firstname rename the column length of firstname as Number of Character of all employees whose salary is between 4400 and 8300

Answer

SELECT FIRSTNAME, LENGTH(FIRSTNAME) AS "NUMBER OF CHARACTER"FROM EMPLOYEESWHERE SALARY BETWEEN 4400 AND 8300;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT TRIM(=E2=80=98K' FROM LASTNAME)AS TRIM, LASTNAME, DEPARTMENT_ID, MANAGER_IDFROM EMPLOYEESWHERE DEPARTMENT_ID = 50AND MANAGER_ID = 100;

Answer

MOURGOS MOURGOS 50 100

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT TRIM(=E2=80=98K' FROM LASTNAME)AS TRIM, LASTNAME, DEPARTMENT_ID, MANAGER_IDFROM EMPLOYEESWHERE DEPARTMENT_ID = 50AND MANAGER_ID = 100;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT LOWER(LASTNAME||'with a salary of'||SALARY) as Record, LENGTH(LASTNAME) as LnameFROM EMPLOYEESWHERE MANAGER_ID IS NULLOR SALARY IS NULL;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT LOWER(LASTNAME||'with a salary of'||SALARY) as Record, LENGTH(LASTNAME) as LnameFROM EMPLOYEESWHERE MANAGER_ID IS NULLOR SALARY IS NULL;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT FIRSTNAME, SALARY, LPAD(SALARY * 010 + SALARY - 100, 8, =E2=80=98$') AS BONUSFROM EMPLOYEESWHERE DEPARTMENT_ID NOT IN (10, 110, 50AND SALARY=17000;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order to display the firstname concatenated to salary with additional column salary that provides a computation of salary * 2. Rename the column as Increase of all employees whose lastname ends with N.

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT FIRSTNAME, SALARY, LPAD(SALARY * 0.10 + SALARY - 100, 8, =E2=80=98$') AS BONUSFROM EMPLOYEESWHERE DEPARTMENT_ID NOT IN (10, 110, 50AND SALARY=17000;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhich of the following is the correct query that display the Job_id and add the ff: function:Count the total number of job_id per distinct values; Compute for the summary of salary per job_id; and Compute for the average salary per job_id

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESWhat query should be used in order to display the lastname and salary of all employees whose department_id = 60 or job_id like =E2=80=98_T%' Format the salary to be 15 character long, left padded with =E2=80=98$' as special character Label the column Salary

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order to display the lastname and salary of all employees whose department_id = 60 or job_id like =E2=80=98_T%'. Format the salary to be 15 character long, left padded with =E2=80=98$' as special character. Label the column Salary.

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESWhat query should be used in order to display the salary leftpadded with 15 character long and =E2=80=98$' as special character and another column salary right padded with 10 character long with=E2=80=98@' as special character used of all employees in 201, 176 and 144

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order todisplay the Firstname concatenated to employees original salary plus concatenate again a new column salary that multiplies the original salary into three. Rename the column as Dream Salaries.Note sort the salary in descending order.

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order to display the salary leftpadded with 15 character long and =E2=80=98$' as special character and another column salary right padded with 10 character long with =E2=80=98@' as special character used of all employees in 201, 176 and 144.

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhich of the following is the correct report that display the smallest (minimum) Surname.. and apply the ff. functions:Get the average salary; Group the data per job_id; Get only job_id with a keyword "REP"; and Apply having clause, which the max salary per job_id is greater than 5000.

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESWhat query should be used in order to display the employees lastname concatenated to salary Format the salary column to 6 character long right padded with =E2=80=98*' as special character for all employees whose manager_id is null or salary between 4000 and 6000 Rename the column as employees and their Salaries

Page 7 of 8

1...3 4 5 6 7 8

Introduction to Multimedia

Computer Programming 1

System Integration and Architecture 1

Social and Professional Issues

Kritikal na Pagbasa, Pagsulat at Pagsasalita

IT-6202 - Database Management System 1 (Oracle) oed answer key

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhich of the following is the correct query that displays the lowest salary rename as "LOWEST SALARY", maximum salary rename as "HIGHEST SALARY" and department_id concatenated to job_id?

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT LASTNAME,SALARY, RPAD(SALARY,4,'@')FROM EMPLOYEESWHERE SALARY BETWEEN 4000 AND 9000LASTNAME LIKE =E2=80=98%S';

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT LASTNAME,SALARY, RPAD(SALARY,4,'@')FROM EMPLOYEESWHERE SALARY BETWEEN 4000 AND 9000LASTNAME LIKE =E2=80=98%S';

Avail our OED Service!