The Database Environment Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q1
A data warehouse uses:
  • A partial operational data.
  • B historical operational data.
  • C future operational data.
  • D health care data.
Answer: Option B
Q2
Metadata enables database designers and users to do all of the following except:
  • A sample data.
  • B understand what data exist.
  • C what the fine distinctions are between similar data items.
  • D what the data mean.
Answer: Option A
Q3
Duplicate data often results in loss of data integrity because:
  • A the data formats may be inconsistent.
  • B data values may not agree.
  • C Both A & B.
  • D Neither A & B.
Answer: Option C
Q4
Legacy data is which of the following?
  • A Data contained in a newly-installed system
  • B Data rejected during the installation of a new system
  • C Data contained in a file system
  • D Data contained by a system used prior to the installation of a new system
Answer: Option D
Q5
A database management system (DBMS) is a:
  • A hardware system used to create, maintain, and provide controlled access to a database.
  • B hardware system used to create, maintain, and provide uncontrolled access to a database.
  • C software system used to create, maintain, and provide controlled access to a database.
  • D software system used to create, maintain, and provide uncontrolled access to a database.
Answer: Option C
Q6
 A database application can perform which of the following activities?
  • A Add records
  • B Read records
  • C Update records
  • D All of the above.
Answer: Option D
Q7
An enterprise data model is:
  • A a graphical model that shows the high-level entities for an organization.
  • B a graphical model that shows all entities for an organization.
  • C a non-graphical model that shows the high-level entities for an organization.
  • D a non-graphical model that shows the all entities for an organization.
Answer: Option A
Q8
A shared database should:
  • A be accurate and available.
  • B provide for backup and recovery.
  • C be secure.
  • D All of the above.
Answer: Option D
Q9
Data administrators are responsible for:
  • A physical database design.
  • B managing technical issues in the database environment.
  • C overall management of data resources in an organization.
  • D writing application programs.
Answer: Option C
Q10
Which of the following types of databases are the most common?
  • A Personal
  • B Workgroup
  • C Department
  • D Enterprise
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test