• 2022-06-06
    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.
  • B,D

    内容

    • 0

      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

    • 1

      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

    • 2

      "To turn the tables" means ______. A: to move the tables B: to carry the tables away C: to gain courage D: to gain an advantage after having been at a disadvantage

    • 3

      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: index­organized tables (IOTs)

    • 4

      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: Dindex­organized tables (IOTs)