Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CE 165 : DATABASE MANAGEMENT SYSTEM > CHAPTER 1 (Long Exam) > Flashcards

CHAPTER 1 (Long Exam) Flashcards

1
Q

A function of DBMS that involves specifying the data types, structures, and constraints for the data to be stored in the database.

A

Define

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The characteristic that allows program-data independence.

A

Database Abstraction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The primary source in a database environment.

A

database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Responsible for acquiring software and hardware resources as needed?

A

Database Administrators

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

It is a collection of programs that enables users to create an maintain a database.

A

Database Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Responsible for choosing appropriate structures to represent and store this data.

A

Database Designer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

These are standard types pf queries and updates.

A

Canned Transactions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

They determine the requirements of end users, especially naive and parametric end users, and develop specifications for canned transactions that meet these requirements.

A

System Analysts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Persons who design and implement the DBMS modules and interfaces as a software package.

A

System Designers and Implementer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The process of storing the data itself on some storage medium that is controlled by the DBMS.

A

Construct

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Responsible for administering the primary and secondary resources in a database environment.

A

Database Administrators

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

The interface for casual users.

A

Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

The system administration personnel who are responsible for the actual running and maintenance of the hardware and software environment for the database system.

A

Operators and Maintenance Personnel

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

It is a collection of related data.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Include engineers, scientists, business analysts, and others who thoroughly familiarize themselves with the facilities of the DBMS so as to implement their applications to meet their complex requirements.

A

Sophisticated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Those who work to maintain the database system environment, but who are not actively interested in the database itself.

A

Workers behind the Scene

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The interface for application programmers.

A

Programming Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Any known facts that can be recorded and which have implicit meaning

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

They maintain personal databases by using ready-made program packages that provide easy to use menu or graphics-based interfaces.

A

Stand Alone End Users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

The secondary resource in a database environment.

A

DBMS and Related Softwares

21
Q

Includes such functions as querying the database to retrieve specific data, updating the database to reflect changes in the mini world, and generating reports from the data.

A

Manipulate

22
Q

Those people whose jobs involve the day to day use of a large database.

A

Actors on the Scene

23
Q

This refers to the property wherein the structure of data files is stored in the DBMS catalog separately from the access programs.

A

Isolation (*)

24
Q

The interface for parametric users.

A

Forms

25
Q

This will ensure that several users trying to update the same data do so in a controlled manner so that the result of the updates is correct.

A

Concurrency control

26
Q

The people whose jobs requires access to the database for querying, updating, and generating reports.

A

End-Users

27
Q

Their main job function revolves around constantly querying and updating the database using canned transactions.

A

Naive/Parametric

28
Q

Include persons who design and implement tools

A

Tool Designers

29
Q

The interface for stand-alone users.

A

Menu Driven Interface

30
Q

Accountable for the problem such as breach of security, or poor system response time.

A

Database Administrators

31
Q

The software packages that facilitate database system design and use and help improve performance.

A

Tools

32
Q

They implement the specifications as programs; then they test, debug, document, and maintain these canned transactions

A

Application Programmers

33
Q

They occasionally access the database, but they may need different information each time.

A

Casual End-Users

34
Q

Responsible for Identifying the data to be stored in the database.

A

Database Designer

35
Q

A feature of databases systems dictating that it must happen in its entirety or not at all.

A

Atomicity

36
Q

A DBMS should provide a security and authorization subsystem, which the DBA uses to create accounts and specify account restrictions.

A

TRUE

37
Q

Databases cannot be used to provide persistent storage for program objects and data structures.

A

FALSE

Databases can*

38
Q

A database represents some aspect of the real world, sometimes called mini world.

A

TRUE

39
Q

A fundamental characteristic of the database approach is that the database system contains not only the database itself but also a complete definition or description of the database structure and constraints.

A

TRUE

40
Q

The backup and recovery subsystem of the DBMS is responsible for recovery.

A

TRUE

41
Q

A query is a question represented in a way that the DBMS can recognize and process.

A

TRUE

42
Q

The simplest type of integrity constraint involves specifying a data type for each data item.

A

TRUE

43
Q

A random assortment of data can be referred to as a database.

A

FALSE

44
Q

A database typically has many users, each of whom may require only one perspective or view of the database.

A

FALSE

45
Q

It is the responsibility of database administrators to communicate with all prospective database users, in order to understand their requirements, and to come up with a design that meets these requirements.

A

FALSE

46
Q

A database is designed, built, and populated with data for a specific purpose.

A

TRUE

47
Q

A DBMS must have the capability to represent a variety of complex relationships among the data as well as to retrieve and update related data easily and efficiently.

A

TRUE

48
Q

A database cannot be of any size and of varying complexity.

A

FALSE

49
Q

A database is a random collection of data with some inherent meaning.

A

FALSE

CE 165 : DATABASE MANAGEMENT SYSTEM (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions