The Database Environment - General Questions Online Exam Quiz
The Database Environment - General Questions GK Quiz. Question and Answers related to The Database Environment - General Questions. MCQ (Multiple Choice Questions with answers about The Database Environment - General Questions
A data warehouse uses:
Options
A : partial operational data.
B : historical operational data.
C : future operational data.
D : health care data.
Metadata enables database designers and users to do all of the following except:
Options
A : sample data.
B : understand what data exist.
C : what the fine distinctions are between similar data items.
D : what the data mean.
Duplicate data often results in loss of data integrity because:
Options
A : the data formats may be inconsistent.
B : data values may not agree.
C : Both A & B.
D : Neither A & B.
Legacy data is which of the following?
Options
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
A database management system (DBMS) is a:
Options
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.
A database application can perform which of the following activities?
Options
A : Add records
B : Read records
C : Update records
D : All of the above.
An enterprise data model is:
Options
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.
A shared database should:
Options
A : be accurate and available.
B : provide for backup and recovery.
C : be secure.
D : All of the above.
Data administrators are responsible for:
Options
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.
Which of the following types of databases are the most common?
Options
A : Personal
B : Workgroup
C : Department
D : Enterprise
Advanced SQL - General Questions more Online Exam Quiz
ODBC, OLE DB, ADO, and ASP - General Questions
Physical Database Design - General Questions
SQL for Database Construction - General Questions
The Client-Server Database - General Questions
The Database Development Process - General Questions
ER Model and Business Rules - General Questions
The Internet Database Environment - General Questions
The Relational Model and Normalization - General Questions