数据库应用基础_实验手册.pdf

《数据库应用 1》（英） 练习手册 Database Application 1 Practice Handbook 凤羽翚编 2005 年 Practice Handbook of Database Application 1 目录 Practice 13 Practice 28 Practice 311 Practice 417 Practice 522 Practice 626 Practice 729 Practice 831 Practice 934 Practice 1036 Practice 1137 Practice 1239 Practice 1340 Practice 1743 Workshop 44 Practice 1553 Practice 1655 Practice 1757 Practice 1862 Practice 1967 Practice 2070 Additional Practices 73 Additional Practice Solutions92 Table Descriptions and Data of Additional Practice103 2 Practice Handbook of Database Application 1 Practice 1 Practice 1 Overview This practice covers the following topics: • Selecting all data from different tables • Describing the structure of tables • Performing arithmetic calculations and specifying column names • Using SQL*Plus or iSQL*Plus Practice 1 1. Initiate an iSQL*Plus session using the user ID and password provided by the instructor. 2. iSQL*Plus commands access the database. True/False 3. The following SELECT statement executes successfully: SELECT last_name, job_id, salary AS Sal FROM employees; True/False 4. The following SELECT statement executes successfully: SELECT * FROM job_grades; True/False 5. There are four coding errors in this statement. Can you identify them? SELECT employee_id, last_name sal x 12 ANNUAL SALARY FROM employees; 6. Show the structure of the DEPARTMENTS table. Select all data from th