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

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
  1. 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';

     

    1. One of the following is not directly supported in PL/SQL blocks

        a.

      delete

        b.

      alter

        c.

      update

        d.

      insert

      1. 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

         

        1. 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;

           

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

             

            1. .... 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;

               

              1. ... is used to inherit the data type from another variable of an attribute.

                  a.

                is

                  b.

                %type

                  c.

                as

                  d.

                $type

                 

                 

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Binary numbers
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education