Deck 7: Databases in Applications

Question 1

________ 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

Answer 1

A

Question 2

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

Answer 2

A

Question 3

The architecture that most applications use that separates the business logic, presentation logic, and database logic is called:

A) model-value-controller.
B) model-view-controller.
C) JSP.
D) frameworks.

Answer 3

B

Question 4

One major disadvantage of JSP is:

A) it runs slow.
B) HTML, Java cod,e and SQL code are mixed together.
C) it is not popular.
D) it does not use XML.

Question 5

________ 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

Question 6

Many Python web applications use:

A) iPython.
B) Django.
C) jQuery.
D) stored procedures.

Question 7

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers.

A) memory
B) files
C) application logic components
D) query logic components

Question 8

A mechanism in a ResultSet object in Java that points to the current row of data is called a:

A) stored procedure.
B) trigger.
C) table.
D) cursor.

Question 9

Which of the following is a component of processing logic?

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

Question 10

A PC configured to handle user interfaces with limited local storage is called a(n):

A) fat client.
B) thin client.
C) light client.
D) overweight client.

Question 11

A data-interchange format easily for humans to read and machines to parse and process is called:

A) Java Oriented Notation (JON).
B) HTML.
C) XML.
D) JavaScript Object Notation (JSON).

Question 12

The LAMP stack consists of all of the following EXCEPT:

A) Apache.
B) MySQL.
C) PHP or Python.
D) IIS.

Question 13

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:

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

Question 14

Which Java method retrieves the next row of a cursor?

A) next()
B) first()
C) get()
D) load()

Question 15

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

Question 16

Which of the following is not a basic step to accessing a database from an application:

A) register database driver.
B) open a connection.
C) define physical storage.
D) query the database.

Question 17

All of the following are key components of a web application EXCEPT:

A) database server.
B) web server.
C) processing-logic server.
D) web browser.

Question 18

A computer that provides database storage and access in a client/server environment is called a(n):

A) database server.
B) file server.
C) cloud data store.
D) info server.

Question 19

An application server

A) provides basic functionality for receiving and responding to requests from browsers.
B) provides the building blocks for creating dynamic web sites and web-based applications.
C) provides storage logic.
D) none of the above.

Question 20

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

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

Question 21

All of the following are well-accepted characteristics of transactions EXCEPT:

A) Atomicity.
B) Consistency.
C) Persistence.
D) Durability.

Question 22

All of the following are additional methods of Web security EXCEPT:

A) restrict the number of users on the Web server.
B) restrict access to the Web server.
C) remove unneeded programs.
D) blacklist bad users.

Question 23

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.

A) record controller
B) exclusive lock
C) authorization rule
D) shared lock

Question 24

Which of the following is a type of network security?

A) Authentication of the client workstation
B) Password naming conventions
C) Guidelines for frequency of password changes
D) Random password guessing

Question 25

A sequence of steps that constitute a well-defined business activity is called a:

A) transaction.
B) transfixture.
C) database.
D) table.

Question 26

Durability means that:

A) transactions can't be erased.
B) once a transaction is committed, no subsequent failure of the database can reverse the effect of the transaction.
C) transactions can withstand failure.
D) transactions never finish on time.

Question 27

An optimistic approach to concurrency control is called:

A) versioning.
B) denormalization.
C) deadlock resolution.
D) HappyControl.

Question 28

A common encryption method to secure data traveling between a client and a server is called:

A) Secure Sockets Layer (SSL).
B) Secure Synchronization Layer (SSL).
C) RSA.
D) ITT.

Question 29

Which of the following threats involves outside parties using information to embarrass a company?

A) Accidental loss
B) Theft and fraud
C) Loss of confidentiality
D) Loss of data integrity

Question 30

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.

A) logging
B) concurrency control
C) transaction authorization
D) multiple management

Question 31

How the database results are read into memory is determined by:

A) the program.
B) the database driver.
C) the operating system.
D) none of the above.

Question 32

Security measures for dynamic Web pages are different from static HTML pages because:

A) dynamic Web pages are built "on the fly."
B) static Web pages contain more sensitive data.
C) the connection requires full access to the database for dynamic pages.
D) HTML is more complex than dynamic Web pages.

Question 33

A transaction is considered isolated when:

A) it runs in a vacuum.
B) any changes in the database are not revealed to the user until the transaction is complete.
C) it can only be run on one server.
D) users can see changes to tables before the transaction is complete.

Question 34

All of the following are advantages of stored procedures EXCEPT:

A) performance improves for compiled SQL statements.
B) network traffic deceases.
C) portability.
D) thinner client.

Question 35

A business transaction requires:

A) a trigger.
B) a stored procedure.
C) several actions against the database.
D) human intervention.

Question 36

The extent of the database resource that is included with each lock is called the level of:

A) impact.
B) management.
C) lock granularity.
D) TIO.

Question 37

The role responsible for administering database security is:

A) Data Administration.
B) Database Administration.
C) Security.
D) Developers.

Question 38

The role that is responsible for developing overall policies and procedures for database security is:

A) Data Administration.
B) Database Administration.
C) Database Development.
D) Accounting.

Question 39

In order for a transaction to be consistent:

A) it must run the same way all the time.
B) it must tell the truth.
C) it must run using the same amount of memory.
D) any database constraints that must be true before the transaction must also be true after the transaction.

Question 40

A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

A) record controller
B) exclusive lock
C) authorization rule
D) two-phase lock

Question 41

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

Question 42

Two-tier architectures are much more scalable than three-tier architectures.

Question 43

Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.

Question 44

An API is a set of routines that a database server uses to access database objects.

Question 45

In some three-tier architectures, most application code is stored on the application server.

Question 46

Java servlets execute from within another program and reside on the server.

Question 47

Three-tier architectures generally result in higher long-term costs.

Question 48

Business rules logic includes such activities as data validation and identification of processing errors.

Question 49

Geolocation logic is the application logic component responsible for data storage and retrieval.

Question 50

A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.

Question 51

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.

Question 52

A client/server configuration that has three layers (one client and two servers) has a three-tier architecture.

Question 53

The process of assigning parts of an application to a client or server is called application partitioning.

Question 54

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.

Question 55

The W3C standard for Web privacy is called:

A) the Web privacy act.
B) Platform for Privacy Preferences.
C) Freedom of Web Information Act.
D) the Magna Carta.

Question 56

When developing an application, one must decide where it will be placed when it is developed.

Question 57

A web server is a key component of web applications.

Question 58

A fat client does most of its processing on the server.

Question 59

The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.

Question 60

An application server provides basic functionality for receiving and responding to requests from browsers.

Question 61

The LAMP stack consists of Apache, PHP and MySQL.

Question 62

A transaction is durable if it can resist failure.

Question 63

Loss of data integrity means that someone has stolen data from the database server.

Question 64

Database administrators are responsible for administering database security.

Question 65

Loss of confidentiality is a threat that involves outside parties using information to embarrass a company.

Question 66

Storage logic is provided by an application server.

Question 67

All .html files can be processed by the web server itself.

Question 68

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.

Question 69

Versioning is a pessimistic approach to concurrency control.

Question 70

ABET is a common encryption method used to secure data traveling between a client and a server.

Question 71

A shared lock prevents another transaction from reading a record.

Question 72

All transactions must have the ACID characteristics.

Question 73

Level of lock granularity is the extent of a database resource include with each lock.

Question 74

A transaction is consistent if it always runs with the same amount of memory.

Question 75

A database is a sequence of steps that constitute a well-defined business activity.

Question 76

During multiple simultaneous transactions data integrity is maintained by logging.

Question 77

Two-phase locking is a procedure for acquiring locks for a transaction before any are released.

Question 78

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.

Question 79

Database administrators are responsible for developing overall policies and procedures for database security.

Question 80

A business transaction requires several actions against a database.