Two identical records can be stored in one table of database.
举一反三
- Two hexadecimal digits can be stored in one byte.
- If you make a change to the information recorded in a particular block, what will happen? ( ) A: You will rewrite it. B: The change will be stored in a new block. C: A database will be updated. D: The administrator can change the database.
- If one record in Table A matches multiple records in Table B, and one record in Table B matches only one record in Table A, the relationship between Table A and Table B is (). A: One-to-one B: One-to-many C: Many-to-one D: Many-to-many
- You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）
- You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： A: The table is partitioned B: The table name is wrong. C: It is an index-Organized table （IOT） D: The table is stored in locally managedtablespace. E: The table is stored in atablespacewhere segment space is managed manually.