Copy and Edit

Chapter 16 (Multiple Choice) CIS 3365

Description

asdf Quiz on Chapter 16 (Multiple Choice) CIS 3365, created by . . on 08/09/2016.
. .
Quiz by . ., updated more than 1 year ago
. .
Created by . . over 7 years ago
483
2
0

Resource summary

Question 1

Question
1.A DBMS facilitates ____.
Answer
  • A) interpretation and presentation of data in useful formats
  • B) destruction of data and information to the right people at the right time
  • C) data presentation and data usage monitoring for adequate periods of time
  • D) automatic auditing of all data changes

Question 2

Question
2. At the level of middle management, the database must be able to ____.
Answer
  • A) represent and support the company operations as closely as possible
  • B) deliver the data necessary for tactical decisions and planning
  • C) produce query results within specified performance levels
  • D) provide access to external and internal data to identify growth opportunities and to chart the direction of such growth

Question 3

Question
3.When introducing a database into an organization, a(n) ____ impact is likely because the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions.
Answer
  • A) cultural
  • B) managerial
  • C) technical
  • D) operational

Question 4

Question
4.The person responsible for the control of the centralized and shared database is the database ____.
Answer
  • A) analyst
  • B) administrator
  • C) programmer
  • D) user

Question 5

Question
5.It is common practice to define the DBA function by dividing the DBA operations according to the____ phases.
Answer
  • A) SLA
  • B) DBLC
  • C) SDLC
  • D) MRA

Question 6

Question
6.There is a growing trend toward ____ in the data-management function.
Answer
  • A) cross-training
  • B) encapsulation
  • C) specialization
  • D) centralization

Question 7

Question
7.The ____ administrator is responsible for strategic planning.
Answer
  • A) system
  • B) data
  • C) database
  • D) program

Question 8

Question
8.The DBA’s ____ role is focused on personnel management and on interactions with the end-user community.
Answer
  • A) administrative
  • B) arbitration
  • C) technical
  • D) managerial

Question 9

Question
9. As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.
Answer
  • A) control and planning
  • B) conflict and problem-resolution
  • C) policies and standards
  • D) security and privacy

Question 10

Question
10.The DBA’s ____ role covers activities involving the use of the DBMS.
Answer
  • A) administrative
  • B) arbitration
  • C) technical
  • D) managerial

Question 11

Question
11.____ are general statements of direction or action that communicate and support DBA goals.
Answer
  • A) standards
  • B) policies
  • C) documentation
  • D) procedures

Question 12

Question
12.____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.
Answer
  • A) guidelines
  • B) standards
  • C) procedures
  • D) documentation

Question 13

Question
13.____ are written instructions that describe a series of steps to be followed during the performance of a given activity.
Answer
  • A) policies
  • B) standards
  • C) documentation
  • D) procedures

Question 14

Question
14.“All users must have passwords” is an example of a ____.
Answer
  • A) rule
  • B) policy
  • C) standard
  • D) procedure

Question 15

Question
15.Instructions to create a password are an example of a ____.
Answer
  • A) rule
  • B) policy
  • C) standard
  • D) procedure

Question 16

Question
16. The ____ is responsible for ensuring database security and integrity.
Answer
  • A) database programmer
  • B) systems analyst
  • C) data administrator
  • D) database security office

Question 17

Question
17.Procedures and standards must be revised at least ____ to keep them up-to date.
Answer
  • A) weekly
  • B) monthly
  • C) every six months
  • D) annually

Question 18

Question
18.Current data distribution philosophy makes it easy for ____end users to access the database.
Answer
  • A) limited
  • B) unauthorized
  • C) authorized
  • D) any

Question 19

Question
19.A(n) ____ plan is a set of instructions generated at application compilation time that predetermine show the application will access the database at run time.
Answer
  • A) access
  • B) completion
  • C) application
  • D) communications

Question 20

Question
20.____activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications.
Answer
  • A) Backup and recovery
  • B) system support
  • C) performance monitoring and tuning
  • D) security auditing and monitoring

Question 21

Question
21.____deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose.
Answer
  • A) integrity
  • B) compliance
  • C) availability
  • D) confidentiality

Question 22

Question
22.____ security breaches include database access by computer viruses and by hackers whose actions are designed to destroy or alter data.
Answer
  • A) Dangerous
  • B) Preserving
  • C) Corrupting
  • D) Authorized

Question 23

Question
23.____ management is designed to limit access to the database.
Answer
  • A) Authorization
  • B) User access
  • C) View
  • D) DBMS utility

Question 24

Question
24. Some common physical security practices found in large database installations include secured entrances, password-protected workstations, ____, closed-circuit video, and voice-recognitiontechnology.
Answer
  • A) drug testing
  • B) fingerprinting
  • C) electronic personnel badges
  • D) retina scans

Question 25

Question
25.User-access management is a subset of ____.
Answer
  • A) password protection
  • B) authorization management
  • C) data integrity
  • D) managerial control

Question 26

Question
26.Classifying users into ____ according to common access needs facilitates the DBA’s job of controlling and managing the access privileges of individual users.
Answer
  • A) user groups
  • B) sections
  • C) authorization schemes
  • D) policy definitions

Question 27

Question
27.Several DBMS packages contain features that allow the creation of a(n) ____, which automatically records a brief description of the database operations performed by all users.
Answer
  • A) change tracker
  • B) digital footprint
  • C) paper trail
  • D) audit log

Question 28

Question
28.A(n) ____ data dictionary is automatically updated by the DBMS with every database access.
Answer
  • A) dynamic
  • B) active
  • C) passive
  • D) static

Question 29

Question
29.A(n) ____ data dictionary is not updated automatically and usually requires a batch process to be run.
Answer
  • A) active
  • B) passive
  • C) static
  • D) dynamic

Question 30

Question
30.____ CASE tools provide support for the planning, analysis, and design phases.
Answer
  • A) Front-end
  • B) Back-end
  • C) Vertical
  • D) Horizontal

Question 31

Question
31.____ CASE tools provide support for the coding and implementation phases.
Answer
  • A) Front-end
  • B) Back-end
  • C) Vertical
  • D) Horizontal

Question 32

Question
32.The ____ component of a CASE tool produces the information system’s input/output formats.
Answer
  • A) analysis
  • B) graphics
  • C) program document generator
  • D) screen painter and report generator

Question 33

Question
33.____ allows for the translation of the company’s strategic goals into the data and applications that will help the company achieve those goals.
Answer
  • A) Access Management
  • B) Business Intelligence
  • C) Information engineering (IE)
  • D) MOLAP

Question 34

Question
34.A(n) ____ serves as the basis for planning, development, and control of future information systems.
Answer
  • A) access plan
  • B) active data dictionary
  • C) information systems architecture (ISA)
  • D) security policy

Question 35

Question
35.A(n) ____ is a logical storage space in Oracle.
Answer
  • A) audit log
  • B) datafile
  • C) schema
  • D) tablespace

Question 36

Question
36.In the Oracle Enterprise Manager, a ____ is basically any object created by end users; for example, tables, views, indexes, stored procedures, and triggers.
Answer
  • A) component
  • B) database object
  • C) policy
  • D) role

Question 37

Question
37.A ____ is a uniquely identifiable object that allows a given person to log on to the database.
Answer
  • A) user
  • B) role
  • C) profile
  • D) manager

Question 38

Question
38.A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
Answer
  • A) user
  • B) role
  • C) profile
  • D) manager

Question 39

Question
39.A ____ is a named collection of settings that control how much of the database resource a given user can use.
Answer
  • A) user
  • B) role
  • C) profile
  • D) manager

Question 40

Question
40.One of the important functions provided by the database ____ is to reserve the resources that must be used by the database at run time.
Answer
  • A) security component
  • B) authorization manager
  • C) initialization parameters
  • D) administrator
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

El Perdón
Alonso Linares
Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Irene
i.biza
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Browse Library