Number data type formats in BASE.

Q15. Discuss the various Number data type formats available in BASE.

Ans. Numeric data types are further categorized into two types, namely, Whole-Number data type and Fractional data type.

Table 1 describes four Whole-Number data types:

 

Table 1: Whole- Number data types
Data Type Description
Tiny Integer [TINYINT] Allows you to store data with s fixed length of three (3) spaces. In other words, you can store data of three-digit numbers.
Small Integer [SMALLINT] Allows you to store data with s fixed length of five (5) spaces. In other words, you can store data of five-digit numbers.
Integer [INT] Allows you to store data with s fixed length of ten (10) spaces. It includes the auto value feature, which helps you enter a previously set value automatically.
Big Integer [BIGINT] Allows you to store data with s fixed length of nineteen (19) spaces. Similar to the Integer [INT] data type, this data type also has the auto value feature.

Read More …

Entry Required field property.

Q13. What do you understand by the Entry Required field property? Explain with a suitable example.

Ans. The Entry required specifies whether the entry of data in the selected field is mandatory or not. For example, in case you set the value as Yes in the field property of a selected field, it means that you must enter data in the field. On the other hand, if the value is set as No, then you need not enter any data in the field. Read More …

Field properties in Base.

Q10. What do you understand by field properties in Base? Explain the various types of field properties available in Base.

Ans. In a database, field properties play an important role in controlling the behavior of a field. In BASE, you can assign the following types of field properties:

  • Entry Required: Specifies whether the entry of data in the selected field is mandatory or not. For example, in case you set the value as Yes in the field property of a selected field, it means that you must enter data in the field. On the other hand, if the value is set as No, then you need not enter any data in the field. In other words, you can skip this field. Read More …

Define field length in database.

Q6. Define field length with the help of an example.

Ans. Field length helps you specify the size of the field in a table. For example, if you specify 2 as the field length for a numeric field, it means that the field can store values from 1 to 99, which is the maximum value that can be written in two digits.

Explain fields in a table of database.

Q4. Explain fields in a table with the help of a suitable example.

Ans. A field is a column that contains similar type of data. For example, there is a database named Student and it has a table named Student_Details. In the Student_Details table, the St_Name, St_RollNo, St_ContactNo, and St_Address are the names of the fields.

difference between Text (fix) [CHAR] and Text [VARCHAR].

Q3. What is the difference between Text (fix) [CHAR] and Text [VARCHAR]?

Ans. The differences between the Text (fix) [CHAR] and Text [VARCHAR] data types are as follows:

 

Text (fix) [CHAR]

Text [VARCHAR]

Represents a text data type of fixed length. Represents a text data type of variable length.
If the data that you enter is less than the length specified, then the field is completed by trailing spaces. If the data that you enter is less than the length specified then the field is not completed by trailing spaces.

 

 

 

How can you move a field in a table in Base?

Q2. How can you move a field in a table in Base?

Ans. Generally, moving a field means changing its position in a table.

To move a field, you have to first cut the field from its location in the table by using the Cut command and then paste the field in the desired location by using the Paste command. In BASE, when you move a field, it appears as the last field of the table.

Data validation and How can you use data validation in BASE.

Q1. What do you understand by data validation? How can you use data validation in BASE?

Ans. In a database, data validation refers to a process of ensuring that only valid data is entered in a table. You can ensure data validation by setting the field properties of your tables such that only valid data can be entered by the users. For example, if you set the Yes value for the Entry required property, it will ensure that users enter some value in this field during data entry. However, if you specify No as a value for this field, then the user can skip this field.