DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q401
The term refers to a collection of related information
  • A Database
  • B List
  • C Outline
  • D Record
Answer: Option C
Q402
A form that is used to collect data in a structured manner for entry to a database is called a
  • A Database deign form
  • B Systems flowchart
  • C Data capture form
  • D None of above
Answer: Option C
Q403
The folowing command is used for inserting records
  • A INSERT
  • B ADD
  • C Both of the above
  • D None of the above
Answer: Option A
Q404
The Query is a statement requesting for
  • A Insertion of Information
  • B Deletion of Information
  • C Updata of information
  • D Retrieval of Information
Answer: Option D
Q405
The activity of a file
  • A Is a low percentage of number of records added or deleted from a file
  • B If high, reduces processing efficiency for sequential and non sequential files
  • C Is a measure of the percentage of existing records updated during a run
  • D Refers to how closely the files fit into the allocated
Answer: Option A
Q406
The following statement is not valid about indexing
  • A It stores the index fields
  • B It stores the corresponding record number
  • C It maintains the alphabetically order
  • D it duplicate the database file
Answer: Option D
Q407
The following devices can be used to input data into a database
  • A Keyboard, fax roller ball
  • B Mouse, keyboard, monitor
  • C Mouse, keyboard, touch screen
  • D None of the above
Answer: Option C
Q408
The following command is used for sorting
  • A List
  • B Browse
  • C Index
  • D Sort
Answer: Option C
Q409
List command is used to get
  • A List of database contents
  • B List of database contents
  • C List of variables used in database file
  • D None of the abvoe
Answer: Option A
Q410
A field that uniquely identifies a record is called a
  • A Main field
  • B Header
  • C Key field
  • D None of above
Answer: Option C
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test