Given the following table: Student ( id, first_name, last_name, address, program, phone), which of the following statements will list the number of students who are in IT program? a. select max(*) from student where program = 'IT'; b. select sum(*) from student where program = 'IT'; c. select count(*) from student where program = 'IT'; d. select count(program) from student where program = 'IT'; One of the following is not directly supported in PL/SQL blocks a. delete b. alter c. update d. insert
-
Given the following table: Student ( id, first_name, last_name, address,
program , phone), which of the following statements will list the number of students who are in IT program?a. select max(*) from student where program = 'IT';
b. select sum(*) from student where program = 'IT';
c. select count(*) from student where program = 'IT';
d. select count(program) from student where program = 'IT';
-
One of the following is not directly supported in PL/SQL blocks
a. delete
b. alter
c. update
d. insert
-
Which of the following is not a correct variable declaration in PL/SQL?
a. college varchar2(20) ;
b. college varchar2(20) = 'Sur'
c. college varchar2(20) := 'Sur';
d. college varchar2(20) not null;
In handling foreign key violations, the option to reject if the row is referenced in another table is ....
a. Cascade
b. Set null
c. set default
d. No action
-
Given the following table: Student ( id, first_name, last_name, address, program, phone), which of the following statements will list the first name of the students with column titled as Name?
a. select first_name from student;
b. select name from student;
c. select first_name from student as name;
d. select first_name as name from student;
-
Given the following table: Student ( id, first_name, last_name, address, program, phone), which statement will change the program for students in IT to a new program called ICT?
a. update student set program = 'ICT';
b. update student set program = 'ICT' where program = 'IT';
c. update program of student where program = 'IT';
d. update student set program = 'IT' where program = 'ICT';
-
.... will change department ID 20 of employee table to 15.
a. UPDATE Employee SET Department_ID = 15;
b. UPDATE Employee SET Department_ID = 20 WHERE Department_ID = 15;
c. UPDATE Employee SET Department_ID = 20;
d. UPDATE Employee SET Department_ID = 15 WHERE Department_ID = 20;
-
... is used to inherit the data type from another variable of an attribute.
a. is
b. %type
c. as
d. $type
-
-
-
-
-
-
Step by step
Solved in 2 steps