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
-
-
-
-
-
-
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)