• 2022-06-19
    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.
  • E

    内容

    • 0

      While you are eating, keep________ A: the elbows on the table B: one elbow on the table C: the elbows off the table D: the elbows under the table

    • 1

      Never bang your chopsticks like drumsticks. Why? A: Tells others at the table you're incompetent. B: Tells others at the table you disrepect their children. C: Tells others at the table you're impotent. D: Tell others at the table you're beggar.

    • 2

      You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;() A: AYou get an error because of a primary key violation. B: BThe data and structure of the EMPLOYEES table are deleted. C: CThe data in the EMPLOYEES table is deleted but not the structure. D: DYou get an error because the statement is not syntactically correct.

    • 3

      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

    • 4

      2. In what ways will the table manners help you? The table manners will help you _________________ with your American friends.