oracle教程第二版部分习题参考答案解析

文字性习题答案参见相应章节内容第1章习题1DACC第2章习题1执行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系统权限习题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命令回收不必要的系统权限和角色。\第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--创建该用户的表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)撤销表空间中不允许建立永久方案对象；将方案对象建立在数据表空间即可。(2)在脱机表空间上不允许执行创建方案对象操作；将该表空间联机即可。(3)使用ALTERUSER修改用户在USERS表空间上的限额即可。(4)使用ALTERUSER修改用户，扩大在USERS表空间上的限额即可。习题9CONNhr/hrpwd@orclCREATETABLEemployees2ASSELECTemployee_idid,first_name,last_name,sa