View MCQ Question

(Q) How many types of commands in Visual FoxPro -

  1. 1
  2. 5
  3. 2
  4. 4

Ans : 2

(Q) How many data types in Visual FoxPro -

  1. 12
  2. 11
  3. 10
  4. 13

Ans : 13

(Q) Maximum width of character data type in Visual FoxPro 6.0 -

  1. 253
  2. 250
  3. 254
  4. 252

Ans : 254

(Q) Width of date type field is -

  1. 6 Characters
  2. 10 Characters
  3. 7 Characters
  4. 8 Characters

Ans : 8 Characters

(Q) Extension of a label file in FoxPro -

  1. .xcs
  2. .qpr
  3. .lbx
  4. .css

Ans : .lbx

(Q) Extension of database file in FoxPro -

  1. .dbc
  2. .dba
  3. .dbf
  4. .idx

Ans : .dbc

(Q) Extension of form file in FoxPro

  1. .scx
  2. .frm
  3. .cdx
  4. .mnx

Ans : .scx

(Q) To return the name of the month, we can use?

  1. MONTH(DATE())?
  2. CMONTH(DATE())?
  3. CDATE(DATE())?
  4. CDAY(DATE())?

Ans : CMONTH(DATE())?

(Q) To display the current record number,

  1. finction in rec()
  2. ?recordnumber()
  3. ?rec()
  4. ?recno()

Ans : ?recno()

(Q) For command helps us to

  1. to see the record which are temporarily deleted from table
  2. at the last record to the database table
  3. to provide condition with command
  4. all of the above

Ans : to provide condition with command

(Q) For sort the data we use

  1. sort
  2. index and sort
  3. index
  4. all of the above

Ans : all of the above

(Q) To insert a blank record

  1. Append
  2. Insert after
  3. Insert blank
  4. Append blank

Ans : Append blank

(Q) In a database fields are stored in

  1. Rows
  2. Columns
  3. Table
  4. Both

Ans : Columns

(Q) Modify Structure command modifies

  1. records
  2. fields
  3. database
  4. both 1 and 3

Ans : fields

(Q) Append command at record in the middle of the database table.

  1. True
  2. False
  3. both of above
  4. both B and C

Ans : False

(Q) Default date format in Visual FoxPro

  1. ANSI
  2. America
  3. Swish
  4. British

Ans : America

(Q) To exit from FoxPro, use the command

  1. CLS
  2. EXIT
  3. QUIT
  4. CLOSE

Ans : QUIT

(Q) Create command creates

  1. Table
  2. Index
  3. Row
  4. Column

Ans : Table

(Q) Which command is used after locate command in finding a record?

  1. Go on
  2. recall
  3. Nano
  4. continue

Ans : continue

(Q) What is the hot key to save and exit?

  1. Ctrl + W
  2. Ctrl + A
  3. Ctrl + B
  4. Ctrl + L

Ans : Ctrl + W

(Q) Shortcut key to save a table in Visual FoxPro

  1. ctrl + w
  2. ctrl + Y
  3. ctrl + a
  4. ctrl + x

Ans : ctrl + w

(Q) To delete a record in browse mode

  1. CTRL + T
  2. CTRL + D
  3. CTRL + Y
  4. CTRL + X

Ans : CTRL + T

(Q) DBF stands for

  1. Digit Base File
  2. Digit Base File
  3. Data British File
  4. Database File

Ans : Database File

(Q) In FoxPro, default date format is

  1. mm-yy-dd
  2. yy/dd/mm
  3. mm/dd/yy
  4. dd/mm/yy

Ans : mm/dd/yy

(Q) VFoxPro: what is meaning of DBF?

  1. Database
  2. Database file
  3. Details better format
  4. Delete below files

Ans : Database file

(Q) To display names, number of records, size in bytes and date of last update for all databases

  1. dir
  2. dir *,*
  3. dir *.?
  4. dir ?.*

Ans : dir

(Q) Which is not Visual FoxPro type?

  1. Date
  2. Character
  3. Date time
  4. Dollar

Ans : Dollar

(Q) Closing a database refers to which command?

  1. Quit
  2. CLOSE FILE
  3. CLOSE DATABASE
  4. EXIT

Ans : CLOSE DATABASE

(Q) Table structure modification can be done with the help of which command?

  1. Edit
  2. Modify
  3. Append
  4. Modify structure

Ans : Modify structure

(Q) Command used to tag the current record for deletion

  1. delete
  2. deleted
  3. delete current
  4. None

Ans : delete

(Q) To show the all record without record number the command will be

  1. list
  2. list on
  3. list off
  4. none

Ans : list off

(Q) To open a particular database

  1. Use Dbname
  2. Run Dbname
  3. Open Dbname
  4. None of the above

Ans : Use Dbname

(Q) _________ command is used to delete the (*) marked records.

  1. Pack
  2. Delete
  3. Zap
  4. None of these

Ans : Pack

(Q) American date format is

  1. MM/DD/YY
  2. DD/MM/YY
  3. yy-DD-mm
  4. None of these

Ans : MM/DD/YY

(Q) CTOD stands for

  1. Character for digit
  2. Character to date
  3. Character of date
  4. None of these

Ans : Character to date

(Q) Data types available in Visual FoxPro are

  1. 13 types
  2. 5 types
  3. 10 types
  4. None of these

Ans : 13 types

(Q) Databases store information in the form of

  1. Forms
  2. Reports
  3. Tables
  4. None of these

Ans : Tables

(Q) Extension of a report file

  1. .Fra
  2. .FRX
  3. .DBF
  4. None of these

Ans : .FRX

(Q) FoxPro is a kind of

  1. Database application
  2. Graphics application
  3. Spreadsheet application
  4. None of these

Ans : Database application

(Q) INDEX file extension is

  1. .IDX
  2. .DOC
  3. .LBX
  4. None of these

Ans : .IDX

(Q) Maximum number of fields in a table can be

  1. 260
  2. 255
  3. 250
  4. None of these

Ans : 255

(Q) RDBMS stands for

  1. Rural divisional basic management system
  2. Relational database management system
  3. Regional database management system
  4. None of these

Ans : Relational database management system

(Q) Shorting order relates to which of the following?

  1. Uppercase and Propercase
  2. Uppercase and Lowercase
  3. Ascending and Descending
  4. None of these

Ans : Ascending and Descending

(Q) To see the listing of the output come in a different window the command

  1. Modify structure
  2. Browse
  3. List off
  4. None of these

Ans : Browse

(Q) LIST command shows

  1. All the records at a time
  2. Display only 2nd and the record without record number
  3. Only specific record
  4. Only 2nd record

Ans : All the records at a time

(Q) CHARACTER type contains

  1. Only numeric values
  2. Only decimal values
  3. Both character and numeric values
  4. Only character values

Ans : Both character and numeric values

(Q) USE FILENAME is the command of

  1. File creation
  2. Close database
  3. Delete database
  4. Open database

Ans : Open database

(Q) To permanently remove all records tagged for deletion

  1. zap
  2. deleted all
  3. pack
  4. pack call

Ans : pack

(Q) To get back all deleted record

  1. Recall
  2. Disp Deleted
  3. Recall All
  4. Recall Deleted

Ans : Recall All

(Q) To clears data from the specified fields in the current record command used in Visual FoxPro is

  1. empty
  2. clear
  3. blank
  4. remove

Ans : blank

(Q) To display the clock on screen command is

  1. set clock on
  2. multiple records
  3. multiple tables
  4. single table

Ans : set clock on

(Q) To sort any field of any table of FoxPro-

  1. Sort On Fieldname To Newtable Name
  2. Sort To Table Name New Name
  3. Sort On New Name Field Name
  4. Sort To Fieldname On Tablename

Ans : Sort On Fieldname To Newtable Name

(Q) The MODIFY STRUCTURE command opens the-

  1. FoxPro
  2. Report Designer
  3. Form designer
  4. Table designer

Ans : Table designer

(Q) Extension of a database table file is-

  1. .DBC
  2. .DBF
  3. .FDP
  4. Wk4

Ans : .DBF

(Q) Change the Date format to British type

  1. Set Date British
  2. Date Format British
  3. Set British
  4. All Of The Above

Ans : Set Date British

(Q) The 'DISPLAY' command shows

  1. single record
  2. multiple records
  3. multiple tables
  4. single table

Ans : single record