Database MCQ - English
- Introduction to Database
- The Relational Model and Normalization
- Data Modeling with ER Model
- SQL for Database Construction
- Managing Multiuser Databases
- SQL Server 2000
- XML and ADO.NET
- Database Processing for BIS
- The Database Development Process
- ER Model and Business Rules
- Physical Database Design
- The Client Server Database
- Data Warehousing
- Distributed Databases
- Object Oriented Database
- Introduction to SQL
- Database Design Using Normalization
- Data Models into Database Designs
- Database Redesign
- Managing Databases with Oracle
- ODBC, OLE DB, ADO, and ASP
- JDBC, Java Server Pages, and MySQL
- The Database Environment
- Modeling Data in the Organization
- Logical Database Design
- Advanced SQL
- The Internet Database Environment
- Data and Database Administration
- Object Oriented Data Modeling
The Database Environment MCQ Questions and Answers
Home | Database | The Database EnvironmentIn this section we provide lots of objective question of The Database Environment in Database Management System.
1) A data warehouse uses:
partial operational data.
historical operational data.
future operational data.
health care data.
Answer : B Discuss
2) Metadata enables database designers and users to do all of the following except:
sample data.
understand what data exist.
what the fine distinctions are between similar data items.
what the data mean.
Answer : A Discuss
3) Duplicate data often results in loss of data integrity because:
the data formats may be inconsistent.
data values may not agree.
Both A & B.
Neither A & B.
Answer : C Discuss
4) Legacy data is which of the following?
Data contained in a newly-installed system
Data rejected during the installation of a new system
Data contained in a file system
Data contained by a system used prior to the installation of a new system
Answer : D Discuss
5) A database management system (DBMS) is a:
hardware system used to create, maintain, and provide controlled access to a database.
hardware system used to create, maintain, and provide uncontrolled access to a database.
software system used to create, maintain, and provide controlled access to a database.
software system used to create, maintain, and provide uncontrolled access to a database.
Answer : C Discuss
6) A database application can perform which of the following activities?
7) An enterprise data model is:
a graphical model that shows the high-level entities for an organization.
a graphical model that shows all entities for an organization.
a non-graphical model that shows the high-level entities for an organization.
a non-graphical model that shows the all entities for an organization.
Answer : A Discuss
8) A shared database should:
be accurate and available.
provide for backup and recovery.
be secure.
All of the above.
Answer : D Discuss
9) Data administrators are responsible for:
physical database design.
managing technical issues in the database environment.
overall management of data resources in an organization.
writing application programs.
Answer : C Discuss
10) Which of the following types of databases are the most common?