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
A: user tables
B: view segment
C: table segment
D: data dictionary
E: object segment
F: performance table
举一反三
- 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
- 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.
- 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)
- From an operations perspective, market segmentation is important because A: Order qualifiers may differ by customer segment B: Both order winners and qualifiers may differ by customer segment C: Market segmentation is not relevant to operations D: Order winners may differ by customer segment
- 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.