Microsoft Visual FoxPro MCQ

Microsoft Visual FoxPro MCQ (VFP) is a data-centric, procedural, and object-oriented programming language that was developed by Microsoft. It was primarily used for developing desktop database applications. Visual FoxPro was widely known for its robust database management capabilities, its powerful query language (SQL), and its ability to create data-driven applications.

Microsoft Visual FoxPro MCQ (Multiple Choice Question) in the context of Visual FoxPro would typically refer to a question designed to test knowledge about Visual FoxPro concepts, its syntax, features, or functionality. MCQs can be part of an exam or quiz for students or professionals learning or using Visual FoxPro.

Here’s an example of what a Microsoft Visual FoxPro MCQ might look like:

Sample Visual FoxPro MCQ

Question: What is the default data type for a new variable in Visual FoxPro?

a) Integer
b) Character
c) String
d) Float

Answer:
b) Character

Another Example:

Question:
Which of the following is used to create a new database in Visual FoxPro?

a) CREATE DATABASE
b) CREATE TABLE
c) OPEN DATABASE
d) NEW DATABASE

Answer:
a) CREATE DATABASE

Topics that may be covered in Visual FoxPro MCQs:

1. Data types: Understanding different data types such as Numeric, Character, Date, and Memo.
2. Commands: Knowledge of commands like USE, SELECT, APPEND, INSERT, DELETE, etc.
3. Functions: Understanding built-in functions like LEN(), UPPER(), LOWER(), etc.
4. Database management: Creating and managing tables and indexes.
5. Procedural programming: Using loops, conditional statements, and error handling.
6. Object-Oriented Programming (OOP): Concepts like classes, objects, methods, and properties in VFP.
7. SQL commands: Working with SQL queries, joins, and filters in Visual FoxPro.

These MCQs would typically be included in assessments related to database management, application development, or programming concepts specific to Visual FoxPro.

4o mini

[EVERY QUESTION HAS 4 OPTIONS & 1 ANSWER IS RED COLOR]

Question 1
How many type of sort commands in visual foxpro?
a) 1
b) 5
c) 2
d) 4

Question 2
In Visual Foxpro, there are _ relational Operator
a) 1
b) 2
c) 3
d) 6

Question 3
How many data types in visual foxpor?
a) 12
b) 11
c) 10
d) 13

Question 4
Maximum width of character data type in Visual Foxpor 6.0
a) 253
b) 250
c) 254
d) 252

Question 5
To Display the System Time on Screen, the Command is ?
a) Time ()
b) Time ()
c) Time ?
d) ?Time

Question 6
Which of the Date type field is
a) 6 Characters
b) 10 Characters
c) 7 Characters
d) 8 Characters

Question 7
Which command is used to print a report file named EMPLOYEE on the screen
a) FORMAT REPORT EMPL OYEE
b) DO REPORT EMPL OYEE
c) REPORT FORMAT EMPL OYEE
d) None of These

Question 8
Extension of a lable file in FoxPor
a) .xcs
b) .qpr
c) .css
d) .idx

Question 9
Extension of database file in FoxPor
a) .dbc
b) .dba
c) .dbf
d) .idx

Question 10
Extension of form file in Foxpro
a) .scx
b) .frm
c) .cdx
d) .mnx

Question 11
In visual foxpor extension file name of project file
a) .pjx
b) .pro
c) .prj
d) .prg

Question 12
To return the name of the month, we can use?
a) MONTH(DATE())?
b) CMONTH(DATE())?
c) CDATE(DATE())?
d) CDAY(DATE())

Question 13
To return a date in full such as 25 Decembar 2011?
a) Dmy()
b) ?cdmy(date())
c) ?cdmy()
d) ?dmy(date())

Question 14
To return the numder of fields in a table, function used
a) Fcount()
b) ?fieldcount()
c) ?countfield()
d) ?fcount()

Question 15
To return the leftmost characters of text function used?
a) Left(,)
b) ?left(,>no.of characters>)
c) Left(,)
d) ?left()

Question 16
To return the minute portion from a Time
a) ?minute(time())
b) ?minute()
c) ?min(datetime())
d) ?minute(detetime())

Question 17
To display the current record number,
a) Finction is rec()
b) ?recordnumber()
c) ?rec()
d) ?recno()

Question 18
To display whether the current record of a filed is in upper case,function is
a) Isupper()
b) ?uppercase()
c) ?isupper()
d) ?upper()

Question 19
In Visual FoxPor, there are _ logical Operator
a) 4
b) 3
c) 1
d) All are incorrect

Question 20
Change the Date format to British type
a) SET DATE BRITISH
b) DATE FORMAT BRITISH
c) SET BRITISH
d) All of the Above

Question 21
FOR’ command helps us to
a) To see the record which are temporarily deleted form table
b) Add the last record to the database table
c) To provide Condition with command
d) All of the Above

Question 22
For Sort the data we use
a) Sort
b) Index and sort
c) Index
d) All of the Above

Question 23
To insert a blank recorda) Append
b) Insert affter
c) Insert Blank
d) Append Blank

Question 24
In a database fileds are stored in
a) Rows
b) Columns
c) Table
d) Both

Question 25
To edit a specific record
a) Edit record
b) Edit record
c) Modify record
d) Both 1 and 2

Question 26
modify Structure Command modifies
a) Records
b) Fileds
c) Database
d) Both 1 and 3

Question 27
“Append “ command adds record in the middle of the database table.
a) True
b) FALSE
c) Both of above
d) Both b and c

Question 28
Default date format in visual foxpro
a) ANSI
b) American
c) Swish
d) British

Question 29
To exit from foxpor, use the command
a) CLS
b) EXIT
c) QUIT
d) CLOSE

Question 30
Create command creates
a) Table
b) Index
c) Row
d) Column

Question 31
Which command is used after locate commannd in finding a record?
a) Go on
b) Recall
c) None
d) Continue

Question 32
Create A New Database With The Same Structure
a) Copy Structure To FileName
b) Create database to filename
c) Copy database to filename
d) Copy filename to filename

Question 33
What is the hot key to save and exit?
a) CTRL+W
b) CTRL+A
c) CTRL+B
d) CTRL+L

Question 34
Shortcut key to open command window in visual foxpor
a) Ctrl+F2
b) F11
c) F10
d) Ctrl+F1

Question 35
Shortcut key to save a table in visual foxpor
a) Ctrl+w
b) Ctrl+y
c) Ctrl+a
d) Ctrl+x

Question 36
To delete a record in browse mode
a) CTRL+T
b) CTRL+D
c) CTRL+Y
d) CTRL+X

Question 37
DBF’ stands for
a) Digit Base File
b) Digit Base File
c) Data British File
d) Database Flie

Question 38
V FoxPor: What is meaning of DBF?
a) Database
b) Database File
c) Details better format
d) Delete below files

Question 39
In FoxPor, default date format is
a) MM-YY-DD
b) YY/DD/MM
c) MM/DD/YY
d) DD/MM/YY

Question 40
To display names, number of records, size in bytes, and date of last update for all databases
a) Dir
b) Dir *.*
c) Dir *.?
d) Dir ?.*

Question 41
Which is noe Visual FoxPor Type?
a) Date
b) Character
c) Date Time
d) Dollar

Question 42
To return the curent day of the week of as a number with Sunday counting as Day
a) ?dow(date())
b) Dow(date())
c) ?dow()
d) Dow()

Question 43
To return the name of the day of the week of
a) ?cdow(date())
b) Cdow(date())
c) ?cdow()
d) Dow()

Question 44
Closing a Database refers to which command?
a) QUT
b) CLOSE FILE
c) CLOSE DATABASE
d) EXIT

Question 45
To see only those Students who got marks more than 80, the Command will be-
a) LIST FORMARKS> 80
b) LIST MARKS> 80
c) LIST MARKS FOR> 80
d) FOR LIST MARKS >80

Question 46
VfoxPro: Arrange the Name field Records in descending order using
a) INDEX ON NAME
b) INDEX FIELD NAME
c) INDEX ON NAME TAG DESC
d) INDEX ON NAME TAG

Question 47
Which is not a valid date format?
a) American Format
b) British Format
c) Italian Format
d) Indian Format

Question 48
To return the length of text including spaces
a) ?lenght (text)
b) Len()
c) ?len(text)
d) Len(text

Question 49
To display whether the current record eagged for deletion or not in true or false
a) Daleted()
b) List for deleteed
c) ?deleted()
d) List delete

Question 50
To display on the screen all of the information about all of the records tagged for deletion.
a) List deletion.
b) Show delete
c) ?deleted()
d) List for deleted()

Question 51
To return the maximum value from the list.
a) ?max(,,)
b) ?maximum(,,)
c) ?highest(,,)
d) Max(,,)

Question 52
Which function Returns the specified number of characters from the end of a string?
a) RIGHT()
b) LEFT()
c) TRIM()
d) MID()

Question 53
To return the system month as a number between 1 and 12
a) ?month(date())
b) ?month()
c) Month()
d) Month(date())

Question 54
Table structure modification can be done with the help of which command
a) Edit
b) Modify
c) Append
d) Modify Structure

Question 55
Command used to tag the current record for deletion
a) Delete
b) Deleted
c) Deletecurrent
d) None

Question 56
‘EDIT’ and ‘BROWSE’ command are functionally same.
a) True
b) False
c) Both A and B
d) None

Question 57
How to display ststus bar in Visual Foxpro?
a) Set status on
b) Set status start
c) Set status
d) None

Question 58
To changes the default Visual FoxPor directory to the directory you specify
a) Set default to
b) Set path to
c) Change path to
d) None

Question 59
To display the number of record in the database.
a) ?countrec()
b) ?Reccount()
c) ?recordcoun
d) None

Question 60
To display the records in read in read only format
a) Browes readonly
b) Bowes noedit
c) Noedit
d) None

Question 61
To display whether the first character of text is alphabetic in True of False?
a) Isalpha(“text”)
b) Alpha(text)
c) Isalpha (text)
d) None

Question 62
To return the hour portion from a Time?
a) Hour(datetime())
b) ?hour()
c) ?hour(time)
d) None

Question 63
To return the integer equal or greater then number
a) ?CEILING ()
b) ?Floor()
c) ?abs()
d) None

Question 64
To return the position of character in string, function used
a) ?AT(,)
b) OCCURS(, )
c) SUBSTR(,,)
d) NONE

Question 65
To show the all record without record number, the command will be
a) List
b) List on
c) List off
d) None

Question 66
To show the all table in a database file, the command
a) DIR*.DBC
b) DIR*.DBF
c) DIR*.*
d) None

Question 67
To show the path of current dbf file, one should used
a) ?dbf()
b) ?dbc()
c) ?dfb()
d) None

Question 68
Which command is used to modify or update a record in a table?
a) Modify
b) Replace
c) Update
d) None

Question 69
In Foxpro predict the output of following function: cell(-5.2)
a) -5
b) -6
c) Incorrect function use
d) None of the above

Question 70
Predict the output of following function: at(“a”,”Kolkata”,2)
a) 2
b) 0
c) 5
d) None of the above

Question 71
To create a table in FoxPor we use
a) Create<Table Name>
b) Open<Table Name>
c) Append
d) None of the above

Question 72
To display the table structure, one can use:
a) MODI STRU
b) DISPLAY STRU
c) SHOW STRU
d) None of the above

Question 73
To open a particular database
a) Use Dbname
b) Run Dbname
c) Open Dbname
d) None oc the above

Question 74
__ Command is used to delete the(*) marked records.
a) Pack
b) Delete
c) Zap
d) None of These

Question 75
American Date Format is
a) MM/DD/YY
b) DD/MM /YY
c) YY/DD/MM
d) None of These

Question 76
CTOD stands for____________
a) Character for Digi
b) Character to date
c) Character of Date
d) None of These

Question 77
Data type available in Visual FoxPor are
a) 13 types
b) 5 types
c) 10 types
d) None of These

Question 78
Databases store information in the form of
a) Forms
b) Reports
c) Tables
d) None of These

Question 79
Extension of a Report file
a) .Fra
b) .FRX
c) .DBF
d) None of These

Question 80
FoxPro is a Kind of
a) Database Application
b) Graphics application
c) Spreadsheet Application
d) None of These

Question 81
If you insert a record to a Sorted database file, it wii be positioned logically
a) TRUE
b) FALSE
c) Both
d) None of these

Question 82
INDEX’ file extencion is__________
a) .IDX
b) .DOC
c) .LBX
d) None of These

Question 83
Maximum number of fileds in a table can be
a) 260
b) 255
c) 250
d) None of These

Question 84
Maximum widht of Numeric type of field is 20 excluding decimal.
a) TRUE
b) FALSE
c) Both
d) None of these

Question 85
RDBMS stands for_____________
a) Rural Divisional Basic Management system
b) Relational Database Management System
c) Regional Database Management System
d) None of these

Question 86
Size of a Index file is greater than a sorted database file
a) True
b) False
c) Both
d) None of these

Question 87
‘Sorting’ order relates to which of the following?
a) Uppercase and Propercase
b) Uppercase and Lowercase
c) Ascecding and descending
d) None of These

Question 88
To display all the records excluding record numder – clause is used with LIST command.
a) ALL
b) OFF
c) For
d) None of These

Question 89
To display only deleted record which command is used
a) LIST FOR DELETED()
b) LIST FOR DELE
c) LIST ALL
d) None of These

Question 90
To see the listing of the output come in a different Window the command
a) Modify Structure
b) Browse
c) List Off
d) None of These

Question 91
To see the Total of Basic Flied, the Command is
a) Replace
b) Sum(Basic)
c) Avg Basic
d) None of These

Question 92
User can modify a Report file
a) TRUE
b) FALSE
c) Both
d) None of these

Question 93
‘LIST’ Command shows
a) All the records at a time
b) Display only 2nd and the record without record number
c) Only specific record
d) Only 2nd record

Question 94
‘CHARACTER’ type contains__________
a) Only Numeric valuesc.
b) Only Decimal Values
c) Both Character and Numeric Values
d) Only Characer values

Question 95
USE FIL ENAME is the command of
a) File Creation
b) Close Database
c) Delete Database
d) Open Database

Question 96
To permanently removes all records tagged for deletion.
a) Zap
b) Delete all
c) Pack
d) Pack all

Question 97
To get back all deleted record
a) Recall
b) Disp Deleted
c) Recall All
d) Recall Deleted

Question 98
To Clears data from the specified fileds in the current record, command used in visual foxpor is
a) Empty
b) Clear
c) Blank
d) Remove

Question 99
To show report
a) Format
b) Disp Report
c) From Report
d) Report Format

Question 100
To return the seconds portion from a Time
a) ?sec(time())
b) ?sec(datetime())
c) ?second(time())
d) Second(datetime())

Question 101
Command used to copy data from a Visual FoxPro table to a file in a different format.
a) Export to filename[type]
b) Add to filename[type]
c) Both option1 and 2
d) Send to filename[type]

Question 102
To display the clock on screen command is
a) SET STATUS OFF
b) STATUS OFF
c) STSTUS OMN
d) SET STATUS ONM

Question 103
The display the clock on screen command is
a) Set clock on
b) Set clock stert
c) Clock on
d) Set time on

Question 104
The ‘DISPLAY’ command shows
a) Single record
b) Multiple records
c) Multiple tables
d) Single table

Question 105
To sort any filed of any table of foxproa)
Sort on Fieldname to Newtable name
b) Sort to table Name New Name
c) Sort on New name Field Name
d) Sort to Fieldname on Tablename

Question 106
The ‘MODIFY STRUCTURE’ command opens the
a) FoxPro
b) Report Designer
c) Form Designer
d) Table Designer

Question 107
We get command Window from __ Menu.
a) Edit
b) Format
c) Window
d) Tools

Question 108
To return the text in upper case
a) ?upper()
b) Upper()
c) ?uppercase()
d) Uppercase()

Question 109
Extension of a Database table file is_________
a) .DBC
b) .DBF
c) .FDP
d) Wk4

Question 110
What is the ANTI date format in Visual Foxpro?
a) MM/DD/YYYY
b) YY/MM/DD
c) YYYY.MM.DD
d) YY.MM.DD