Chapter 7: Database Management
fat client
A client PC that is responsible for processing presentation logic, extensive application and business rules logic, and many DBMS functions.
A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.
API
ODBC (Open Database Connectivity)
An interface for accessing database management systems that can be ported to other systems by using a driver.
All of the following are additional methods of Web security EXCEPT:
Blacklist bad users
A mechanism in a ResultSet object in Java that points to the current row of data is called a:
Cursor
The role that is responsible for developing overall policies and procedures for database security is:
Data Administration
The role responsible for administering database security is:
Database Administration
A computer that provides database storage and access in a client/server environment is called a(n):
Database server
Which of the following is not a basic step to accessing a database from an application:
Define physical storage
Many Python web applications use:
Django
A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.
Exclusive lock
A shared lock prevents another transaction from reading a record. (T/F)
False
A transaction is consistent if it always runs with the same amount of memory. (T/F)
False
A transaction is durable if it can resist failure. (T/F)
False
An API is a set of routines that a database server uses to access database objects. (T/F)
False
An application server provides basic functionality for receiving and responding to requests from browsers. (T/F)
False
Business rules logic includes such activities as data validation and identification of processing errors.
False
During multiple simultaneous transactions data integrity is maintained by logging. (T/F)
False
Storage logic is provided by an application server. (T/F)
False
Three-tier architectures generally result in higher long-term costs. (T/F)
False
Versioning is a pessimistic approach to concurrency control. (T/F)
False
A data-interchange format easily for humans to read and machines to parse and process is called:
JavaScript Object Notation (JSON)
Which of the following threats involves outside parties using information to embarrass a company?
Loss of confidentiality
The architecture that most applicaitons use that separates the business logic, presentation logic, and database logic is called:
Model-view-controller
All of the following are well-accepted characteristics of transactions EXCEPT:
Persistence
The W3C standard for Web privacy is called:
Platform for Privacy Preferences
All of the following are key components of a web application EXCEPT:
Processing-logic server
An application server
Provides the building blocks for creating dynamic web sites and web-based applications.
Security measures for dynamic Web pages are different from static HTML pages because:
The connection requires full access to the database for dynamic pages
A PC configured to handle user interfaces with limited local storage is called a(n):
Thin client
A client/server configuration that has three layers (one client and two servers) has a three-tier architecture. (T/F)
True
All .html files can be processed by the web server itself. (T/F)
True
All transactions must have the ACID characteristics. (T/F)
True
Java servlets execute from within another program and reside on the server. (T/F)
True
The LAMP stack consists of Apache, PHP, and MySQL. (T/F)
True
The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen. (T/F)
True
An optimistic approach to concurrency control is called:
Versioning
A transaction is considered isolated when:
any changes in the database are not revealed to the user until the transaction is complete
The client/server architectures that have evolved can be distinguished by the distribution of _______ across clients and servers
application logic components
________ is the process of assigning pieces of application code to clients or servers.
application partitioning
The extent of teh database resource that is included with each lock is called the level of:
lock granularity
A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.
two-phase lock
Geolocation logic is the application logic component responsible for data storage and retrieval. (T/F)
False