DBMS MCQ Question and Answer

DBMS MCQ Question and Answer
461. Auto form allows you to
  • View a subset of your data
  • Create a data simple report
  • Create a data entry form
  • Enter records
Show Answer
462. The asterisk (*) is sometimes used in database queries. This character is then called a

  • Wildcard
  • Dummy
  • Ditto
  • All of above
Show Answer
463. When performing a look-up operation using a form
  • You enter the search value into the form
  • You look at each form sequentially until you see the one you want
  • you type thekey in an entry line, and the correctform is displayed
  • All of above
Show Answer
464. Which custom date format displays the numeric day of the year when a data is entered ?
  • YY
  • YYYY
  • Y
  • All of above
Show Answer
465. When you save an Access project, what file format do you use ?
  • .adp
  • .xm
  • .mdp
  • All of above
Show Answer
466. Which of the followig criterion would find records whose personality field dies not equql "Nice" ?
  • <>Nice
  • NOT Nice
  • <>"Nice"
  • IS NOT Nice
Show Answer
467. What is the following fields would not make a suitable primary key ?
  • A data field
  • An invoice number
  • An auto Number field
  • A customer's social security number
Show Answer
468. Auto reports can contain each of the following elements except
  • A detail section
  • A page footer
  • A group header
  • All of the above
Show Answer
469. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database ?
  • DASD
  • FMS
  • EMMS
  • DBMS
Show Answer
470. A repository for data, usually covering some specific topic is called
  • Data acquisition
  • Data bank
  • Real time
  • Database
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test