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

Showing 101 to 120 of 144 total answers.

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example inserting a new value to STUDENTS table that will only add new data to STUD_ID and LASTNAME? The stud_id is 10 and lastname is =E2=80=98CRUZ'

Answer

INSERT INTO STUDENTS(STUD_ID,LASTNAME)VALUES(10,=E2=80=99CRUZ=E2=80=99);

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Refer to table 10 Using the SELECT statement below what would be the possible output:SELECT NAME, ORG, POSITIONFROM ORGCHARWHERE ORG 'JPCS'OR POSITION = =E2=80=98SEC'AND NAME LIKE =E2=80=98%N';

Answer

It will retrieve the record of JOAN,ROAN and JUN

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Refer to table 1.0 Using the SELECT statement below what would be the possible output:SELECT NAME, ORG, POSITIONFROM ORGCHARWHERE ORG 'JPCS'OR POSITION = =E2=80=98SEC'AND NAME LIKE =E2=80=98%N';

Answer

It will retrieve the record of JOAN,ROAN and JUN

#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 toget theSUBSTR function that returns the job_id = =E2=80=98REP'.

Answer

SELECT JOB_ID FROM EMPLOYEESWHERE SUBSTR(JOB_ID,4)='REP';

#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 TRUNC(563.396,1)FROM DUAL;

Answer

5633

#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 TRUNC(563.396,2)FROM DUAL;

#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 TRUNC(563.396,-2) FROM DUAL;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example inserting a new value to STUDENTS table that will only add new data to STUD_ID and LASTNAME? The stud_id is 10 and lastname is 'CRUZ' and the rest of the column is set to 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 EMPLOYEESWhich of the following is the correct that display distinct job_id and the the total number per distinct (unique) 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 below.Table 1.0 EMPLOYEESWhich of the following is the correct query that counts the number of ST_CLERK job_id? Rename the column as "Total no. of ST_CLERK".

#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 MINIMUM salary of employees per job_id? Note job_id should be in lowercase.

#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 MOD(SALARY,10) AS "EXCESS SALARY"FROM EMPLOYEESWHERE SALARY < 5000;

#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 in capitalized format rename the column as pangalan whose job_id is equal to =E2=80=98SA_REP'.

#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 todisplay a report that trim the letter =E2=80=98A' from lastname of all employees whose department_id between 60 and 90

#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||FIRSTNAME), JOB_IDFROM EMPLOYEESWHERE SUBSTR (JOB_ID,4)'REP';

#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 10 EMPLOYEESBased on the given SELECT statement below what would be the possible output? SELECT (LASTNAME||FIRSTNAME), JOB_IDFROM EMPLOYEESWHERE SUBSTR (JOB_ID,4)'REP';

#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 a report that trim the letter =E2=80=98A' from lastname of all employees whose department_id between 60 and 90.

#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 INITCAP(LASTNAME||','||FIRSTNAME) AS NAMEFROM EMPLOYEESWHERE JOB_ID LIKE '%PR%';

#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 INITCAP(LASTNAME||','||FIRSTNAME) AS NAMEFROM EMPLOYEESWHERE JOB_ID LIKE '%PR%';

Page 6 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

Which of the following is the correct example inserting a new value to STUDENTS table that will only add new data to STUD_ID and LASTNAME? The stud_id is 10 and lastname is =E2=80=98CRUZ'

Refer to table 10 Using the SELECT statement below what would be the possible output:SELECT NAME, ORG, POSITIONFROM ORGCHARWHERE ORG 'JPCS'OR POSITION = =E2=80=98SEC'AND NAME LIKE =E2=80=98%N';

Refer to table 1.0 Using the SELECT statement below what would be the possible output:SELECT NAME, ORG, POSITIONFROM ORGCHARWHERE ORG 'JPCS'OR POSITION = =E2=80=98SEC'AND NAME LIKE =E2=80=98%N';

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 toget theSUBSTR function that returns the job_id = =E2=80=98REP'.

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 TRUNC(563.396,1)FROM DUAL;

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 TRUNC(563.396,2)FROM DUAL;

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 TRUNC(563.396,-2) FROM DUAL;

Which of the following is the correct example inserting a new value to STUDENTS table that will only add new data to STUD_ID and LASTNAME? The stud_id is 10 and lastname is 'CRUZ' and the rest of the column is set to NULL.

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 that display distinct job_id and the the total number per distinct (unique) job_id.

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 counts the number of ST_CLERK job_id? Rename the column as "Total no. of ST_CLERK".

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 MINIMUM salary of employees per job_id? Note job_id should be in lowercase.

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 MOD(SALARY,10) AS "EXCESS SALARY"FROM EMPLOYEESWHERE SALARY < 5000;

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 in capitalized format rename the column as pangalan whose job_id is equal to =E2=80=98SA_REP'.

Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESWhat query should be used in order todisplay a report that trim the letter =E2=80=98A' from lastname of all employees whose department_id between 60 and 90

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||FIRSTNAME), JOB_IDFROM EMPLOYEESWHERE SUBSTR (JOB_ID,4)'REP';

Choose the letter of the correct answer based on the table EMPLOYEES as shown below Table 10 EMPLOYEESBased on the given SELECT statement below what would be the possible output? SELECT (LASTNAME||FIRSTNAME), JOB_IDFROM EMPLOYEESWHERE SUBSTR (JOB_ID,4)'REP';

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 a report that trim the letter =E2=80=98A' from lastname of all employees whose department_id between 60 and 90.

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 INITCAP(LASTNAME||','||FIRSTNAME) AS NAMEFROM EMPLOYEESWHERE JOB_ID LIKE '%PR%';

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 INITCAP(LASTNAME||','||FIRSTNAME) AS NAMEFROM EMPLOYEESWHERE JOB_ID LIKE '%PR%';

Avail our OED Service!