0068

        ----------
                 0

        SQL> rollback;

        Rollback complete.

        SQL> select count(*)
          2  from   customers
          3  where  cust_state_province = 'Delhi';

          COUNT(*)
        ----------
                34

Progress Check

1. Of the following four items, which one is not a DML keyword?

A. select

B. insert

C. create

D. update

2. How can the defined columns of the CUSTOMERS table be displayed?

3. In order to retrieve data from the database, there are two keywords that are mandatory. Name them.

4. Write a SQL statement to select the customer last name and city for all customers in Utah with a credit limit less than 5000.

Progress Check Answers

1. C. The four DML keywords are select, insert, update, and delete.

2. The following code listing displays the defined columns for the CUSTOMERS table: desc customers;

3. Every SQL statement that retrieves data from the database will have both the select and from keywords.

4. The following SQL statement is a correct answer:

SQL> select cust_last_name, cust_city
   2   from   customers
   3   where cust_state_province = 'UT'
   4   and cust_credit_limit < 5000;

Team Fly

0068