关系数据库试题(英文版以及答案)教材.docVIP

关系数据库（高级）01 题号 一 二 三 四 五 六 七 八 总分 评卷人 分数 一、填空题（每空2分，共20分） 1. Once a user enters the data for his transaction, he can either commit the transaction to make the changes permanent or ______________________ the transaction to undo the changes. 2. SQL consists of three components: Data Definition Language (DDL) Data Manipulation Language (DML) ___________________________ 3. By use of the SQL statement ALTER, delete the column Item_Size from the table ITEMCOPY. __________________________________________________________________ 4. Using the SELECT option of the SQL statement CREATE TABLE, create a table named ITEMCOPY which is a copy of the table ITEM. __________________________________________________________________ 5. Create an index for the following column that allows duplicate data to be entered:Table: HOME Column: Home_Name __________________________________________________________________ 6. Create a view named ITEM_PRICELIST, on the table ITEM, which only includes the columns:Item_No, Item_Description, Item_Wholesale_Price, Item_Retail_Priceand sorts the result by the Item_Description. __________________________________________________________________ 7. Assign the appropriate privileges on the table ITEMCOPY to the last one of the users detailed below(HN92): User Privilege HN90 Read only HN91 Read and insert only HN92 Read, insert, update and delete __________________________________________________________________ 8. Create a synonym named ANOTHER_ITEM on the table ITEMCOPY. __________________________________________________________________ 9. Insert the following record into the Franchise table:Franchise No MF999Franchise Name Mature Fashions (Shetlands)Franchise Address 1, Lonely Spot, LerwickFranchise Postcode 2E1 1AAFranchise Tel 01595 1245Franchise Fax 01595 2356Franchise Start Date 22nd January 2002 __________________________________________________________________ 10.Update the above record