While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which type of tables would you use to achieve these objectives？（）
A: Aheap tables
B: Bobject tables
C: Cpartitioned tables
D: Dindexorganized tables （IOTs）
A: Aheap tables
B: Bobject tables
C: Cpartitioned tables
D: Dindexorganized tables （IOTs）
举一反三
- While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which type of tables would you use to achieve these objectives？（） A: heap tables B: object tables C: partitioned tables D: indexorganized tables （IOTs）
- Which describes the default behavior when you create a table? () A. The table is accessible to all users. B. Tables are created in the public schema. C. Tables are created in your schema. D. Tables are created in the DBA schema. E. You must specify the schema when the table is created.
- The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）. A: user tables B: view segment C: table segment D: data dictionary E: object segment F: performance tables
- The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）. A: user tables B: view segment C: table segment D: data dictionary E: object segment F: performance table
- To make effective tables, you should _________. A: arrange data of the shorter string into columns B: use complete sentences as the table titles C: use only three horizontal rules for the table D: line up numbers on the left