What is foxpro, with their commands 10+ short notes

What is FoxPro?

Ans: – Fox-pro is a Database Management System(DBMS) Package which is developed by Fox Studio(Fox Software Corporation)in 1992. It is used to maintain the Database. Fox-pro supports both types of Database DBMS & R-DBMS, it also supports multiple relationships between multiple Database File (DBF). What is FoxPro?


The function of FoxPro:-
  • It is used to insert data into databases.
  • It is used to Append the Data into the Database.
  • It is used to Delete the data from Database.
  • It is used to search the data from the database file.
  • It is used to Update data of the Database.

Q:-What is Data?
:- Data can be anything like the name of the Palace, person, Roll no. of college students or name of a country.

Q:-What is Information?
:-When Data is in a meaning full way and related with each other it’s called Information in FoxPro.

Q:- What is Database?
:- Database is an Integrated collection of Interrelated Data. or It is a collection of Files/Data.

What is the full form of the DBMS

Q:- What is DBMS?
:- DBMS stands for Database Management System. The System which collects data from user and manages that data properly is called Database Management system.
:-DataBase Management are two types:-

[A.] Manual:- Record is maintained by using Paper & Pen.
[B.] Computerized:- The Record are Maintain with help of Machine.

What is the full form of the RDBMS

Q:-What is RDBMS?
:- RDBMS stands for Relational Database Management System.

  • It is an advance feature of DBMS.
  • It provides the facility to create a relation between two tables.
Q:- What is FILE?

:- In Fox-pro File is a collection of records and fields. In Fox-pro Row represent records and columns represent the field.

There are two types of file:-

A. Master File:- It is also called the main file. In this file, all Primary Data should be stored in the Master File.

B. Transaction File:- The Transaction file is Dependent on the Master file, The Daily Business transaction should be stored in a transaction file.


Q:- What is RECORD ?:-
:-Data is stored in one horizontal line of the database is called a record. and other words Record is a collection of values in fields of the table.

Q:- What is the FIELD?
:- Field is a basic part of any database Column is also called field but in a perfect way Field is a collection of data of the same type and nature.

Q:-What is Col. Width?
:-The number of digit which we specify properly with each field-name is called column width.

Ex:- DBMS software:-
:-There are three types of DBMS software:-

Ex:- RDBMS software:-
There are Four types of RDBMS software:-
3.MySQL server
4.MS Access (Microsoft)

The extension of foxpro programming file is

Q:- What is the Extension of FoxPro?

  • ‘.txt.’
  • ‘.dbf’
  • ‘.prg’
  • ‘.scr’
  • ‘.frx’

Type of Database:-
1. Homogeneous database
2. Heterogeneous database

Nature of Database:-
1. Local database
2. Remote database
3. Distributed database

Command Window:- The main purpose of command window Is to execute the command entered by user.

Foxpro commands

Q:-How to set Path in FoxPro?
:-To set path:- set default to C:\ SOME

Set default to:- It is use to set the path of
directory name where database
will stored.
Note:- FoxPro can read only four character and FoxPro is not Case Sensitive Like C.

DataType in FoxPro:- Datatype is used to define the Attribute of a field (Data).There are six types of DataType in what is FoxPro.

A. Numeric:- It is used to hold Numeric type Value. Eg. 15,10

B. Character:- It is used to hold Character type Value. Eg. A,B,A2,B3

C. Float:- It is used to hold Floating value. Eg. 1.23, 4.5, 0.6

D. Logical:-It is used to hold True or False value. Eg. >, <, >=, =

E. Date:- It is used to hold the Date value.Eg. mm-dd-yy

F. Memo:- It is used to hold Large character data.


“There is a Basic function of Using or Understanding what is  FoxPro “


What is foxpro, with their commands 10+ short notes

what is Foxpro

Course Provider: Organization

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

T H E S M O L T Learn For Free Download Our Android App in Free DOWNLOAD