oracle教程第二版部分習題參考答案解析

文字性習題答案參見相應章節(jié)內(nèi)容第1章習題1DACC第2章習題1執(zhí)行edit命令打開文本編輯器；使用column命令設置列顯示寬度習題2CONNscott/tiger@orclSELECT*FROMtab;--本題嚴謹一些的答案是查詢ALL_OBJECTS視圖，帶條件查詢習題3@d:\init_data\init_data.sql習題4SETPAGESIZE24SETLINESIZE100COLUMNsalFORMAT$99,990.00第3章習題1DB習題2CONNstu01/stu01pwd@orclCOLUMNUSERNAMEFORMATA10SELECTusername,granted_roleFROMuser_role_privs;習題5CREATESESSION系統(tǒng)權限習題11CONNscott/tiger@orclCOLUMNGRANTEEFORMATA10SELECTgrantee,table_name,grantor,privilege,grantableFROMuser_tab_privs_made;習題12CONNsystem/systempwd@orclCOLUMNGRANTEEFORMATA22SELECTgrantee,privilege,admin_optionFROMdba_sys_privsORDERBYgrantee,privilege;SELECTgrantee,granted_roleFROMdba_role_privs;使用REVOKE命令回收不必要的系統(tǒng)權限和角色。\第4章習題8CONN/@cemerpASSYSDBAALTERUSERscottQUOTA10MONUSERS;習題9CONNsystem/systempwd@orclCREATETABLESPACEdata_ts1DATAFILE'%ORACLE_BASE%\oradata\orcl\data_ts1.dbf'SIZE10000MREUSE;CREATETEMPORARYTABLESPACEtemp_ts1TEMPFILE'%ORACLE_BASE%\oradata\orcl\temp_ts1.dbf'SIZE200MREUSE;CREATEUSERsurtecIDENTIFIEDBYsurtecpwdDEFAULTTABLESPACEdata_ts1TEMPORARYTABLESPACEtemp_ts1;GRANTCREATESESSIONTOsurtec;GRANTRESOURCETOsurtec;CONNsurtec/surtecpwd@orcl--創(chuàng)建該用戶的表emp……--授權給SIBGRANTSELECTONempTOsib;GRANTUPDATE(flag)ONendowment_insuranceTOsib;習題10CONNsystem/systempwd@orclCREATEUSERtest01IDENTIFIEDBYtest1234;GRANTCREATESESSIONTOtest01;GRANTCREATETABLESPACETOtest01;CONNtest01/test1234@orclCREATETABLESPACEtest_tsDATAFILE'%ORACLE_BASE%\oradata\orcl\test_ts.dbf'SIZE100KAUTOEXTENDONNEXT50KMAXSIZE5MUNIFORMSIZE50K;ALTERTABLESPACEtest_tsADDDATAFILE'%ORACLE_BASE%\oradata\orcl\test_ts2.dbf'SIZE10M;ALTERDATABASEDATAFILE'%ORACLE_BASE%\oradata\orcl\test_ts2.dbf'RESIZE15M;習題11CONNsystem/systempwd@orclALTERTABLESPACEpur_tsADDDATAFILE'%ORACLE_BASE%\oradata\orcl\pur_data.dbf'SIZE800M;ALTERDATABASEDATAFILE'%ORACLE_BASE%\oradata\orcl\pur_data.dbf'RESIZE2000M;ALTERDATABASEDATAFILE'%ORACLE_BASE%\oradata\orcl\pur_data.dbf'AUTOEXTENDONNEXT30M;第5章習題1BA習題8(1)撤銷表空間中不允許建立永久方案對象；將方案對象建立在數(shù)據(jù)表空間即可。(2)在脫機表空間上不允許執(zhí)行創(chuàng)建方案對象操作；將該表空間聯(lián)機即可。(3)使用ALTERUSER修改用戶在USERS表空間上的限額即可。(4)使用ALTERUSER修改用戶，擴大在USERS表空間上的限額即可。習題9CONNhr/hrpwd@orclCREATETABLEemployees2ASSELECTemployee_idid,first_name,last_name,sa