DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q441
How do youfreeze a field a column or fieldl in Microsoft Access ?
  • A Click anywhere in the column and select Edit>Freeze Column form the menu
  • B Place an ice cobe in the column
  • C Click anywhere in the column and click the freeze button on the toolbar
  • D Right click the column and select freeze columns from the shortcut menu
Answer: Option D
Q442
Within table Datasheet view, how can you display associated records from another table ?
  • A Click the expand indicator (+) next to a record
  • B Double click the record
  • C Apply the filter by form command
  • D None of the above
Answer: Option A
Q443
which of the following is not a command to fimd specific word or pharases in a database ?
  • A Click the find button on the toolbar
  • B Click the find button on the record navigation button area
  • C Press Ctrl + F
  • D Select Edit>Find from the menu
Answer: Option B
Q444
One of the type libraties that you can use to programmatically connect to Microsoft access data is
  • A Collaborative Data objects
  • B Active X Data objects
  • C Dynamic Data Interfaces
  • D None of the above
Answer: Option B
Q445
The data in a Pivot Table report is categorized using
  • A Column headings
  • B Items from the Pivot Table field list
  • C Header rows
  • D All of above
Answer: Option B
Q446
Records are deleted usig
  • A DELETE command followed by pack
  • B DELETE command without pack
  • C DELETE command followed by zap
  • D DELETE command without zap
Answer: Option A
Q447
You can enter data in a table in
  • A design view
  • B datasheet view
  • C format view
  • D None of the above
Answer: Option C
Q448
Creating a data file means
  • A Designing base and defining the structure of the database
  • B Getting the information about database
  • C Selecting data from database
  • D Deleting data from database
Answer: Option A
Q449
In a large DBMS
  • A each user can "see" only a smal part of the entire database
  • B each user can access every subschema
  • C each subschema contains every field in the logical schema
  • D None of the above is true
Answer: Option A
Q450
You wantto keep track of addresses, phone numbers, jparent/guardian names as well every so often you want to send reports home that select failing grades and excessive absences. The following of the Microsoft Office suit used in this course is best suited for this kind of information
  • A excel
  • B Power Point
  • C Access
  • D Word
Answer: Option C
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test