IT 204 Milestone Four - Running head IT 204 MILESTONE FOUR 1 IT 204 Milestone Four Christian Gregory Carson Southern New Hampshire University Assigned

IT 204 Milestone Four - Running head IT 204 MILESTONE FOUR...

This preview shows page 1 - 4 out of 7 pages.

Running head: IT 204 MILESTONE FOUR 1IT 204 Milestone FourChristian Gregory CarsonSouthern New Hampshire UniversityAssigned DBMS: Oracle
Background image
IT 204 MILESTONE FOUR 2Data Size LimitsVarious data type limits include:BFILE – 4GB (This is a data type used to store a link to a file stored outside of the database. The maximum size is up to 4GB, although this is operating system specific).BLOB – 4GB – 1 (A binary large object is a data type that can hold up to 4GB of data. This is useful for storing digitized information like images, video, and audio).CLOB – 4GB – 1 (A character large object is a data type that can hold up to 4 GB of data,and is useful for storing text. The number of LOB columns per table is only limited by the maximum number of columns per table, which is 1000).CHAR – 2000 bytes (CHAR is a data type which is used to store fixed-length character data).Literal – 4000 characters (A literal can be a number, character, or string).NCHAR – 2000 bytes per row, or 2000 characters (NCHAR is a fixed length data type which can be used to store national language support or multibyte character set data).Number - +/-(38 9’s) x10^125Precision – 38 significant digitsVARCHAR2 – 4000 bytes (VARCHAR2 is a data type used to store variable-length character data).VARCHAR – 4000 bytes (Same as VARCHAR2, however this should not be used as it is reserved for future usage).A lot of the physical database item limits are based upon operating system. If you would like to increase those limits, it is recommended to license another processor. Some of these limits thatare dependent on operating systems include:Database Block SizeControlfilesDatabase filesDatabase file sizeRedo log file sizeExternal tables file
Background image
IT 204 MILESTONE FOUR 3Different logical database limits include:Indexes – Maximum per table (Unlimited), total size of indexed column (75% of the database block size minus some overhead).Columns – Per table (1000 columns), per index (32 columns), per bitmapped index (30 columns).Constraints – Maximum per column (unlimited)Rows – Maximum number per table (unlimited)Users and Roles – 2,147,483,638Tables – Maximum per clustered table (32 tables), maximum per database (unlimited).
Background image
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture