DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q391
Pivot Table reports are good for
  • A Analyzing large amounts of data
  • B turning tables upside down
  • C Breaking spreadsheet data into multiple worksheet
  • D None of above
Answer: Option A
Q392
Which of the following are common ways to enforce data validation when entering data into an access Form ?
  • A Creative an input mask to restrict the kind of value that can be entered in positions across the field.
  • B Define a validation rule for that field
  • C A and B
  • D None of the above
Answer: Option C
Q393
The purpose of the Add-in Manager is to
  • A Create macros and automata data processing
  • B Add or remove data in an existing database
  • C Add or remove templates, macros, and wizards
  • D All of above.
Answer: Option C
Q394
Sub-schema can be used to
  • A Creative very different, personalized views of the same data
  • B Present information in different formats
  • C Hide sensitive information by omitting fields from the subschema's description
  • D All of the above
Answer: Option D
Q395
If you are entering data in a form, a quick way to copy a value rom the previous record is to press
  • A CTRL +'
  • B F6
  • C Ctrl + D
  • D None of the above
Answer: Option A
Q396
DBMS is
  • A Collection of data
  • B Set of programs to access those data
  • C Set of programs to update those data
  • D All of the above
Answer: Option D
Q397
COPY STRUCTURE command is used to
  • A Copy contents of an active database to a new ffile
  • B Copy all records of an active database to disk
  • C Copy contents of an active database to disk
  • D Copy structure of an active database to a new file
Answer: Option D
Q398
COUNT command is used to
  • A Count the number of data fields in an active database file
  • B Count the number of data files which are active
  • C Count the records which are updated
  • D Count the number of records in an active database file
Answer: Option D
Q399
What is the term to ask the computer to pt information in order numerically or alphabetically ?
  • A Crop
  • B Report
  • C Sort
  • D Organize
Answer: Option C
Q400
The raw facts are called
  • A Data
  • B Programs
  • C Commands
  • D Responses
Answer: Option A
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test