Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    21

    Thumbs up Unanswered: How to calculate minimum size required for container

    someone ask me this question :
    Given the following SQL statements:

    CREATE TABLESPACE TS1

    MANAGED BY DATABASE USING (FILE 'TS1_CONT' <container size>)

    EXTENTSIZE 10

    CREATE TABLE T1 (C1 INT, C2 BLOB(1K)) IN TS1 1026 BYES

    CREATE TABLE T2 (C1 INT, C2 CHAR(250)) IN TS1 2002 BYTE

    Which of the following is the minimum size required for container TS1_CONT that will allow both of the tables to be successfully created?

    A.50 pages
    B.60 pages
    C.120 pages
    D.240 pages

    the answer is :C
    but ,who can tell me why?
    and How to calculate minimum size required for container .

    Many thanks for any suggestion.
    Ray

  2. #2
    Join Date
    Feb 2004
    Posts
    21
    um,nobody?!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •