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

Showing 81 to 100 of 144 total answers.

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of updating the COURSE to =E2=80=98N/A' of all students from STUDENTS table whose course IS NULL;

Answer

UPDATE STUDENTSSET COURSE = =E2=80=98N/A=E2=80=99WHERE COURSE IS NULL;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of updating the COURSE to =E2=80=98N/A' of all students from STUDENTS table whose course IS NULL;

Answer

UPDATE STUDENTSSET COURSE = =E2=80=98N/A'WHERE COURSE IS NULL;

#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 NAME LIKE =E2=80=98%A';

Answer

It retrieves the record of ANNA and MOJICA

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example updating the student LASTNAME TO =E2=80=98SANTOS' and course to =E2=80=98BSCS' whose STUD_ID is equal to 109?

Answer

UPDATE EMPLOYEESSET LASTNAME = =E2=80=98SANTOS=E2=80=99, COURSE = =E2=80=98BSCS=E2=80=99WHERE STUD_ID = 109;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example updating the student LASTNAME TO =E2=80=98SANTOS' and course to =E2=80=98BSCS' whose STUD_ID is equal to 109?

Answer

UPDATE EMPLOYEESSET LASTNAME = =E2=80=98SANTOS', COURSE = =E2=80=98BSCS'WHERE STUD_ID = 109;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of updating the LASTNAME to =E2=80=98REYES' of all students from STUDENTS table whose STUD_ID is equal to 01020564?

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Which of the following is the correct example of updating the LASTNAME to =E2=80=98REYES' of all students from STUDENTS table whose STUD_ID is equal to 01020564?

#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';

#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, POSITION, ID * (100 + 3)FROM ORGCHARWHERE ORG = =E2=80=98AMATHS'

#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';

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Refer to table 10, suppose that user update the table using the statement below what would be the possible output?UPDATE ORGCHARTSET ORG = =E2=80=98PCS'WHERE ORG IS NULL;

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Refer to table 1.0, suppose that user update the table using the statement below what would be the possible output?UPDATE ORGCHARTSET ORG = =E2=80=98PCS'WHERE ORG 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 EMPLOYEESWhich of the following is the correct query that displays the maximum salary?

#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 NAME LIKE =E2=80=98A%'AND POSITION = =E2=80=98SEC';

#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 NAME LIKE =E2=80=98A%'AND POSITION = =E2=80=98SEC';

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Refer to table 10, suppose that user insert the following values using the statement below what would be the possible output?INSERT INTO ORGCHART (ID, NAME)VALUES (11,'YAMBAO,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 EMPLOYEESWhich of the following is the correct query that displays the minimum lastname?

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Refer to table 1.0, suppose that user insert the following values using the statement below what would be the possible output?INSERT INTO ORGCHART (ID, NAME)VALUES (11,'YAMBAO,JUN');

#IT-6202

Awesome StudentQuestion • Database Management System 1 (Oracle)

Refer to table 10, suppose that user insert the following values using the statement below what would be the possible output?INSERT INTO ORGCHART VALUES (11,'YAMBAO,JUN', NULL, NULL);

Page 5 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 of updating the COURSE to =E2=80=98N/A' of all students from STUDENTS table whose course IS NULL;

Which of the following is the correct example of updating the COURSE to =E2=80=98N/A' of all students from STUDENTS table whose course IS NULL;

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

Which of the following is the correct example updating the student LASTNAME TO =E2=80=98SANTOS' and course to =E2=80=98BSCS' whose STUD_ID is equal to 109?

Which of the following is the correct example updating the student LASTNAME TO =E2=80=98SANTOS' and course to =E2=80=98BSCS' whose STUD_ID is equal to 109?

Which of the following is the correct example of updating the LASTNAME to =E2=80=98REYES' of all students from STUDENTS table whose STUD_ID is equal to 01020564?

Which of the following is the correct example of updating the LASTNAME to =E2=80=98REYES' of all students from STUDENTS table whose STUD_ID is equal to 01020564?

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';

Refer to table 1.0 Using the SELECT statement below what would be the possible output:SELECT NAME, ORG, POSITION, ID * (100 + 3)FROM ORGCHARWHERE ORG = =E2=80=98AMATHS'

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';

Refer to table 10, suppose that user update the table using the statement below what would be the possible output?UPDATE ORGCHARTSET ORG = =E2=80=98PCS'WHERE ORG IS NULL;

Refer to table 1.0, suppose that user update the table using the statement below what would be the possible output?UPDATE ORGCHARTSET ORG = =E2=80=98PCS'WHERE ORG IS 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 query that displays the maximum salary?

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

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

Refer to table 10, suppose that user insert the following values using the statement below what would be the possible output?INSERT INTO ORGCHART (ID, NAME)VALUES (11,'YAMBAO,JUN');

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 lastname?

Refer to table 1.0, suppose that user insert the following values using the statement below what would be the possible output?INSERT INTO ORGCHART (ID, NAME)VALUES (11,'YAMBAO,JUN');

Refer to table 10, suppose that user insert the following values using the statement below what would be the possible output?INSERT INTO ORGCHART VALUES (11,'YAMBAO,JUN', NULL, NULL);

Avail our OED Service!