5370 Quiz 7
Which of the following is a component of processing logic?
Business rules
Many Python web applications use:
Django.
A fat client does most of its processing on the server.
False
A shared lock prevents another transaction from reading a record.
False
Geolocation logic is the application logic component responsible for data storage and retrieval.
False
Storage logic is provided by an application server.
False
The process of assigning parts of an application to a client or server is called application partitioning.
False
Three-tier architectures generally result in higher long-term costs.
False
Versioning is a pessimistic approach to concurrency control.
False
When developing an application, one must decide where it will be placed when it is developed.
False
One major disadvantage of JSP is:
HTML, Java code, and SQL are mixed together.
The LAMP stack consists of all of the following EXCEPT:
IIS.
The W3C standard for Web privacy is called:
Platform for Privacy Preferences.
A common encryption method to secure data traveling between a client and a server is called:
Secure Sockets Layer (SSL).
All .html files can be processed by the web server itself.
True
Client/server describes an networked computing model that distributes processes between computers that request services and computers that provide services.
True
Database administrators are responsible for administering database security.
True
In some three-tier architectures, most application code is stored on the application server.
True
Level of lock granularity is the extent of a database resource include with each lock.
True
ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.
True
Restricting access to the Web server is one method of Web security.
True
The LAMP stack consists of Apache, PHP, and MySQL.
True
The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.
True
Two-phase locking is a procedure for acquiring locks for a transaction before any are released.
True
In order for a transaction to be consistent:
any database constraints that must be true before the transaction must also be true after the transaction.
The client/server architectures that have evolved can be distinguished by the distribution of _____ across clients and servers.
application logic components
A(n) prevents another transaction from reading and therefore updating a record until it is unlocked.
exclusive lock
A client PC that is responsible for processing presentation logic, extensive application and business rules logic, and many DBMS functions is called a(n):
fat client.
A sequence of steps that constitute a well-defined business activity is called a:
transaction.
An optimistic approach to concurrency control is called:
versioning.
