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 table
- Which statement is true regarding synonyms?（） A: Synonyms can be created only for a table B: Synonyms are used to reference only those tables that are owned by another user C: A public synonym and a private synonym can exist with the same name for the same table D: The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
- 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 two are true regarding external tables？ （） A: AExternal tables can be updated. B: BExternal tables are read-only tables. C: CIndexes can be created on external tables. D: DIndexes cannot be created on external tables.
- 在创建数据库模式时,下列对象需要严格按依赖关系的顺序排列进行创建,中间不可交换的有() A: schema、table、view B: table、view、index C: schema、table、index D: view、table、schema E: schema、table、trigger F: table、view、trigger