WorksheetsWorksheet Questions Extraction
Total questions: 77
Worksheet time: 39mins
Which of the following is the first step in user interface design process?
prototype the dialogue
chart the dialogue
test the dialogue
re-design the dialogue
A process model used to communicate the overall implementation characteristics of an information system is a(n)
data model
physical data flow diagram
logical data flow diagram
class diagram
A language that is used by a DBMS to define a database or view of a database is
DML
DLL
DCL
DDL
Remote batch processing has the following characteristic(s)
Data is entered online
Data is collected in batches
Data is processed at a later time
both (a) and (b) and (c)
When presenting the content of a dialogue, which of the following should not be used?
use abbreviations so that users can read them more quickly
use simple terms
use appropriate action verbs
be consistent in the use of terminology
Which of the following is the first step in designing a system for in-house development?
design the system interface
design the application architecture
package design specifications
design the system database
Which of the following is NOT an information system application layer?
database layer
presentation layer
application logic layer
data manipulation layer
Which of the following is the last step in modeling class interactions, their behaviors, and constraints that support the use-case scenarios?
identifying class behaviors and responsibilities
identifying class attributes
identifying and classifying use-case design classes
model object states
Which of the following is a tool used to depict the sequence a variation of screen that occur during a user session?
sequence diagram
data flow diagram
object-oriented diagram
state transition diagram
Which of the following (a) are the UML level of visibility ?
persistent
public
protected
both (a) and (c)
A customer class is a class system would be an example of a(n)
interface class
entity class
control class
persistence class
A count of the number of students who earned A, B, C, D, and F grades in a given course would be an example of a(n)
external report
summary report
detailed report
exception report
If you need a student to select from a list of query courses on the university's on-line catalogue, your best choice for a GUI control would be:
check box
radio buttons
drop-down list
combination box
If you need to reflect employee status information (e.g. full-time, part-time) on a computer screen, your best choice for a GUI control would be:
drop-down list
masked edit control
radio buttons
spin box
Which property would be used primarily for report users because there is no visual clue to its presence?
iconic
pop-up
cascading
pull-down
A characteristic or property describing an entity is called a(n)
field
tuple
key field
attribute
Duplicate data in multiple data files is
data redundancy
data duplication
data independence
data backups
A DBMS:
makes the physical database available for different logical views
makes the logical database available for different analytical views
makes the physical database available for different analytical views
makes the relational database available for different analytical views
The logical view:
shows how data are organized and structured on the storage media
presents only an screen to the user
allows the creation of supplementary reports
presents data as perceived by end users
The type of logical database model that treats data as if they were stored in two-dimensional tables is the:
OODBMS
pre-digital DBMS
relational DBMS
hierarchical DBMS
In a table of customer, information about a single customer row would be a single:
field
row
column
table
In a relational database, a record is referred to in technical terms as a:
tuple
row
entity
field
A field identified in a table as holding some unique identifier of the records is called the:
primary key
key field
primary field
unique ID
A field identified in a record as holding the unique identifier for that records is called the:
primary key
key field
primary field
unique ID
DBMS for midrange computers include all of the following EXCEPT:
DB2
Oracle
Microsoft SQL Server
Microsoft Access
In a relational database, the three basic operations used to develop useful sets of data are:
select, project, and where
select, join, and where
select, project, and join
select, from, and join
The select operation:
combines relational tables to provide the user with more information
creates a subset consisting of columns in a table
identifies the table from which columns will be selected
creates a subset consisting of all records in the file that meet stated criteria
The join operation:
combines relational tables to provide the user with more information
creates a subset consisting of columns in a table
identifies the table from which the columns will be selected
creates a subset consisting of columns in a table
The data dictionary serves as an important data management tool by:
assigning attributes to the data
creating an inventory of data contained in the database
presenting data as end users or business specialists would perceive them
maintaining data in updated form
An automated or manual file that stores information about data elements and data characteristics is a:
data dictionary
data definition diagram
entity-relationship diagram
relationship dictionary
The type of database management approach that can handle multimedia is the:
hierarchical DBMS
relational DBMS
network DBMS
object-oriented DBMS
Which of the following database types is useful for storing large systems as well as processing huge numbers of transactions?
Relational DBMS
Hierarchical DBMS
Object-relational DBMS
OODBMS
This specialized language programs are used to manage and change data in the database is called:
data access language
data manipulation language
structured Query language
data definition language
The most prominent data manipulation language is:
Access
DB2
SQL
Crystal Reports
DBMS typically include report-generating tools in order to:
retrieve and display data
display data in an easier-to-read format
display data in graphs
perform predictive analysis
A schematic of the entire database that describes the relationships in a database is called a(n):
data dictionary
intersection relationship diagram
entity-relationship diagram
data definition diagram
A one-to-one relationship between two entities is symbolized in a diagram by a line that
ends in one short marks
ends in one short mark
ends with a crow's foot
ends with a crow's foot topped by a short mark
A one-to-many relationship between two entities is symbolized in a diagram by a line that
ends in two short marks
ends in one short mark
ends with a crow's foot
ends with a crow's foot topped by a short mark
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:
normalization
data scrubbing
data cleansing
data defining
In what type of a database system is the entire database replicated at all remote locations?
Partitioned
Normalized
Distributed
Networked
A data warehouse is composed of
historical data from legacy systems
current data
internal and external data sources
historic and current internal data
A data mart is a subset that can be constructed more rapidly and at lower cost than a data warehouse because
a data mart typically focuses on a single subject area or line of business.
all the information is historical
a data mart uses a Web interface
all of the information belongs to a single company
Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:
DSS
business intelligence
OLAP
data mining
The tool that enables users to view the same data in different ways using multiple dimensions is:
predictive analysis
SQL
OLAP
data mining
OLAP is a tool for enabling
users to obtain online answers to ad-hoc questions in a rapid amount of time
users to view both logical and physical views of data
programmers to quickly diagram data relationships
programmers to normalize data
Data mining is a tool for allowing users to
quickly compare transaction data gathered over many years
find hidden relationships in data
obtain online answers to ad hoc questions
summarize massive amounts of data into much smaller, traditional reports
In terms of data relationships, associations refer to
events linked over time
patterns that describe group to which an item belongs
occurrences linked to a single event
undiscovered groupings
The special organizational function that oversees all aspects of the technical and operation side of managing data is called:
data administration
database administration
information policy administration
data auditing
What is the first step you should take in managing data for a firm?
Identify the data needed to run the business
Cleanse the data before importing it to any database
Normalize the data before importing to a database
Audit your data quality
Detecting and correcting data in a database that are inaccurate, incorrect, incomplete, improperly formatted, or redundant is called:
data auditing
defragmentation
data scrubbing
data optimization
The possible specialization constraints include
disjoint and total
overlapping and total
overlapping and partial
all of above
In the process of specialization, the subclass and the superclass are linked by
lines
dotted lines
red lines
red dotted lines
The union of subclasses only when entity become part of subclass by putting some condition on attribute values is classified as
predicate segregation subclass
predicate aggregation subclass
predicate-defined subclass
indicate-defined subclass
The kinds of subclasses in which there are no constraints for deciding membership in any given subclass is classified as
visual subclass
user-defined subclass
member subclass
local subclass
The main constraints applicable in specialization are
disjointness constraint
incomplete constraint
completeness constraint
both a and c
The process of defining the entity type subclasses is classified as
type inheritance
visualization
specialization
generalization
The entity type, present class and subclass are classified as
ER schema overlapping
ER schema functions
ER schema objects
EER schema constructs
The subclass which has more than one super class is called
partial subclass
shared subclass
shared super class
joint super class
The type of subclass constraint that one entity can be member of at most one subclass is classified as
incomplete joint constraint
complete joint constraint
disjointness constraint
jointness constraint
The generalization and specialization lattices are classified as
single aggregation
multiple inheritance
single inheritance
multiple aggregation
The type of attributes that are applicable to specific subclasses is classified as
aggregate attributes
aggregate attributes
public attributes
local attributes
The type of specialization in which all the subclasses have membership condition on supers class of similar attribute is classified as
constraint-defined specialization
key-defined specialization
entity-defined specialization
attribute-defined specialization
In the process of specialization, the specific attributes are also classified as
public attributes
local attributes
aggregate attributes
segregate attributes
The predicate-defined subclasses are also known as:
condition-defined subclasses
non condition subclasses
aggregation subclasses
segregation subclasses
Consider representation of specialization and generalization, the bank triangle is used to indicate the specific construct called as:
disjoint node
shared base constraint
schema construct
disjoint constraint
Consider representation of specialization and generalization, the field triangle is used to indicate the constraint called as:
overlapping constraint
disjoint node
shared base constraint
schema construct
In the three-tier architecture, the intermediate layer between database server and client servers is classified as:
functional server
transaction server
application server
disk server
In relational database management system, the server classified as:
SQL server
SQT server
SQR server
ODBC server
The application connectivity in the three-tier architecture database management system is increased by:
close module connectivity
open module connectivity
close database connectivity
open database connectivity
The standard by which Java client programs access DBMS is classified as:
JCDB standard
JDBC standard
BDJC standard
CJDB standard
The architecture in which there is a middle level between database server and client server is classified as:
three-tier architecture
two-tier architecture
single-tier architecture
three way DBMS module
The languages used to insert, delete, modify and retrieve data in DBMS is considered as:
logical path language
external mapping language
data manipulation language
internal mapping language
The types of architectures of DBMS are:
single-tier architecture
two-tier architecture
three-tier architecture
both b and c
The program interface which provides the feature to client side program to fetch the database management system is classified as:
open programming interface
closed programming interface
application programming interface
data programming language
The function which causes the retrieval of any kind of data from database is considered as:
key
query
structure
storing cycle
The control feature in database management system which ensures the accuracy of data updated by multiple users is classified as:
conceptual implementation control
concurrency control
interface modeling control
user accessibility control
The menu-driven interface of DBMS and the forms-style interface of DBMS is classified as:
conceptual user interface
controlled user interface
graphical user interface
structural user interface
