数据库基础教程课后选择题翻译+答案（国外英文资料）.docVIP

数据库基础教程课后选择题翻译+答案（国外英文资料） Chapter 9 model objects (1) which is the command to delete the constraint? C A. a LTER TABLE MODIFY CONSTRAINT B.D ROP CONSTRAINT C. a LTER TABLE DROP CONSTRAINT D.A LTER CONSTRAINT DROP (2) which is not the part of ROWID? a. A. table space b. file number c. object number d. block number (3) what is the difference between the unique value constraint and the primary key constraint? D A. the only value constraint establishes A unique index, which is not the only index The main code column can be null, the only value constraint column should not be empty C. Master code constraints can always create indexes using existing indexes and unique value constraints The only value constraint column can be empty, the main code column should not be empty (4) what is a pattern? B The physical organization of the database object The logical organization of the database object C. index model D. None of the above (5) what columns are appropriate for a bitmap index? B A. the index base is high b. the index base is low c. the insertion rate is high (6) select two schema objects that can be owned by the PUBLIC user group. AC A. there is A link between the two The (7) ALTER TABLE command cannot be used for B A. move A table to other table Spaces B. modify the initial partition size of the table C. modify the name of the table Disable triggers (8) which constraints do not automatically index? B A. master b. C (9) which is not the way to set up a partitioned table? C A. range b. list c. function d. hash Chapter 10 safety management (1) create the location of the DEFAULT TABLESPACE clause in the user command. a. The database object created by the user B. the temporary object created by the user The system object created by the user D. None of the above (2) what does SESSIONS_PER_USER limit in the resource file? B The number of concurrent sessions of the database The number of sessions per user The number of processes per user D. None of the above (3) which paramete