Brainscape's Knowledge GenomeTM

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


See full index

Database > Final Exam - MC > Flashcards

Final Exam - MC Flashcards

1
Q

Which of the following have affected the way businesses use computing systems to meet the demand of the competitive marketplace?

A) GUI evolutions
B) Networking advances
C) Communication changes
D) All of the above

A

D) All of the above

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

Which of the following is a component of processing logic?

A) Input
B) Output
C) Retrieval
D) Business rules

A

D) Business rules

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

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a(n):

A) file server.
B) file processor.
C) database server.
D) fat client.

A

C) database server.

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

4) ________ is the process of assigning pieces of application code to clients or servers.

A) Application partitioning
B) Modularizing programs
C) Code distribution
D) Program breakup

A

A) Application partitioning

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q 
Which of the following is not a common distribution logic for two-tiered server environments?  
A) Fat client 
B) Tall client 
C) Thin client 
D) Distributed
A

B) Tall client

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

________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved.

A) User interface enhancers
B) Middleware
C) Interface managers
D) MPP

A

B) Middleware

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

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer’s operating system.

A) API
B) MOM
C) RPC
D) LAN

A

A) API

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

An application programming interface that enables an application program to process RDBMS databases meets the:

A) object linking and embedding standard.
B) open database connectivity standard.
C) multi-platform connectivity standard.
D) open source standard.

A

A) object linking and embedding standard.

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

A PC configured to handle user interface with little or no local storage is called a:

A) server.
B) fat client.
C) thin client.
D) workstation.

A

C) thin client.

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

A Web server:

A) is used only to host Web pages.
B) processes client requests and returns HTML pages to the client.
C) always contains a database.
D) is considered to be part of the firewall.

A

B) processes client requests and returns HTML pages to the client.

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

A join operation:

A) brings together data from two different fields.
B) causes two tables with a common domain to be combined into a single table or view.
C) causes two disparate tables to be combined into a single table or view.
D) is used to combine indexing operations.

A

B) causes two tables with a common domain to be combined into a single table or view.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q 
A join in which the joining condition is based on equality between values in the common columns is called a(n): 
A) equi-join. 
B) unilateral join. 
C) natural join. 
D) both A and C.
A

D) both A and C.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q 
A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n): 
A) equi-join. 
B) natural join. 
C) multivariate join. 
D) inner join.
A

B) natural join.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q 
The most commonly used form of join operation is the: 
A) outer join. 
B) union join. 
C) equi-join. 
D) natural join.
A

C) equi-join.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q 
A join in which rows that do not have matching values in common columns are still included in the result table is called a(n): 
A) natural join. 
B) equi-join. 
C) outer join. 
D) union join.
A

B) equi-join.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q 
The outer join syntax does not apply easily to a join condition of more than \_\_\_\_\_\_\_\_ tables. 
A) two 
B) three
C) four
D) five
A

A) two

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

In which of the following situations would one have to use an outer join in order to obtain the desired results?
A) A report is desired that lists all customers who placed an order.
B) A report is desired that lists all customers and the total of their orders.
C) A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).
D) There is never a situation that requires only an outer join.

A

B) A report is desired that lists all customers and the total of their orders.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q 
One major advantage of the outer join is that: 
A) information is easily accessible. 
B) information is not lost. 
C) the query is easier to write. 
D) all of the above.
A

B) information is not lost.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q 
An operation to join a table to itself is called a:
A) sufficient-join.
B) inner join.
C) outer join.
D) self-join.
A

D) self-join.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q 
A type of join where a table is joined to itself is called a(n):
A) unary join.
B) self-join.
C) unnatural join.
D) pinned join.
A

B) self-join.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q 
The analysis of summarized data to support decision making is called:
A) operational processing.
B) informational processing.
C) artificial intelligence.
D) data scrubbing.
A

B) informational processing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q 
The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:
A) subject-oriented.
B) integrated.
C) time-variant.
D) nonvolatile.
A

B) integrated.

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

When we consider data in the data warehouse to be time-variant, we mean:
A) that the time of storage varies.
B) data in the warehouse contain a time dimension so that they may be used to study trends and changes.
C) that there is a time delay between when data are posted and when we report on the data.
D) none of the above.

A

B) data in the warehouse contain a time dimension so that they may be used to study trends and changes.

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

Which of the following advances in information systems contributed to the emergence of data warehousing?
A) Improvements in database technology, particularly the relational data model
B) Advances in computer hardware, especially affordable mass storage and parallel computer architectures
C) Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms
D) All of the above

A

D) All of the above

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

Which of the following factors drive the need for data warehousing?
A) Businesses need an integrated view of company information.
B) Informational data must be kept together with operational data.
C) Data warehouses generally have better security.
D) None of the above.

A

A) Businesses need an integrated view of company information.

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

Which of the following organizational trends does not encourage the need for data warehousing?
A) Multiple, nonsynchronized systems
B) Focus on customer relationship management
C) Downsizing
D) Focus on supplier relationship management

A

C) Downsizing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q 
Informational systems are designed for all of the following EXCEPT:
A) running a business in real time.
B) supporting decision making.
C) complex queries.
D) data mining.
A

A) running a business in real time.

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

Operational and informational systems are generally separated because of which of the following factors?
A) A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.
B) A properly designed data warehouse adds value to data by improving their quality and consistency.
C) A separate data warehouse eliminates contention for resources that results when informational applications are confounded with operational processing.
D) All of the above.

A

D) All of the above.

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

A data mart is a(n):
A) enterprise wide data warehouse.
B) smaller system built upon file processing technology.
C) data warehouse that is limited in scope.
D) generic on-line shopping site.

A

C) data warehouse that is limited in scope.

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

One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts. This complexity is caused by not only having to access data from separate databases, but also from:
A) the possibility of a new generation of inconsistent data systems, the data marts themselves.
B) lack of user training.
C) denormalized data.
D) incongruent data formats.

A

D) incongruent data formats.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q 
A(n) \_\_\_\_\_\_\_\_ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.
A) distributed database
B) decentralized database
C) unlinked database
D) data repository
A

B) decentralized database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q 
Which of the following are business conditions that encourage the use of distributed databases?
A) Business unit autonomy
B) Data sharing needs
C) Data communication reliability
D) All of the above
A

D) All of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q 
Which of the following environments uses the same DBMS at each node with a central or master DBMS coordinating database access across nodes?
A) Centralized; maximum
B) Centralized; minimum
C) Homogeneous; nonautonomous
D) Federated; nonautonomous
A

C) Homogeneous; nonautonomous

34
Q 
Which of the following environments uses a different DBMS at each node and supports local databases for unique data requests?
A) Gateways; local
B) Centralized; minimum
C) Homogeneous; cross-linked
D) Heterogeneous; federated
A

D) Heterogeneous; federated

35
Q 
Which of the following supports a simple path to other databases, without the benefits of one logical database?
A) Linked; differential
B) Gateways
C) Autonomous; cross-linked
D) Federated; nonautonomous
A

B) Gateways

36
Q

Which of the following characterizes homogeneous environments?
A) Contains simple pathways
B) Same DBMS used at all locations
C) Some users require only local access
D) Cross-linked systems easily communicate

A

B) Same DBMS used at all locations

37
Q 
\_\_\_\_\_\_\_\_ is a design goal for a distributed database, which says a user does not need to know the location of data to use the data.
A) Location transparency
B) Location autonomy
C) Location dependency
D) Distributed locatability
A

A) Location transparency

38
Q 
Which of the following is true of distributed databases?
A) Less reliable
B) Better local control
C) Slower response time
D) None of the above
A

B) Better local control

39
Q 
Which of the following is true of data replication?
A) Additional storage requirements
B) Faster response
C) Node decoupling
D) All of the above
A

D) All of the above

40
Q

All of the following are disadvantages of data replication EXCEPT:
A) storage requirements.
B) reduced network traffic at prime time.
C) complexity and cost of updating.
D) none of the above.

A

B) reduced network traffic at prime time.

41
Q

Which of the following is a reason for using an object-oriented design?
A) The analysis model is not formal enough to be implemented in a programming language.
B) The actual system must be adapted to the environment in which the system will actually be implemented.
C) The analysis results can be validated using object-oriented design.
D) All of the above.

A

D) All of the above.

42
Q

All of the following are benefits of object-oriented modeling EXCEPT:
A) the ability to tackle more challenging problem domains.
B) increased consistency among analysis, design, and programming activities.
C) decreased communication among the users, analysts, designers, and programmers.
D) reusability of analysis, design, and programming results.

A

C) decreased communication among the users, analysts, designers, and programmers.

43
Q

The Unified Modeling Language:
A) is a notation useful for graphically depicting an object-oriented analysis or design model.
B) allows one to capture design decisions of a system.
C) promotes communication among key personnel involved in development.
D) all of the above.

A

D) all of the above.

44
Q 
A(n) \_\_\_\_\_\_\_\_ is a concept, abstraction, or thing that has a state, behavior, and identity.
A) relationship
B) attribute
C) key
D) object
A

D) Object

45
Q 
A(n) \_\_\_\_\_\_\_\_ encompasses an object's properties and the values of those properties.
A) state
B) attribute
C) method
D) behavior
A

A) state

46
Q 
Which of the following refers to a set of objects that share common structures and behaviors?
A) Supertype
B) Object class
C) Model
D) Entity group
A

A) Supertype

47
Q 
A diagram that shows the static structure of an object-oriented model is called a(n):
A) structure diagram.
B) class diagram.
C) entity diagram.
D) none of the above.
A

B) class diagram.

48
Q 
A graph of instances that are compatible within a class diagram is called a(n):
A) object group.
B) method chart.
C) object diagram.
D) ERD.
A

C) object diagram.

49
Q 
Which of the following is a function or service provided by all instances of a class?
A) Operation
B) Implementation
C) Class group
D) Query
A

A) Operation

50
Q 
\_\_\_\_\_\_\_\_ is the technique of hiding the internal implementation details of an object from its external view.
A) Grouping
B) Encapsulation
C) Classification
D) Mining
A

B) Encapsulation

51
Q

Object-oriented databases never took off because of:
A) lack of organizational inertia.
B) lack of powerful query capabilities found in relational databases.
C) a less sophisticated mathematical model.
D) all of the above.

A

D) all of the above.

52
Q 
Storing the state of an object between application execution sessions is called providing \_\_\_\_\_\_\_\_ to the object.
A) stateness
B) persistence
C) quality
D) data
A

B) persistence

53
Q 
Object-oriented languages provide a built-in mechanism for storing a persistent state of an object. This is called:
A) serialization.
B) persistence.
C) integrity constraints.
D) none of the above.
A

A) serialization.

54
Q

A technique to define structural relationships between object-oriented and relational representations of data is called:
A) object-oriented relational database management systems.
B) persistence.
C) object-relational mapping.
D) relation object mapping.

A

C) object-relational mapping.

55
Q

The conceptual gap between the object-oriented approach to application design and the relational model is often labeled as a:
A) mismatch.
B) schism.
C) void.

A

A) mismatch.

56
Q

All of the following are elements of the object-relational impedance mismatch EXCEPT:
A) nature and granularity of data types.
B) methods of assessing non-persistent data.
C) architectural styles.
D) structural relationships.

A

B) methods of assessing non-persistent data.

57
Q 
The property of an object that separates it from other objects based on its existence is called:
A) object orientation.
B) object persistence.
C) object identity.
D) matrix of objects.
A

C) object identity.

58
Q 
The identity of the \_\_\_\_\_\_\_\_ is dealt with differently in the object-oriented and relational worlds.
A) attributes
B) entities
C) objects
D) core elements
A

D) core elements

59
Q 
A(n) \_\_\_\_\_\_\_\_ is a method that provides other objects with access to the state of an object.
A) accessor method
B) attribute method
C) concrete method
D) abstract method
A

A) accessor method

60
Q 
\_\_\_\_\_\_\_\_ has been an industry standard for a call-level application program interface with which Java programs can access SQL databases.
A) ODBC
B) JDBC
C) XML
D) SOAP
A

B) JDBC

61
Q 
The \_\_\_\_ package is designed to work with MySQL version 4.1.3 and higher.
A) mysql
B) libmysql
C) mysqli
D) ext_mysqli
A

B) libmysql

62
Q 
To open a connection to a MySQL database server, use \_\_\_\_.
a.
mysql_connect()
c.
connection_mysql()
b.
open_connect()
d.
open_mysql()
A

A) mysql_connect()

63
Q 
3. To close a database connection, use \_\_\_\_.
a.
close_connection()
c.
mysql_exit()
b.
mysql_close()
d.
close_mysql()
A

mysql_close()

64
Q 
4. To return information about the MySQL database server version, use the \_\_\_\_ function.
a.
mysql_get_client_info()
b.
mysql_host_info(connection)
c.
mysql_get_proto_info(connection)
d.
mysql_get_server_info(connection)
A

mysql_get_client_info()

65
Q 
5. The \_\_\_ function returns a text string describing the error in PHP code.
a.
mysql_error()
c.
mysql_err()
b.
mysql_errno()
d.
mysql_error_number()
A

mysql_errno()

66
Q 
6. The symbol (@), used to suppress error messages, is called \_\_\_\_.
a.
supression operator
c.
null operator
b.
error control operator
d.
no_error operator
A

error control operator

67
Q 
7. You select a database or change to a different database with the \_\_\_\_ function.
a.
mysql_select_database()
c.
mysql_select_db()
b.
mysql_change_database()
d.
mysql_change_db()
A

mysql_select_database()

68
Q 
8. To delete a database, use the \_\_\_\_ function.
a.
mysql_delete_db()
c.
mysql_delete_database()
b.
mysql_drop_db()
d.
mysql_drop_database()
A

mysql_drop_db()

69
Q 
9. Almost every command sent to MySQL from PHP  is executed with the \_\_\_\_ function.
a.
mysql_connect()
c.
mysql_send()
b.
mysql_select()
d.
mysql_query()
A

mysql_query()

70
Q 
10. A result pointer is a special type of \_\_\_\_ that refers to the currently selected row in a resultset.
a.
variable
c.
function
b.
option
d.
command
A

variable

71
Q

Which of the following is not a tool for maintaining state information with PHP?

a. hidden form fields
b. query strings
c. functions
d. cookies

A

c. functions

72
Q
  1. You can access the values submitted from the form by using the $_GET[] and ____ autoglobals.
    a. $_POST[] c. $_RETRIEVE[]
    b. $_FIND[] d. $_SEND[]
A

a. $_POST[]

73
Q

Cookies can be temporary or ____.

a. persistent c. invisible
b. relational d. hidden

A

a. persistent

74
Q

Web browsers can limit the total number of cookies stored on a user’s computer to at least ____.

a. 200
c. 400
b. 300
d. 500

A

b. 300

75
Q
  1. PHP allows you to store cookie values in indexed or associative ____.
    a. functions c. arrays
    b. text files d. scripts
A

b. text files

76
Q

To set the expire date of a persistent cookie, use PHP’s ____ function and add to it an integer in seconds to specify when the cookie should be deleted.

a. date() c. time()
b. expire() d. day()

A

b. expire()

77
Q

The ____ argument determines the availability of a cookie to other Web pages on a server.

a. secure c. path
b. expires d. domain

A

c. path

78
Q

The ____ argument indicates that a cookie can only be transmitted across a secure Internet connection using HTTPS or another security protocol.

a. secure c. domain
b. expires d. path

A

a. secure

79
Q

If you want to store state information that will be available when a client revisits your Web site in the future, you must use ____.

a. sessions c. autoglobals
b. cookies d. hidden form fields

A

a. sessions

80
Q

Whenever you need to work with sessions in a PHP script, you must call the ____ function.

a. set_cookie()
c. keyword()
b. session_start() d. session_stop()

A

b. session_start()

Database (6 decks)

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