Database Chapter 7
________ is the process of assigning pieces of application code to clients or servers.
Application partitioning
An API is a set of routines that a database server uses to access database objects.
False
An application server provides basic functionality for receiving and responding to requests from browsers.
False
The LAMP stack consists of all of the following EXCEPT:
IIS.
________ 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.
Middleware
All .html files can be processed by the web server itself.
True
Since dynamic Web pages require full access to the database, security is different from static HTML pages
True
The Magna Carta is the W3C standard for Web privacy.
False
When changes to the database that a transaction imposes are not revealed to the user until the transaction is completed then it is considered isolated.
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.
All of the following are well-accepted characteristics of transactions EXCEPT:
Persistence.
The LAMP stack consists of Apache, PHP and MySQL.
True
A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.
API
Random password guessing is a type of network security.
False
Two-tier architectures are much more scalable than three-tier architectures.
False
When developing an application, one must decide where it will be placed when it is developed.
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
A common encryption method to secure data traveling between a client and a server is called:
Secure Sockets Layer (SSL).
A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client
True
Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server, depending upon which location will give the best performance.
True
In some three-tier architectures, most application code is stored on the application server.
True
The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.
True
The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.
True
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.
A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.
exclusive lock
Which of the following is a component of processing logic?
Business rules
Many Python web applications use:
Django.
A database is a sequence of steps that constitute a well-defined business activity.
False
A transaction is durable if it can resist failure.
False
Geolocation logic is the application logic component responsible for data storage and retrieval.
False
Loss of data integrity means that someone has stolen data from the database server.
False
Client/server describes a 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
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
Open Database Connectivity is an application programming interface that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed.
True
Restricting access to the Web server is one method of Web security.
True
The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.
concurrency control
A mechanism in a ResultSet object in Java that points to the current row of data is called a:
cursor
All of the following are advantages of stored procedures EXCEPT:
portability.
All of the following are key components of a web application EXCEPT:
processing-logic server.
Security measures for dynamic Web pages are different from static HTML pages because:
the connection requires full access to the database for dynamic pages.
How the database results are read into memory is determined by:
the database driver.
A PC configured to handle user interfaces with limited local storage is called a(n):
thin 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.
The role responsible for administering database security is:
Database Administration.
Which of the following is NOT a common distribution logic for two-tiered server environments?
Tall client
Which Java method retrieves the next row of a cursor?
next()
An application server
provides the building blocks for creating dynamic web sites and web-based applications.
The role that is responsible for developing overall policies and procedures for database security is:
Data Administration.
A fat client does most of its processing on the server.
False
A shared lock prevents another transaction from reading a record.
False
ABET is a common encryption method used to secure data traveling between a client and a server.
False
Database administrators are responsible for developing overall policies and procedures for database security.
False
During multiple simultaneous transactions data integrity is maintained by logging.
False
Storage logic is provided by an application server.
False
The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers.
application logic components
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.