IT-6202 - Database Management System 1 (Oracle) oed answer key
Showing 141 to 144 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 belowTable 10 EMPLOYEESWhich of the following is the correct query that display the maximum lastname concatenated to firstname and rename the column as "Employees Name", Job_id and apply the ff functions:Count the Job_id; Apply where condition whose lastname ends with letter =E2=80=98N'; Group the job_id; and Apply having clause of employees having average salary that is greater than 10000
Answer
SELECT MAX(LASTNAME||FIRSTNAME) AS "EMPLOYEES NAME", JOB_ID, COUNT(JOB_ID)FROM EMPLOYEESWHERE LASTNAME LIKE '%N'GROUP BY JOB_IDHAVING AVG(SALARY)>10000;
#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 maximum lastname concatenated to firstname and rename the column as "Employees Name", Job_id and apply the ff. functions:Count the Job_id; Apply where condition whose lastname ends with letter =E2=80=98N'; Group the job_id; and Apply having clause of employees having average salary that is greater than 10000.
Answer
SELECT MAX(LASTNAME||FIRSTNAME) AS "EMPLOYEES NAME", JOB_ID, COUNT(JOB_ID)FROM EMPLOYEESWHERE LASTNAME LIKE '%N'GROUP BY JOB_IDHAVING AVG(SALARY)>10000;
#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 with firstname and with a =E2=80=98, (comma)' in between A rename on the concatenated column as Complete Name Note all values in Complete Name column should be in lowercase plus display the length of employees lastname for all employees whose lastname starts with letter M sort the lastname in its default order
Answer
SELECT LOWER(LASTNAME||','||FIRSTNAME) AS "COMPLETE NAME",LENGTH(LASTNAME)FROM EMPLOYEESWHERE LASTNAME LIKE 'M%';
#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 employees lastname concatenated with firstname and with a =E2=80=98, (comma)' in between. A rename on the concatenated column as Complete Name. Note all values in Complete Name column should be in lowercase plus display the length of employees lastname for all employees whose lastname starts with letter M sort the lastname in its default order.
Answer
SELECT LOWER(LASTNAME||','||FIRSTNAME) AS "COMPLETE NAME",LENGTH(LASTNAME)FROM EMPLOYEESWHERE LASTNAME LIKE 'M%';