if you want to remove an article from website contact us from top.

    list numeric and alphanumeric datatypes in openoffice base.

    Mohammed

    Guys, does anyone know the answer?

    get list numeric and alphanumeric datatypes in openoffice base. from screen.

    Base/Data Types

    Base/Data Types

    < Base

    This article should be checked for accuracy and conformity to style.

    Contents

     [hide]

    1 Variable Types for Embedded Base Database

    1.1 Numeric Types

    1.2 Alphanumeric Types

    1.3 Binary Types 1.4 Date time

    1.5 Other Variable types

    Variable Types for Embedded Base Database

    Numeric Types

    NameData typeNo. of BytesSignedRange

    BOOLEAN boolean 1 no 0 or 1 TINYINT integer 1 no 0 to 255 SMALLINT integer 2 yes -215 to 215-1 INTEGER integer 4 yes -231 to 231-1 BIGINT integer 8 yes -263 to 263-1 NUMERIC number no limit yes

    (Max Scale, Max Precision )

    Max Scale = unlimited

    Max Precision = e(+/-)231

    DECIMAL decimal no limit yes

    (Max Scale, Max Precision )

    Max Scale = unlimited

    Max Precision = e(+/-)231

    REAL real 4 yes

    2-1074 to (2-2-52)* 21023

    FLOAT float 4 yes

    2-1074 to (2-2-52)* 21023

    DOUBLE double 4 yes

    2-1074 to (2-2-52)* 21023

    2-1074 to (2-2-52)* 21023 could also be stated as 5e-324 to 1.7976931348623157e+308

    Alphanumeric Types

    NameData typeMax length Description

    LONGVARCHAR text

    2GB for 32 bit OS Stores up to the max number of characters indicated by user. It accepts any UTF 8 character.

    CHAR text(fix)

    2GB for 32 bit OS Stores exactly the number of characters specified by user. Pads with trailing spaces for shorter strings. Accepts any UTF 8 character.

    VARCHAR text

    2GB for 32 bit OS Stores up to the specified number of characters. No padding (Same as long var char).

    VARCHAR_IGNORECASE text

    2GB for 32 bit OS Stores up to the specified number of characters. Comparisons are not case-sensitive, but stores capitals as you type them.

    Binary Types

    NameData typeMax lengthDescription

    LONGVARBINARY image

    2GB for 32 bit OS Stores any array of bytes (images, sounds, etc). No validation required.

    BINARY binary (fix)

    2GB for 32 bit OS Stores any array of bytes. No validation required.

    VARBINARY binary

    2GB for 32 bit OS Stores any array of bytes. No validation required.

    Date time

    Name Description Format

    Date Stores month, day and year information 1/1/99 to 1/1/9999

    Time Stores hour, minute and second info Seconds since 1/1/1970

    Timestamp Stores date and time information

    Other Variable types

    NameDescription

    Other Stores serialized Java objects. User application must supply serialization routines.

    Object Same

    Categories: NeedsRework ENENDatabaseBase Documentation

    स्रोत : wiki.openoffice.org

    List Numeric Datatypes in OpenOffice Base.

    List Numeric Datatypes in OpenOffice Base.

    List Numeric Datatypes in OpenOffice Base.

    ← Prev Question Next Question →

    1 Answer

    ← Prev Question Next Question →

    Find MCQs & Mock Test

    Free JEE Main Mock Test

    Free NEET Mock Test

    Class 12 Chapterwise MCQ Test

    Class 11 Chapterwise Practice Test

    Class 10 Chapterwise MCQ Test

    Class 9 Chapterwise MCQ Test

    Class 8 Chapterwise MCQ Test

    Class 7 Chapterwise MCQ Test

    Related questions

    स्रोत : www.sarthaks.com

    Class 10 Info Tech Unit 3 RDBMS Session 2

    100 + Question Answer and mcq on Session 2 Create and Edit Tables using Wizard and SQL Commands Unit 3 RDBMS DBMS class 10 info tech 402

    Class 10 Info Tech Unit 3 RDBMS Session 2 – Create And Edit Tables Using Wizard & SQL Commands 50+ Question Answer

    / Class 10 Info. Tech. [402], Class 10 RDBMS / By mycstutorial / December 31, 2021

    Session 2 – Create and Edit Tables using Wizard & SQL Commands

    16. Write steps to create a Table using Table Wizard.Answer: Steps for creating a table using Table Wizard are –

    (a) Click on Tables > Use Wizard to Create Table.

    (b) Click the Select Fields > Choose Category > Select the table > Click on Next Button.

    (c) Select the fields as per the requirements, Click on Next Button,

    (d) Once the fields will be selected the window to set the data types will open, (the default type is VARCHAR for all), click on the Next button,

    (e) Select the Primary Key, click Next,

    (f) Rename table window appears, either rename or proceed with the same name,

    (g) Click on Finish to Insert the data.

    17. Write steps to create a Table using Design View.Answer: Steps for creating a table using Design view are –

    (a) Under the Tasks > Click on Table > Click on Table in Design View, a table design window appears.

    (b) Specify the field name and data type of the field to be created by selecting the appropriate type available under the Field type dropdown list.

    (c) After specifying the field name and data type for the field, Save the table by clicking File > Save

    (d) Specify the Table name, The default name is Table1, Click Ok.

    (e) Set the Primary key (Optional).

    The table is created successfully, now you can insert the record.

    18. What is Data type?Answer: Datatypes are used to identify which type of data (value) we are going to store in the database. Fields themselves can be of different types depending on the data they contain.19. In how many categories and data types are classified in OpenOffice.org Base? Write their name.Answer: In OpenOffice.org Base, Datatypes are broadly categorized into 5 (five) categories. These are –

    (i) Numeric Types,

    (ii) Alphanumeric Types,

    (iii) Binary Types, (iv) Data time, and

    (v) Other Variable types.

    20. What are Numeric data types?Answer: Numeric data types are used for describing numeric values for the field used in the table of a database.

    Numeric data types in a database can be used for storing information such as mobile number, roll number, door number, year of school admission, true or false statements, statistical values, etc.

    21. List Data types available in Numeric data types?Answer: The different types of numeric data types available are –

    Numeric Data Types in OpenOffice.org Base, Source: NCERT Book

    22. What are Alphanumeric data types?Answer: Alphanumeric data type is used to store characters and numbers both. It cannot be used for calculations.23. List Data types available in Alphanumeric data types?Answer: The different types of Alphanumeric data types available are –

    Alphanumeric Data Types in OpenOffice.org Base, Source: NCERT Book

    24. What are Binary data types?Answer: Binary data types are used for storing data in binary formats. Binary data types in a database can be used for storing photos, music files, etc25. List Data types available in Binary data types?Answer: The different types of Binary data types available are –

    Binary Data Types in OpenOffice.org Base, Source: NCERT Book

    26. What are Date Time data types?Answer: Date time data types are used for describing date and time values for the field used in the table of a database.

    Date time data types in a database can be used for storing information such as date of birth, date of admission, date of product sale, etc.

    27. List Data types available in Date Time data types?Answer: The different types of Date Time data types available are –

    DATE TIME Data Types in OpenOffice.org Base, Source: NCERT Book

    28. List Data types available in Other data types?Answer: The different types of Other data types available are –

    Other Data Types in OpenOffice.org Base, Source: NCERT Book

    29. How to insert records in the table in OpenOffice.org Base?Answer: To insert records (values) into the table, just double-click the table name. It will open the Table Data view dialog box. It looks like an excel sheet, in this you can insert the records/values.30. How to save the data in the table in OpenOffice.org Base?Answer: Select File > Save Current Record, to save data in the table.

    स्रोत : mycstutorial.in

    Do you want to see answer or more ?
    Mohammed 10 day ago
    4

    Guys, does anyone know the answer?

    Click For Answer