DBMS-DBMS CONCEPT Questions and Answers

Practice Mode
Showing 10 of 45 questions
Q31
Which of the following is characterstic of the data in a database?
  • A independent
  • B Secure
  • C shared
  • D all of these.
Answer: Option D
Q32
The name of the system database that contains descriptions of data in the database is
  • A data dictionary
  • B metadata
  • C table
  • D none of these
Answer: Option B
Q33
Following is the type of metadata:
  • A operational
  • B EDW
  • C data mart
  • D all of these
Answer: Option D
Q34
System catalog is a system-created database that describes:
  • A database objects
  • B data dictionary information
  • C user access information
  • D all of these
Answer: Option D
Q35
A file is a collection of related sequence of records:
  • A related records
  • B related fields
  • C related data items
  • D none of these
Answer: Option A
Q36
Relationships could be of the fillowing type:
  • A one-to-one relationship
  • B one-to-many relationships
  • C many-to-many relationships
  • D all of these.
Answer: Option D
Q37
In a file-oriented system there is:
  • A data inconsistency
  • B duplication of data
  • C data dependence
  • D all of these.
Answer: Option D
Q38
In a database system there is:
  • A increased productivity
  • B improved security
  • C economy of scale
  • D all of these
Answer: Option D
Q39
In a database system there is:
  • A Large size of DBMS
  • B increased overall costs
  • C increased complexity
  • D all of these .
Answer: Option D
Q40
IDS formed the basis for the:
  • A network model
  • B hierachical model
  • C relational model
  • D all of these
Answer: Option A
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test