CE 4347 Exam 1 Review
To allow users to manipulate the information, the system has a number of Application programs Application files Manipulation program Manipulation files
Application programs
Data Manipulation Language (DML) is not to Insertion of new information into the Database Modification of information in the Database Create information table in the Database Deletion of information in the Database
Create information table in the Database
Which of the following is not a level of data abstraction? View Level Physical Level Logical Level Critical Level
Critical Level
A ......... is used to define the overall design of the database schema application program data definition language code
schema
A logical structure of the database. Schema Attribute Parameter Instance
Schema
A data model is a graphical system used to capture the nature and relationships among data. True False
True
A(n) ____ model is independent of both hardware and software. conceptual external developmental Physical
conceptual
A Database System is: Collection of data describing one particular enterprise Collection of programs to access data Collection of interrelated data All of the above
All of the above
Data Manipulation Language enables users to Retrieval of information stored in database Insertion of new information into the database Deletion of information from the database All of the above
All of the above
File processing systems have important limitations Data is separated and isolated Data is often duplicated Application programs are dependent on file format All of the above None of the above
All of the above
The property / properties of a database is / are : It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records. Data stored in a database is independent of the application programs using it All of the above
All of the above
Which of the following is Database Language? Data Definition Language Data Manipulation Language Data Query Language All of the above
All of the above
A characteristic of an entity. Relation Attribute Parameter Constraint
Attribute
Data independence means Data is defined separately and not included in programs Programs are not dependent on the physical attributes of data. Programs are not dependent on the logical attributes of data Both (B) and (C)
Both (B) and (C)
DBMS helps achieve Data independence Centralized control of data Neither A nor B Both A and B
Both A and B
Database processing programs: Call the DBMS to access the stored data Cannot be used in more than one process Require at least one dedicated workstation Present problems with storage space
Call the DBMS to access the stored data
The restrictions placed on the data. Relation Attribute Parameter Constraint
Constraint
They design and implement the DBMS modules and interfaces as a software package Real-time and active database technology Data warehouses and online analytical processing (0LAP) DBMS system designers and implementors System protection
DBMS system designers and implementors
A type of data abstraction that is used to provide a conceptual representation Big data Data model Transaction Casual end users
Data model
Snapshot of the data in the database at a given instant of time is called Database Instance All of the options Database Schema Database Snapshot
Database Instance
Logical design of database is called All of the options Database Schema Database Instance Database Snapshot
Database Schema
_____ are considered database architects. Database administrators Systems administrators Database designers Systems analysts and programmers
Database designers
DBMS manages the interaction between __________ and database. System Analysts Compilers End Users Stake Holders
End Users
With the traditional fi le processing approach, each application shares data files, thus enabling much data sharing. True False
False
Data redundancy and Data Inconsistency are one of the major drawbacks of File processing system File retrieval system File storage system File updating system
File processing system
Can store and analyze maps, weather data, and satellite images. Program - data Independence Geographic information systems (G I S) Operation interface Operators and maintenance personnel
Geographic information systems (G I S)
Which of the following is not involved in DBMS? End Users Data Application Request HTML
HTML
The actual content in the database at a particular point. Schema Attribute Parameter Instance
Instance
Which of the following in not a function of DBA? Network Maintenance Schema Definition Authorization for data access Routine Maintenance
Network Maintenance
Which of the following is a navigational data model model? Network Model Object oriented model E-R Model None of these
Network Model
DBMS is a set of __________ to access the data. Codes Programs Information Metadata
Programs
It is better to use files than a DBMS when there are Stringent real-time requirements Multiple users wish to access the data Complex relationships among data All of the above
Stringent real-time requirements
____ command can be used to modify a column in a table. alter update set create
alter
A ____ focuses primarily on storing data used to generate information required to make tactical or strategic decisions. distributed database workgroup database data warehouse production database
data warehouse
A level that describes data stored in a database and the relationships among the data. physical logical user view
logical
A level that describes how a record is stored. physical logical user view
physical
Data ____ exists when the same data are stored unnecessarily at different places. dependency redundancy inconsistency fragmentation
redundancy
The hierarchical database model is based on a ____. tree structure lack of a parent segment lack of a child segment matrix
tree structure
Which of the following isn't a level of abstraction? physical logical user view
user
The ______level helps application programs hide the details of data types. physical logical user view
view
