Cs6400-Exam1 Questions With Answers

CS6400-Exam1 QUESTIONS WITH |\ |\ |\




ANSWERS

DBMS (Database Management System) - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\


✔✔is a computerized system that enables users to create and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


maintain a database |\ |\




Meta Data - CORRECT ANSWERS ✔✔The database definition or
|\ |\ |\ |\ |\ |\ |\ |\ |\


descriptive information is also stored by the DBMS in the form of
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


a database catalog or dictionary
|\ |\ |\ |\




transaction - CORRECT ANSWERS ✔✔an executing program or
|\ |\ |\ |\ |\ |\ |\ |\


process that includes one or more database accesses, such as
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


reading or updating of database records
|\ |\ |\ |\ |\




requirements specification and analysis - CORRECT ANSWERS |\ |\ |\ |\ |\ |\ |\


✔✔The first phase in the design of the new application for an
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


existing database or design of a brand-new database
|\ |\ |\ |\ |\ |\ |\




Conceptual Design - CORRECT ANSWERS ✔✔Overview of the|\ |\ |\ |\ |\ |\ |\ |\


system, does not include hardware or software choices
|\ |\ |\ |\ |\ |\ |\




Logical Design - CORRECT ANSWERS ✔✔A stage in the design
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


phase that matches the conceptual design to the requirements of
|\ |\ |\ |\ |\ |\ |\ |\ |\


the selected DBMS and is therefore software-dependent. It is
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


used to translate the conceptual design into the internal model
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


for a selected database management system.
|\ |\ |\ |\ |\

,Physical Design - CORRECT ANSWERS ✔✔translates the logical
|\ |\ |\ |\ |\ |\ |\ |\


design into physical components. The database design is
|\ |\ |\ |\ |\ |\ |\ |\


implemented, populated with actual data, and continuously
|\ |\ |\ |\ |\ |\ |\


maintained to reflect the state of the miniworld.
|\ |\ |\ |\ |\ |\ |\




self-describing data - CORRECT ANSWERS ✔✔includes the data |\ |\ |\ |\ |\ |\ |\ |\


item names and data values together in one structure
|\ |\ |\ |\ |\ |\ |\ |\




Data Modeling - CORRECT ANSWERS ✔✔Defining a database so
|\ |\ |\ |\ |\ |\ |\ |\ |\


that it faithfully represents all key components of an
|\ |\ |\ |\ |\ |\ |\ |\ |\


organization's environment. The objective is to explicitly capture
|\ |\ |\ |\ |\ |\ |\ |\


and store data about every business activity the organization
|\ |\ |\ |\ |\ |\ |\ |\ |\


wishes to plan, control, or evaluate.
|\ |\ |\ |\ |\




operation - CORRECT ANSWERS ✔✔(also called a function or
|\ |\ |\ |\ |\ |\ |\ |\ |\


method)
-The interface (or signature)
|\ |\ |\ |\




-The implementation
|\




program-operation independence - CORRECT ANSWERS ✔✔User |\ |\ |\ |\ |\ |\


application programs can operate on the data by invoking these
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


operations through their names and arguments, regardless of
|\ |\ |\ |\ |\ |\ |\ |\


how the operations are implemented
|\ |\ |\ |\




Data Abstraction - CORRECT ANSWERS ✔✔allows program-data
|\ |\ |\ |\ |\ |\ |\


independence and program-operation independence |\ |\ |\

, view - CORRECT ANSWERS ✔✔subset of the database or it may
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


contain virtual data that is derived from the database files but is
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


not explicitly stored.
|\ |\




Concurrency Control - CORRECT ANSWERS ✔✔A method of |\ |\ |\ |\ |\ |\ |\ |\


dealing with a situation in which two or more users or
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


applications need to access the same record at the same time.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\




OLTP (online transaction processing) - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\


✔✔Database design used for browsing and manipulating business|\ |\ |\ |\ |\ |\ |\


transaction activity
|\ |\




Isolation - CORRECT ANSWERS ✔✔ensures that each transaction
|\ |\ |\ |\ |\ |\ |\ |\


appears to execute in isolation from other transactions, even
|\ |\ |\ |\ |\ |\ |\ |\ |\


though hundreds of transactions may be executing concurrently
|\ |\ |\ |\ |\ |\ |\




atomicity - CORRECT ANSWERS ✔✔ensures that either all the
|\ |\ |\ |\ |\ |\ |\ |\ |\


database operations in a transaction are executed or none are
|\ |\ |\ |\ |\ |\ |\ |\ |\




Database Administrator (DBA) - CORRECT ANSWERS ✔✔the
|\ |\ |\ |\ |\ |\ |\


person responsible for coordinating, controlling, and managing
|\ |\ |\ |\ |\ |\ |\


the database
|\




Database designers - CORRECT ANSWERS ✔✔are responsible for
|\ |\ |\ |\ |\ |\ |\ |\


identifying the data to be stored in the database and for choosing
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


appropriate structures to represent and store this data
|\ |\ |\ |\ |\ |\ |\ |\